[Home] [Help]
281: WHERE ledger_id = v_set_of_books_id;
282:
283: SELECT distinct period_type
284: INTO statuses_period_type
285: FROM gl_period_statuses
286: WHERE application_id = '101'
287: AND ledger_id = v_set_of_books_id;
288:
289: SELECT to_char(end_date,'YYMMDD'),