APPS.PA_BC_COSTING dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 190: ,pa_cost_distribution_lines_all cdl

186: ,'EXP' pkt_reference1
187: ,cdl.expenditure_item_id pkt_reference2
188: ,cdl.line_num pkt_reference3
189: FROM pa_expenditure_items_all ei
190: ,pa_cost_distribution_lines_all cdl
191: ,pa_project_types_all pt
192: ,pa_projects_all p
193: ,pa_expenditures exp
194: ,pa_budget_versions bv

Line 452: FROM pa_cost_distribution_lines_all cdl

448: ,l_document_line_id_tab(l_this_fetch+1)
449: ,l_pkt_reference1_tab(l_this_fetch+1)
450: ,l_pkt_reference2_tab(l_this_fetch+1)
451: ,l_pkt_reference3_tab(l_this_fetch+1)
452: FROM pa_cost_distribution_lines_all cdl
453: ,pa_project_types_all pt
454: ,pa_projects_all p
455: ,pa_budget_versions bv
456: ,pa_budgetary_control_options pbct

Line 1318: UPDATE pa_cost_distribution_lines_all cdl

1314: l_debug_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while Bulk updating BC columns in CDL.' ;
1315:
1316: l_stage := 600;
1317: FORALL l_counter IN 1 .. l_records_processed
1318: UPDATE pa_cost_distribution_lines_all cdl
1319: SET cdl.budget_ccid = l_budget_ccid_tab(l_counter)
1320: --r12
1321: ,cdl.budget_version_id = l_budget_ver_id_tab(l_counter)
1322: ,cdl.budget_line_id = l_budget_line_id_tab(l_counter)

Line 2333: ,pa_cost_distribution_lines_all cdl

2329: ,'EXP' reference1
2330: ,cdl.expenditure_item_id reference2
2331: ,cdl.line_num reference3
2332: FROM pa_expenditure_items_all ei
2333: ,pa_cost_distribution_lines_all cdl
2334: ,pa_project_types_all pt
2335: ,pa_projects_all p
2336: ,pa_expenditures exp
2337: ,pa_budget_versions bv

Line 2587: FROM pa_cost_distribution_lines_all cdl

2583: ,l_budget_version_id_tab(l_this_fetch+1)
2584: ,l_pkt_reference1_Tab(l_this_fetch+1)
2585: ,l_pkt_reference2_Tab(l_this_fetch+1)
2586: ,l_pkt_reference3_Tab(l_this_fetch+1)
2587: FROM pa_cost_distribution_lines_all cdl
2588: ,pa_project_types_all pt
2589: ,pa_projects_all p
2590: ,pa_budget_versions bv
2591: ,pa_budgetary_control_options pbct