APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PJI_XBS_PLANS_V

Line 14024: pji_xbs_plans_v pxpv

14020: pa_proj_element_versions ppv,
14021: pa_proj_elem_ver_structure ppvs,
14022: pa_proj_workplan_attr ppwa,
14023: pa_progress_rollup ppr,
14024: pji_xbs_plans_v pxpv
14025: WHERE
14026: ppv.project_id = ppa.project_id
14027: AND ppv.object_type IN( 'PA_STRUCTURES', 'PA_TASKS' )
14028: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 14094: pji_xbs_plans_v pxpv

14090: pa_proj_elements ppe,
14091: pa_proj_element_versions ppv,
14092: pa_proj_elem_ver_structure ppvs,
14093: pa_progress_rollup ppr,
14094: pji_xbs_plans_v pxpv
14095: WHERE
14096: ppa.project_id = ppv.project_id
14097: AND ppv.object_type IN( 'PA_STRUCTURES', 'PA_TASKS' )
14098: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 21177: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912

21173:
21174: TYPE duration_tbl IS TABLE OF pa_proj_elem_ver_schedule.duration%TYPE
21175: INDEX BY BINARY_INTEGER;
21176:
21177: TYPE effort_tbl IS TABLE OF pji_xbs_plans_v.labor_effort%TYPE --pa_proj_elem_ver_schedule.planned_effort%TYPE 3746912
21178: INDEX BY BINARY_INTEGER;
21179:
21180: TYPE task_weightage_tbl IS TABLE OF pa_object_relationships.weighting_percentage%TYPE
21181: INDEX BY BINARY_INTEGER;

Line 21205: pji_xbs_plans_v pxpv

21201: pa_object_relationships rel,
21202: pa_proj_elem_ver_schedule sch,
21203: pa_proj_elements ele,
21204: pa_task_types ptt,
21205: pji_xbs_plans_v pxpv
21206: -- pji_fm_xbs_accum_tmp1 pfxat
21207: where ver.project_id = c_project_id
21208: and ver.parent_structure_version_id = c_structure_version_id
21209: and ver.object_type = 'PA_TASKS'