APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_AC_CTRBS_GT

Line 2532: FROM xla_bal_ac_ctrbs_gt ctr

2528: ) change_balance_cr
2529: ,ctr.balance_status_eff_per_num
2530: ,xbh.year_end_carry_forward_code
2531: ,ctr.account_type
2532: FROM xla_bal_ac_ctrbs_gt ctr
2533: ,xla_analytical_hdrs_b xbh
2534: ,xla_ac_balances xba
2535: WHERE ctr.application_id = p_application_id
2536: AND ctr.ledger_id = p_ledger_id

Line 3170: xla_bal_ac_ctrbs_gt and xla_ac_balances.

3166:
3167: /*
3168: bug#8347976 PLSQL numeric character to number conversion error while undo acctng.
3169: p_analytical_criterion_code is VARCHAR2 wherever its referenced ie
3170: xla_bal_ac_ctrbs_gt and xla_ac_balances.
3171: */
3172:
3173: FUNCTION move_identified_bals_forward
3174: ( p_application_id IN INTEGER

Line 5033: FROM xla_bal_ac_ctrbs_gt;

5029: END IF;
5030:
5031: --if temp tabs are empty this will not take long
5032: DELETE
5033: FROM xla_bal_ac_ctrbs_gt;
5034:
5035: IF p_operation_code = 'F'
5036: THEN
5037: INSERT

Line 5038: INTO xla_bal_ac_ctrbs_gt

5034:
5035: IF p_operation_code = 'F'
5036: THEN
5037: INSERT
5038: INTO xla_bal_ac_ctrbs_gt
5039: ( application_id
5040: ,ledger_id
5041: ,period_name
5042: ,period_year

Line 5106: || ' inserted into xla_bal_ac_ctrbs_gt'

5102: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5103: trace
5104: (p_module => l_log_module
5105: ,p_msg => l_row_count
5106: || ' inserted into xla_bal_ac_ctrbs_gt'
5107: ,p_level => C_LEVEL_STATEMENT
5108: );
5109: END IF;
5110:

Line 5114: INTO xla_bal_ac_ctrbs_gt

5110:
5111: ELSIF p_operation_code ='A'
5112: THEN
5113: INSERT
5114: INTO xla_bal_ac_ctrbs_gt
5115: ( application_id
5116: ,ledger_id
5117: ,period_name
5118: ,period_year

Line 5193: || ' inserted into xla_bal_ac_ctrbs_gt'

5189: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5190: trace
5191: (p_module => l_log_module
5192: ,p_msg => l_row_count
5193: || ' inserted into xla_bal_ac_ctrbs_gt'
5194: ,p_level => C_LEVEL_STATEMENT
5195: );
5196: END IF;
5197: ELSIF p_operation_code ='R'

Line 5200: INTO xla_bal_ac_ctrbs_gt

5196: END IF;
5197: ELSIF p_operation_code ='R'
5198: THEN
5199: INSERT
5200: INTO xla_bal_ac_ctrbs_gt
5201: ( application_id
5202: ,ledger_id
5203: ,period_name
5204: ,period_year

Line 5279: || ' inserted into xla_bal_ac_ctrbs_gt'

5275: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5276: trace
5277: (p_module => l_log_module
5278: ,p_msg => l_row_count
5279: || ' inserted into xla_bal_ac_ctrbs_gt'
5280: ,p_level => C_LEVEL_STATEMENT
5281: );
5282: END IF;
5283:

Line 5307: || ' inserted into xla_bal_ac_ctrbs_gt'

5303: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5304: trace
5305: (p_module => l_log_module
5306: ,p_msg => l_row_count
5307: || ' inserted into xla_bal_ac_ctrbs_gt'
5308: ,p_level => C_LEVEL_STATEMENT
5309: );
5310: END IF;
5311:

Line 6909: FROM xla_bal_ac_ctrbs_gt bact

6905: ,bact.ac2
6906: ,bact.ac3
6907: ,bact.ac4
6908: ,bact.ac5
6909: FROM xla_bal_ac_ctrbs_gt bact
6910: WHERE bact.application_id = i.application_id
6911: AND bact.ledger_id = i.ledger_id
6912: AND bact.effective_period_num = i.effective_period_num
6913: AND bact.balance_status_eff_per_num < bact.effective_period_num