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'