DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PJI_FP_XBS_ACCUM_F

Line 4444: from pji_fp_xbs_accum_f

4440: CURSOR cur_self_planned ( c_project_id NUMBER, c_proj_element_id NUMBER,
4441: c_plan_version_id NUMBER, c_base_percnt_deriv_code VARCHAR2)
4442: IS
4443: select decode(c_base_percnt_deriv_code, 'COST', sum(brdn_cost), 'EFFORT', sum(nvl(labor_hrs,0)+nvl(equipment_hours,0)))
4444: from pji_fp_xbs_accum_f
4445: where project_id = c_project_id
4446: and plan_version_id = c_plan_version_id
4447: and project_element_id = c_proj_element_id
4448: and calendar_type = 'A'