DBA Data[Home] [Help]

APPS.JA_CN_APAR_EXPORT_PROG dependencies on GL_PERIOD_STATUSES

Line 315: FROM GL_PERIOD_STATUSES

311: BEGIN
312: SELECT PERIOD_NAME
313: INTO lv_period_from
314: FROM (SELECT PERIOD_NAME
315: FROM GL_PERIOD_STATUSES
316: WHERE APPLICATION_ID = 101
317: AND LEDGER_ID = pn_ledger_id
318: AND PERIOD_YEAR = pv_accounting_year
319: AND CLOSING_STATUS <> 'N'

Line 335: FROM GL_PERIOD_STATUSES

331: BEGIN
332: SELECT PERIOD_NAME
333: INTO lv_period_to
334: FROM (SELECT PERIOD_NAME
335: FROM GL_PERIOD_STATUSES
336: WHERE APPLICATION_ID = 101
337: AND LEDGER_ID = pn_ledger_id
338: AND PERIOD_YEAR = pv_accounting_year
339: AND CLOSING_STATUS <> 'N'