APPS.JA_CN_CFS_CONC_PROG dependencies on GL_LEDGERS

Line 965: l_period_set_name GL_LEDGERS.period_set_name%TYPE;

961:
962: l_sob_coa_flag NUMBER;
963: l_account_type_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
964:
965: l_period_set_name GL_LEDGERS.period_set_name%TYPE;
966: l_year_from NUMBER;
967: l_year_to NUMBER;
968: BEGIN
969: --log for debug

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