APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_CTRL_CTRBS_GT

Line 1869: FROM xla_bal_ctrl_ctrbs_gt ctr

1865: - NVL(xba.draft_beginning_balance_dr, 0)
1866: ,-NVL(xba.draft_beginning_balance_cr, 0)
1867: ) change_draft_balance_cr
1868: ,ctr.balance_status_eff_per_num
1869: FROM xla_bal_ctrl_ctrbs_gt ctr
1870: ,xla_control_balances xba
1871: WHERE ctr.application_id = p_application_id
1872: AND ctr.ledger_id = p_ledger_id
1873: AND ctr.effective_period_num = p_effective_period_num

Line 5339: FROM xla_bal_ctrl_ctrbs_gt;

5335: END IF;
5336:
5337: --if temp tabs are empty this will not take long
5338: DELETE
5339: FROM xla_bal_ctrl_ctrbs_gt;
5340:
5341: IF p_operation_code = 'F'
5342: THEN
5343: INSERT

Line 5344: INTO xla_bal_ctrl_ctrbs_gt

5340:
5341: IF p_operation_code = 'F'
5342: THEN
5343: INSERT
5344: INTO xla_bal_ctrl_ctrbs_gt
5345: ( application_id
5346: ,ledger_id
5347: ,period_name
5348: ,period_year

Line 5393: INTO xla_bal_ctrl_ctrbs_gt

5389: l_row_count := SQL%ROWCOUNT;
5390: ELSIF p_operation_code ='A'
5391: THEN
5392: INSERT
5393: INTO xla_bal_ctrl_ctrbs_gt
5394: ( application_id
5395: ,ledger_id
5396: ,period_name
5397: ,period_year

Line 5462: INTO xla_bal_ctrl_ctrbs_gt

5458: l_row_count := SQL%ROWCOUNT;
5459: ELSIF p_operation_code ='R'
5460: THEN
5461: INSERT
5462: INTO xla_bal_ctrl_ctrbs_gt
5463: ( application_id
5464: ,ledger_id
5465: ,period_name
5466: ,period_year

Line 5554: ' inserted into xla_bal_ctrl_ctrbs_gt'

5550: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5551: trace
5552: (p_module => l_log_module
5553: ,p_msg => l_row_count ||
5554: ' inserted into xla_bal_ctrl_ctrbs_gt'
5555: ,p_level => C_LEVEL_STATEMENT
5556: );
5557: END IF;
5558:

Line 6739: FROM xla_bal_ctrl_ctrbs_gt bcct

6735: SELECT DISTINCT
6736: bcct.code_combination_id
6737: ,bcct.party_type_code
6738: ,bcct.party_id
6739: FROM xla_bal_ctrl_ctrbs_gt bcct
6740: WHERE bcct.application_id = i.application_id
6741: AND bcct.ledger_id = i.ledger_id
6742: AND bcct.effective_period_num = i.effective_period_num
6743: AND bcct.balance_status_eff_per_num < bcct.effective_period_num