Query to find GL Period status
SELECT *
FROM gl_period_statuses ps,
gl_sets_of_books sob,
fnd_application_vl fnd
WHERE 1=1 and ps.application_id = 101
AND sob.set_of_books_id =
(SELECT set_of_books_id
FROM org_organization_definitions
WHERE ORGANIZATION_CODE = ‘111’)
AND fnd.application_id = ps.application_id
AND ps.adjustment_period_flag = ‘N’
AND ps.closing_status = ‘O’
AND TRUNC (SYSDATE) BETWEEN TRUNC (ps.start_date)
AND TRUNC (ps.end_date);
