APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on GL_LEDGERS

Line 165: ,GL_LEDGERS ledger

161: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
162: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
163: seg_fsav_gcc
164: FROM GL_CODE_COMBINATIONS gcc
165: ,GL_LEDGERS ledger
166: ,FND_ID_FLEX_SEGMENTS FIFS
167: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
168: ,FND_FLEX_VALUE_SETS FFVS
169: ,FND_FLEX_VALUES FFV

Line 437: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;

433: l_proc_name VARCHAR2(100) :='GL_InterCom_Line_Check';
434:
435: --l_trx_curr_cov_type GL_DAILY_RATES.CONVERSION_TYPE%TYPE;
436: --l_trx_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE;
437: l_gl_curr_code GL_LEDGERS.Currency_Code%TYPE;
438:
439: BEGIN
440: --log for debug
441: IF (l_proc_level >= l_dbg_level)

Line 452: FROM GL_LEDGERS leg

448: END IF; --(l_proc_level >= l_dbg_level)
449:
450: --check whether the currency code is the same to its function currency code
451: SELECT leg.currency_code into l_gl_curr_code
452: FROM GL_LEDGERS leg
453: WHERE leg.ledger_id=P_LEDGER_ID;
454:
455: IF l_gl_curr_code=P_AGIS_CURR_CODE THEN
456: -- in the same currency code,the convert rate is 1

Line 740: FROM gl_periods gp, GL_LEDGERS ledger

736: , gp.period_year
737: , gp.period_num
738: , gp.start_date
739: , gp.end_date
740: FROM gl_periods gp, GL_LEDGERS ledger
741: WHERE ledger.ledger_id = l_ledger_id --using variable P_LEDGER_ID
742: AND ledger.period_set_name = gp.PERIOD_SET_NAME
743: AND ledger.accounted_period_type = gp.period_type
744: AND gp.start_date between

Line 980: FROM GL_LEDGERS ledger

976: --Collect Data from GL
977: --Get Functional currency code of Current ledger
978: SELECT ledger.currency_code
979: INTO l_je_func_curr_code
980: FROM GL_LEDGERS ledger
981: WHERE ledger.ledger_id=P_LEDGER_ID;
982:
983: --Get all periods between (P_GL_PERIOD_FROM, P_GL_PERIOD_TO).
984: OPEN c_period_name;

Line 1138: FROM GL_LEDGERS ledger

1134: --AGIS
1135: --Get Functional currency code of Current ledger
1136: SELECT ledger.currency_code
1137: INTO l_je_func_curr_code
1138: FROM GL_LEDGERS ledger
1139: WHERE ledger.ledger_id=P_LEDGER_ID;
1140:
1141: --Collect Data from AGIS, Collect Data from Intercompany
1142: -- Get all periods between (P_START_PERIOD, P_END_PERIOD).