/*
code:gl_period_status.sql
Description: This script current period status of application (oracle 11i)
Author:      Jay Gopalakrishnan / Jiltin
Input:        &&Chart_of_accounts_id,&&application_id
*/

select gls.name, gps.closing_status from
apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls
where 1=1
and gps.start_date <= sysdate
and gps.end_date >= sysdate
and gps.set_of_books_id = gls.set_of_books_id
and gps.application_id=&&application_id
and gls.chart_of_accounts_id=&&Chart_of_accounts_id
and gls.name in ( 'OPER US','OPER Australia','OPER Japan','OPER UK', 'OPER Hong Kong','OPER Europe','OPER China' );