APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_PROGRESS_ROLLUP

Line 194: pa_progress_rollup ppru,

190: -- (NVL(pfxat.labor_hours, 0) + NVL(pfxat.equipment_hours, 0))
191: (NVL(pxpv.labor_effort,0) + NVL(pxpv.equipment_effort,0))
192: from pji_xbs_plans_v pxpv,
193: -- from pji_fm_xbs_accum_tmp1 pfxat,
194: pa_progress_rollup ppru,
195: pa_proj_element_versions ppev
196: where ppev.element_version_id = c_wp_ver_id
197: and ppev.project_id = ppru.project_id
198: and ppev.proj_element_id = ppru.object_id

Line 264: pa_progress_rollup ppru,

260: -- (NVL(pfxat.labor_hours, 0) + NVL(pfxat.equipment_hours, 0))
261: (NVL(pxpv.labor_effort,0) + NVL(pxpv.equipment_effort,0))
262: from pji_xbs_plans_v pxpv,
263: -- from pji_fm_xbs_accum_tmp1 pfxat,
264: pa_progress_rollup ppru,
265: pa_proj_element_versions ppev
266: where ppev.element_version_id = c_wp_ver_id
267: and ppev.project_id = ppru.project_id
268: and ppev.proj_element_id = ppru.object_id

Line 328: from pa_progress_rollup ppru,

324: IS
325: l_wp_versioN_id NUMBER;
326: CURSOR c1(c_wp_ver_id NUMBER) IS
327: select (NVL(ppru.estimated_remaining_effort,0) + NVL(ppru.eqpmt_etc_effort,0))
328: from pa_progress_rollup ppru,
329: pa_proj_element_versions ppev
330: where ppev.element_version_id = c_wp_ver_id
331: and ppev.project_id = ppru.project_id
332: and ppev.proj_element_id = ppru.object_id