237: IF pv_period_from IS NOT NULL
238: THEN
239: SELECT start_date
240: INTO ld_start_date
241: FROM gl_period_statuses
242: WHERE ledger_id = pn_ledger_id
243: AND application_id = 101
244: AND period_name = pv_period_from
245: AND to_char(period_year) = pv_accounting_year;
250: IF pv_period_to IS NOT NULL
251: THEN
252: SELECT end_date
253: INTO ld_end_date
254: FROM gl_period_statuses
255: WHERE ledger_id = pn_ledger_id
256: AND application_id = 101
257: AND period_name = pv_period_to
258: AND to_char(period_year) = pv_accounting_year;