APPS.XLA_BALANCES_PKG dependencies on XLA_BAL_CTRL_CTRBS_GT

Line 1858: FROM xla_bal_ctrl_ctrbs_gt ctr

1854: - NVL(xba.draft_beginning_balance_dr, 0)
1855: ,-NVL(xba.draft_beginning_balance_cr, 0)
1856: ) change_draft_balance_cr
1857: ,ctr.balance_status_eff_per_num
1858: FROM xla_bal_ctrl_ctrbs_gt ctr
1859: ,xla_control_balances xba
1860: WHERE ctr.application_id = p_application_id
1861: AND ctr.ledger_id = p_ledger_id
1862: AND ctr.effective_period_num = p_effective_period_num

Line 5358: FROM xla_bal_ctrl_ctrbs_gt;

5354: END IF;
5355:
5356: --if temp tabs are empty this will not take long
5357: DELETE
5358: FROM xla_bal_ctrl_ctrbs_gt;
5359:
5360: IF p_operation_code = 'F'
5361: THEN
5362: INSERT

Line 5363: INTO xla_bal_ctrl_ctrbs_gt

5359:
5360: IF p_operation_code = 'F'
5361: THEN
5362: INSERT
5363: INTO xla_bal_ctrl_ctrbs_gt
5364: ( application_id
5365: ,ledger_id
5366: ,period_name
5367: ,period_year

Line 5412: INTO xla_bal_ctrl_ctrbs_gt

5408: l_row_count := SQL%ROWCOUNT;
5409: ELSIF p_operation_code ='A'
5410: THEN
5411: INSERT
5412: INTO xla_bal_ctrl_ctrbs_gt
5413: ( application_id
5414: ,ledger_id
5415: ,period_name
5416: ,period_year

Line 5481: INTO xla_bal_ctrl_ctrbs_gt

5477: l_row_count := SQL%ROWCOUNT;
5478: ELSIF p_operation_code ='R'
5479: THEN
5480: INSERT
5481: INTO xla_bal_ctrl_ctrbs_gt
5482: ( application_id
5483: ,ledger_id
5484: ,period_name
5485: ,period_year

Line 5573: ' inserted into xla_bal_ctrl_ctrbs_gt'

5569: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5570: trace
5571: (p_module => l_log_module
5572: ,p_msg => l_row_count ||
5573: ' inserted into xla_bal_ctrl_ctrbs_gt'
5574: ,p_level => C_LEVEL_STATEMENT
5575: );
5576: END IF;
5577:

Line 6763: FROM xla_bal_ctrl_ctrbs_gt bcct

6759: SELECT DISTINCT
6760: bcct.code_combination_id
6761: ,bcct.party_type_code
6762: ,bcct.party_id
6763: FROM xla_bal_ctrl_ctrbs_gt bcct
6764: WHERE bcct.application_id = i.application_id
6765: AND bcct.ledger_id = i.ledger_id
6766: AND bcct.effective_period_num = i.effective_period_num
6767: AND bcct.balance_status_eff_per_num < bcct.effective_period_num