APPS.JA_CN_CFS_CONC_PROG dependencies on GL_LEDGERS

Line 964: l_period_set_name GL_LEDGERS.period_set_name%TYPE;

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

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