APPS.PA_BC_COSTING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 128: l_ei_to_process_from pa_expenditure_items_all.expenditure_item_id%TYPE := 0;

124: l_bunch_size PLS_INTEGER := 100;
125: l_this_fetch PLS_INTEGER := 0;
126: l_totally_fetched PLS_INTEGER := 0;
127: l_totally_processed PLS_INTEGER := 0;
128: l_ei_to_process_from pa_expenditure_items_all.expenditure_item_id%TYPE := 0;
129:
130:
131: /*
132: * Cursor Declaration.

Line 189: FROM pa_expenditure_items_all ei

185: ,ei.po_line_id po_line_id -- R12 change
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

Line 417: from pa_expenditure_items_all ei

413: ,bv.budget_version_id
414: ,DECODE(l_system_linkage_function_tab(l_this_fetch), 'BTC', -7777, DECODE(cdl.line_type, 'I', NULL, DECODE(cdl.line_num_reversed, NULL, -1, NULL)))
415: -- ,cdl.system_reference3 po_line_id -- R12 change
416: ,(select ei.po_line_id
417: from pa_expenditure_items_all ei
418: where ei.expenditure_item_id = cdl.expenditure_item_id
419: ) po_line_id -- R12 change
420: ,'EXP'
421: ,cdl.expenditure_item_id

Line 2295: l_ei_to_process_from pa_expenditure_items_all.expenditure_item_id%TYPE := 0;

2291: l_bunch_size PLS_INTEGER := 100;
2292: l_this_fetch PLS_INTEGER := 0;
2293: l_totally_fetched PLS_INTEGER := 0;
2294: l_totally_processed PLS_INTEGER := 0;
2295: l_ei_to_process_from pa_expenditure_items_all.expenditure_item_id%TYPE := 0;
2296:
2297: /*
2298: * Cursor Declaration.
2299: */

Line 2332: FROM pa_expenditure_items_all ei

2328: ,bv.budget_version_id
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