DBA Data[Home] [Help]

APPS.JA_CN_CFS_CONC_PROG dependencies on GL_PERIODS

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

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