APPS.PA_CMT_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 184: from pa_expenditure_items_all ei

180:
181: --Get sum of all EI Costs for the Project, Task and Po Line Id
182: /* select sum(nvl(denom_raw_cost,0))
183: into l_EiCost
184: from pa_expenditure_items_all ei
185: where ei.project_id = p_project_id
186: and ei.task_id = p_task_id
187: and ei.po_line_id = p_po_line_id
188: and cost_distributed_flag = 'Y';

Line 197: , pa_expenditure_items_all ei

193: -- so commented the project and task conditions to releive Po project PSI commitment.
194: Select sum(nvl(cdl.denom_raw_cost,0))
195: into l_EiCost
196: from pa_cost_distribution_lines_all cdl
197: , pa_expenditure_items_all ei
198: where cdl.expenditure_item_id = ei.expenditure_item_id
199: /* and ei.project_id = p_project_id
200: and ei.task_id = p_task_id commented for bug:6979249*/
201: and ei.po_line_id = p_po_line_id;