DBA Data[Home] [Help]

APPS.JA_CN_FA_EXPORT_PROG dependencies on GL_PERIOD_STATUSES

Line 377: FROM GL_PERIOD_STATUSES

373: BEGIN
374: SELECT PERIOD_NAME
375: INTO lv_period_from
376: FROM (SELECT PERIOD_NAME
377: FROM GL_PERIOD_STATUSES
378: WHERE APPLICATION_ID = 101
379: AND LEDGER_ID = pn_ledger_id
380: AND PERIOD_YEAR = pv_accounting_year
381: AND CLOSING_STATUS <> 'N'

Line 399: FROM GL_PERIOD_STATUSES

395: BEGIN
396: SELECT PERIOD_NAME
397: INTO lv_period_to
398: FROM (SELECT PERIOD_NAME
399: FROM GL_PERIOD_STATUSES
400: WHERE APPLICATION_ID = 101
401: AND LEDGER_ID = pn_ledger_id
402: AND PERIOD_YEAR = pv_accounting_year
403: AND CLOSING_STATUS <> 'N'