APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_LEDGERS

Line 174: ,GL_LEDGERS ledger

170: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
171: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
172: seg_fsav_gcc
173: FROM GL_CODE_COMBINATIONS gcc
174: ,GL_LEDGERS ledger
175: ,FND_ID_FLEX_SEGMENTS FIFS
176: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
177: ,FND_FLEX_VALUE_SETS FFVS
178: ,FND_FLEX_VALUES FFV

Line 449: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;

445: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
446:
447: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
448: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
449: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
450:
451: BEGIN
452: --log for debug
453: IF (l_proc_level >= l_dbg_level)

Line 464: FROM GL_LEDGERS leg

460: END IF; --(l_proc_level >= l_dbg_level)
461:
462: --check whether the currency code is the same to its function currency code
463: SELECT leg.currency_code into l_gl_curr_code
464: FROM GL_LEDGERS leg
465: WHERE leg.ledger_id=P_LEDGER_ID;
466:
467: IF l_gl_curr_code=P_AGIS_CURR_CODE THEN
468: -- in the same currency code,the convert rate is 1

Line 758: FROM gl_periods gp, GL_LEDGERS ledger

754: , gp.period_year
755: , gp.period_num
756: , gp.start_date
757: , gp.end_date
758: FROM gl_periods gp, GL_LEDGERS ledger
759: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
760: AND ledger.period_set_name = gp.PERIOD_SET_NAME
761: AND ledger.accounted_period_type = gp.period_type
762: AND gp.start_date between

Line 1003: FROM GL_LEDGERS ledger

999: --Collect Data from GL
1000: --Get Functional currency code of Current ledger
1001: SELECT ledger.currency_code
1002: INTO l_je_func_curr_code
1003: FROM GL_LEDGERS ledger
1004: WHERE ledger.ledger_id=P_LEDGER_ID;
1005:
1006: --Get all periods between (P_GL_PERIOD_FROM, P_GL_PERIOD_TO).
1007: OPEN c_period_name;

Line 1164: FROM GL_LEDGERS ledger

1160: --AGIS
1161: --Get Functional currency code of Current ledger
1162: SELECT ledger.currency_code
1163: INTO l_je_func_curr_code
1164: FROM GL_LEDGERS ledger
1165: WHERE ledger.ledger_id=P_LEDGER_ID;
1166:
1167: --Collect Data from AGIS, Collect Data from Intercompany
1168: -- Get all periods between (P_START_PERIOD, P_END_PERIOD).