DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PJI_FP_XBS_ACCUM_F

Line 4401: from pji_fp_xbs_accum_f

4397: CURSOR cur_self_planned ( c_project_id NUMBER, c_proj_element_id NUMBER,
4398: c_plan_version_id NUMBER, c_base_percnt_deriv_code VARCHAR2)
4399: IS
4400: select decode(c_base_percnt_deriv_code, 'COST', sum(brdn_cost), 'EFFORT', sum(nvl(labor_hrs,0)+nvl(equipment_hours,0)))
4401: from pji_fp_xbs_accum_f
4402: where project_id = c_project_id
4403: and plan_version_id = c_plan_version_id
4404: and project_element_id = c_proj_element_id
4405: and calendar_type = 'A'