APPS.JA_CN_PS_GL_EXPORT_PROG dependencies on GL_PERIOD_STATUSES

Line 426: FROM GL_PERIOD_STATUSES

422: BEGIN
423: SELECT PERIOD_NAME
424: INTO lv_period_from
425: FROM (SELECT PERIOD_NAME
426: FROM GL_PERIOD_STATUSES
427: WHERE APPLICATION_ID = 101
428: AND LEDGER_ID = pn_ledger_id
429: AND PERIOD_YEAR = pv_accounting_year
430: AND CLOSING_STATUS <> 'N'

Line 446: FROM GL_PERIOD_STATUSES

442: BEGIN
443: SELECT PERIOD_NAME
444: INTO lv_period_to
445: FROM (SELECT PERIOD_NAME
446: FROM GL_PERIOD_STATUSES
447: WHERE APPLICATION_ID = 101
448: AND LEDGER_ID = pn_ledger_id
449: AND PERIOD_YEAR = pv_accounting_year
450: AND CLOSING_STATUS <> 'N'

Line 464: FROM GL_PERIOD_STATUSES

460: BEGIN
461: SELECT TO_CHAR(END_DATE,
462: 'YYYY/MM/DD HH:MM:SS')
463: INTO lv_accounting_date
464: FROM GL_PERIOD_STATUSES
465: WHERE APPLICATION_ID = 101
466: AND LEDGER_ID = pn_ledger_id
467: AND PERIOD_NAME = lv_period_to;
468: EXCEPTION