APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_AC_CTRBS_GT

Line 2541: FROM xla_bal_ac_ctrbs_gt ctr

2537: ) change_balance_cr
2538: ,ctr.balance_status_eff_per_num
2539: ,xbh.year_end_carry_forward_code
2540: ,ctr.account_type
2541: FROM xla_bal_ac_ctrbs_gt ctr
2542: ,xla_analytical_hdrs_b xbh
2543: ,xla_ac_balances xba
2544: WHERE ctr.application_id = p_application_id
2545: AND ctr.ledger_id = p_ledger_id

Line 5018: FROM xla_bal_ac_ctrbs_gt;

5014: END IF;
5015:
5016: --if temp tabs are empty this will not take long
5017: DELETE
5018: FROM xla_bal_ac_ctrbs_gt;
5019:
5020: IF p_operation_code = 'F'
5021: THEN
5022: INSERT

Line 5023: INTO xla_bal_ac_ctrbs_gt

5019:
5020: IF p_operation_code = 'F'
5021: THEN
5022: INSERT
5023: INTO xla_bal_ac_ctrbs_gt
5024: ( application_id
5025: ,ledger_id
5026: ,period_name
5027: ,period_year

Line 5091: || ' inserted into xla_bal_ac_ctrbs_gt'

5087: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5088: trace
5089: (p_module => l_log_module
5090: ,p_msg => l_row_count
5091: || ' inserted into xla_bal_ac_ctrbs_gt'
5092: ,p_level => C_LEVEL_STATEMENT
5093: );
5094: END IF;
5095:

Line 5099: INTO xla_bal_ac_ctrbs_gt

5095:
5096: ELSIF p_operation_code ='A'
5097: THEN
5098: INSERT
5099: INTO xla_bal_ac_ctrbs_gt
5100: ( application_id
5101: ,ledger_id
5102: ,period_name
5103: ,period_year

Line 5176: || ' inserted into xla_bal_ac_ctrbs_gt'

5172: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5173: trace
5174: (p_module => l_log_module
5175: ,p_msg => l_row_count
5176: || ' inserted into xla_bal_ac_ctrbs_gt'
5177: ,p_level => C_LEVEL_STATEMENT
5178: );
5179: END IF;
5180: ELSIF p_operation_code ='R'

Line 5183: INTO xla_bal_ac_ctrbs_gt

5179: END IF;
5180: ELSIF p_operation_code ='R'
5181: THEN
5182: INSERT
5183: INTO xla_bal_ac_ctrbs_gt
5184: ( application_id
5185: ,ledger_id
5186: ,period_name
5187: ,period_year

Line 5260: || ' inserted into xla_bal_ac_ctrbs_gt'

5256: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5257: trace
5258: (p_module => l_log_module
5259: ,p_msg => l_row_count
5260: || ' inserted into xla_bal_ac_ctrbs_gt'
5261: ,p_level => C_LEVEL_STATEMENT
5262: );
5263: END IF;
5264:

Line 5288: || ' inserted into xla_bal_ac_ctrbs_gt'

5284: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5285: trace
5286: (p_module => l_log_module
5287: ,p_msg => l_row_count
5288: || ' inserted into xla_bal_ac_ctrbs_gt'
5289: ,p_level => C_LEVEL_STATEMENT
5290: );
5291: END IF;
5292:

Line 6889: FROM xla_bal_ac_ctrbs_gt bact

6885: ,bact.ac2
6886: ,bact.ac3
6887: ,bact.ac4
6888: ,bact.ac5
6889: FROM xla_bal_ac_ctrbs_gt bact
6890: WHERE bact.application_id = i.application_id
6891: AND bact.ledger_id = i.ledger_id
6892: AND bact.effective_period_num = i.effective_period_num
6893: AND bact.balance_status_eff_per_num < bact.effective_period_num