DBA Data[Home] [Help]

APPS.JA_CN_CFS_CONC_PROG dependencies on GL_PERIODS

Line 1003: FROM GL_LEDGERS LEDGER, gl_periods GP1, gl_periods GP2

999: --Get Period set name, Year_From and Year_To
1000: BEGIN
1001: SELECT LEDGER.PERIOD_SET_NAME, GP1.period_year, GP2.period_year
1002: INTO l_period_set_name, l_year_from, l_year_to
1003: FROM GL_LEDGERS LEDGER, gl_periods GP1, gl_periods GP2
1004: WHERE LEDGER.Ledger_Id = p_LEDGER_ID
1005: AND GP1.PERIOD_SET_NAME = LEDGER.PERIOD_SET_NAME
1006: AND GP1.period_name = P_GL_PERIOD_FROM
1007: AND GP2.PERIOD_SET_NAME = LEDGER.PERIOD_SET_NAME