APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 195: pa_proj_element_versions ppev

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
199: and ppev.object_type = ppru.object_type

Line 265: pa_proj_element_versions ppev

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
269: and ppev.object_type = ppru.object_type

Line 329: pa_proj_element_versions ppev

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
333: and ppev.object_type = ppru.object_type