DBA Data[Home] [Help]

APPS.XLA_CA_BALANCES_PKG dependencies on GL_LEDGERS

Line 179: ,gl_ledgers gll

175: UPDATE xla_ctrl_balances_int xib SET code_combination_id =
176: (SELECT
177: gcc.code_Combination_id
178: FROM gl_code_combinations gcc
179: ,gl_ledgers gll
180: WHERE xib.ledger_id = gll.ledger_id
181: AND gll.chart_of_accounts_id = gcc.chart_of_accounts_id
182: AND NVL(xib.segment1,'X') = NVL(gcc.segment1,'X')
183: AND NVL(xib.segment2,'X') = NVL(gcc.segment2,'X')

Line 1050: ,gl_ledgers gll

1046: ,DECODE(glp.adjustment_period_flag ,'Y','IB026',NULL) IB026
1047: ,DECODE(glp.period_num,1,decode(glp2.period_num,1,decode(sign(glp.effective_period_num-xlp.min_effect_period_num),0,NULL,'IB027'),NULL),NULL) IB027
1048: FROM xla_ctrl_balances_int xib
1049: ,xla_subledgers xls
1050: ,gl_ledgers gll
1051: ,gl_ledger_relationships glr
1052: ,gl_code_combinations gcc
1053: ,ap_suppliers aps
1054: ,ap_supplier_sites_all apsa