APPS.PA_CMT_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 169: from pa_expenditure_items_all ei

165:
166: --Get sum of all EI Costs for the Project, Task and Po Line Id
167: /* select sum(nvl(denom_raw_cost,0))
168: into l_EiCost
169: from pa_expenditure_items_all ei
170: where ei.project_id = p_project_id
171: and ei.task_id = p_task_id
172: and ei.po_line_id = p_po_line_id
173: and cost_distributed_flag = 'Y';

Line 182: , pa_expenditure_items_all ei

178: -- so commented the project and task conditions to releive Po project PSI commitment.
179: Select sum(nvl(cdl.denom_raw_cost,0))
180: into l_EiCost
181: from pa_cost_distribution_lines_all cdl
182: , pa_expenditure_items_all ei
183: where cdl.expenditure_item_id = ei.expenditure_item_id
184: /* and ei.project_id = p_project_id
185: and ei.task_id = p_task_id commented for bug:6979249*/
186: and ei.po_line_id = p_po_line_id;