Account Preprocessor Period details Query

SELECT DISTINCT glp.period_num, glp.period_name, glp.period_set_name,
sts.start_date, sts.end_date, sts.closing_status,
gsob.set_of_books_id, sts.set_of_books_id sts_sob_id,
plcy.legal_entity_id, glp.period_year
FROM gl_periods glp,
gl_period_statuses sts,
gl_sets_of_books gsob,
gmf_fiscal_policies plcy
WHERE glp.period_set_name = gsob.period_set_name
AND glp.period_type = gsob.accounted_period_type
AND glp.period_name = sts.period_name
AND glp.period_num = sts.period_num
AND glp.period_year = sts.period_year
AND sts.application_id =
(SELECT application_id
FROM fnd_application
WHERE application_short_name = ‘SQLGL’)
ORDER BY glp.period_num;