APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 4238: from pji_pa_proj_events_log log,pa_proj_element_versions ver

4234: select 1
4235: into l_prg_event_id
4236: from dual
4237: where exists (select log.event_id
4238: from pji_pa_proj_events_log log,pa_proj_element_versions ver
4239: where log.event_type='PRG_CHANGE'
4240: and log.event_object =to_char(ver.prg_group)
4241: and ver.project_id=l_project_id
4242: union all

Line 4244: from pa_pji_proj_events_log log,pa_proj_element_versions ver

4240: and log.event_object =to_char(ver.prg_group)
4241: and ver.project_id=l_project_id
4242: union all
4243: select log.event_id
4244: from pa_pji_proj_events_log log,pa_proj_element_versions ver
4245: where log.event_type='PRG_CHANGE'
4246: and log.event_object =to_char(ver.prg_group)
4247: and ver.project_id=l_project_id);
4248: else

Line 4253: from pa_pji_proj_events_log log,pa_proj_element_versions ver

4249: select 1
4250: into l_prg_event_id
4251: from dual
4252: where exists (select log.event_id
4253: from pa_pji_proj_events_log log,pa_proj_element_versions ver
4254: where log.event_type='PRG_CHANGE'
4255: and log.event_object =to_char(ver.prg_group)
4256: and ver.project_id=l_project_id);
4257:

Line 4774: pa_proj_element_versions ver

4770: l_struct_type
4771: FROM
4772: pa_structure_types typ,
4773: pa_proj_structure_types ptyp,
4774: pa_proj_element_versions ver
4775: WHERE
4776: typ.STRUCTURE_TYPE_ID = ptyp.STRUCTURE_TYPE_ID AND
4777: ptyp.PROJ_ELEMENT_ID = ver.PROJ_ELEMENT_ID AND
4778: ver.ELEMENT_VERSION_ID = p_new_struct_ver_id ; --p_old_struct_ver_id; fix for bug : 4191390

Line 5853: pa_proj_element_versions

5849: PROJ_ELEMENT_ID, project_id
5850: INTO
5851: l_struct_element_id, l_project_id
5852: FROM
5853: pa_proj_element_versions
5854: WHERE
5855: ELEMENT_VERSION_ID = p_wbs_version_id;
5856: EXCEPTION
5857: WHEN NO_DATA_FOUND THEN

Line 6038: ,pa_proj_element_versions pa

6034: BEGIN
6035: SELECT distinct head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id,head.plan_type_code BULK COLLECT
6036: into il_plan_version_id_tbl, il_project_id_tbl,il_wbs_version_id_tbl,il_plan_type_code_tbl /*4471527 */
6037: FROM pji_xbs_Denorm pji
6038: ,pa_proj_element_versions pa
6039: ,pji_pjp_wbs_header head
6040: WHERE pji.struct_type='PRG'
6041: and pji.sup_level<>pji.sub_level
6042: and pji.sup_id in (l_get_wbs_version_id_tbl(1),l_get_wbs_version_id_tbl(2),l_get_wbs_version_id_tbl(3)