APPS.PA_LIFECYCLES_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 561: From pa_proj_element_versions ever

557:
558: CURSOR l_phases_csr
559: IS
560: Select elem.proj_element_id, elem.record_version_number
561: From pa_proj_element_versions ever
562: , pa_proj_elements elem
563: Where ever.parent_structure_version_id = l_life_elem_ver_id
564: AND ever.object_type= 'PA_TASKS'
565: AND ever.project_id=c_project_id

Line 573: From pa_proj_element_versions

569:
570: CURSOR l_get_life_elem_ver_id
571: IS
572: Select ELEMENT_VERSION_ID
573: From pa_proj_element_versions
574: Where PROJ_ELEMENT_ID = p_lifecycle_id;
575:
576:
577: BEGIN

Line 927: from pa_proj_element_versions child

923: Select 'Y'
924: From dual
925: Where exists(
926: Select 'XYZ'
927: from pa_proj_element_versions child
928: , pa_proj_element_versions parent
929: where child.proj_element_id = P_phase_id
930: and child.parent_structure_version_id = parent.element_version_id
931: and parent.proj_element_id = P_lifecycle_id

Line 928: , pa_proj_element_versions parent

924: From dual
925: Where exists(
926: Select 'XYZ'
927: from pa_proj_element_versions child
928: , pa_proj_element_versions parent
929: where child.proj_element_id = P_phase_id
930: and child.parent_structure_version_id = parent.element_version_id
931: and parent.proj_element_id = P_lifecycle_id
932: AND child.object_type= c_object_type

Line 981: Select 'XYZ' from pa_proj_element_versions child

977: begin
978: Select 'Y' into l_phase_exists
979: From dual
980: Where exists(
981: Select 'XYZ' from pa_proj_element_versions child
982: , pa_proj_element_versions parent
983: where child.proj_element_id = P_phase_id
984: and child.parent_structure_version_id = parent.element_version_id
985: and parent.proj_element_id = P_lifecycle_id

Line 982: , pa_proj_element_versions parent

978: Select 'Y' into l_phase_exists
979: From dual
980: Where exists(
981: Select 'XYZ' from pa_proj_element_versions child
982: , pa_proj_element_versions parent
983: where child.proj_element_id = P_phase_id
984: and child.parent_structure_version_id = parent.element_version_id
985: and parent.proj_element_id = P_lifecycle_id
986: AND child.object_type= c_object_type

Line 1685: , pa_proj_element_versions elem

1681: BEGIN
1682: select prj.name,prj.element_number,prj.description,prj.phase_code,elem.display_sequence
1683: into l_phase_name,l_phase_short_name,l_phase_description,l_phase_code,l_seqn
1684: from pa_proj_elements prj
1685: , pa_proj_element_versions elem
1686: where prj.proj_element_id=P_lifecycle_phase_id
1687: and prj.project_id=c_project_id
1688: and prj.object_type=c_object_type
1689: and prj.proj_element_id=elem.proj_element_id;