[Home] [Help]
435: IS
436: CURSOR c
437: IS
438: SELECT closing_status, period_name, period_type
439: FROM gl_period_statuses
440: WHERE application_id = c_gl_application_id
441: AND ledger_id = p_ledger_id
442: AND adjustment_period_flag = 'N'
443: AND TRUNC (p_accounting_date) BETWEEN start_date AND end_date;