APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 3862: from pji_pa_proj_events_log log,pa_proj_element_versions ver

3858: select 1
3859: into l_prg_event_id
3860: from dual
3861: where exists (select log.event_id
3862: from pji_pa_proj_events_log log,pa_proj_element_versions ver
3863: where log.event_type='PRG_CHANGE'
3864: and log.event_object =to_char(ver.prg_group)
3865: and ver.project_id=l_project_id
3866: union all

Line 3868: from pa_pji_proj_events_log log,pa_proj_element_versions ver

3864: and log.event_object =to_char(ver.prg_group)
3865: and ver.project_id=l_project_id
3866: union all
3867: select log.event_id
3868: from pa_pji_proj_events_log log,pa_proj_element_versions ver
3869: where log.event_type='PRG_CHANGE'
3870: and log.event_object =to_char(ver.prg_group)
3871: and ver.project_id=l_project_id);
3872: else

Line 3877: from pa_pji_proj_events_log log,pa_proj_element_versions ver

3873: select 1
3874: into l_prg_event_id
3875: from dual
3876: where exists (select log.event_id
3877: from pa_pji_proj_events_log log,pa_proj_element_versions ver
3878: where log.event_type='PRG_CHANGE'
3879: and log.event_object =to_char(ver.prg_group)
3880: and ver.project_id=l_project_id);
3881:

Line 4396: pa_proj_element_versions ver

4392: l_struct_type
4393: FROM
4394: pa_structure_types typ,
4395: pa_proj_structure_types ptyp,
4396: pa_proj_element_versions ver
4397: WHERE
4398: typ.STRUCTURE_TYPE_ID = ptyp.STRUCTURE_TYPE_ID AND
4399: ptyp.PROJ_ELEMENT_ID = ver.PROJ_ELEMENT_ID AND
4400: ver.ELEMENT_VERSION_ID = p_new_struct_ver_id ; --p_old_struct_ver_id; fix for bug : 4191390

Line 5463: pa_proj_element_versions

5459: PROJ_ELEMENT_ID, project_id
5460: INTO
5461: l_struct_element_id, l_project_id
5462: FROM
5463: pa_proj_element_versions
5464: WHERE
5465: ELEMENT_VERSION_ID = p_wbs_version_id;
5466: EXCEPTION
5467: WHEN NO_DATA_FOUND THEN

Line 5518: ,pa_proj_element_versions pa

5514: BEGIN
5515: SELECT distinct head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id,head.plan_type_code BULK COLLECT
5516: into il_plan_version_id_tbl, il_project_id_tbl,il_wbs_version_id_tbl,il_plan_type_code_tbl /*4471527 */
5517: FROM pji_xbs_Denorm pji
5518: ,pa_proj_element_versions pa
5519: ,pji_pjp_wbs_header head
5520: WHERE pji.struct_type='PRG'
5521: and pji.sup_level<>pji.sub_level
5522: 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)