DBA Data[Home] [Help]

APPS.PA_WP_EXCEPTION_UTILS dependencies on PJI_XBS_PLANS_V

Line 192: from pji_xbs_plans_v pxpv,

188: CURSOR c1(c_wp_ver_id NUMBER) IS
189: select (NVL(PPRU.ppl_act_effort_to_date,0) + NVL(ppru.eqpmt_act_effort_to_date,0)) -
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

Line 262: from pji_xbs_plans_v pxpv,

258: NVL(ppru.PPL_ACT_EFFORT_TO_DATE, 0) +
259: NVL(ppru.EQPMT_ACT_EFFORT_TO_DATE, 0) ) -
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