APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 601: FROM PA_PROJ_ELEM_VER_STRUCTURE

597: SELECT 'Y'
598: FROM DUAL
599: WHERE NOT EXISTS
600: (SELECT 'Y'
601: FROM PA_PROJ_ELEM_VER_STRUCTURE
602: WHERE proj_element_id = c_structure_id
603: AND published_date is not null);
604:
605: l_temp VARCHAR2(1);

Line 632: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

628: /*
629: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
630: IS
631: SELECT ppev.element_version_id
632: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
633: WHERE ppev.proj_element_id = c_structure_id
634: AND ppev.element_version_id = ppevs.element_version_id
635: AND ppevs.published_date is null;
636: */

Line 643: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs

639:
640: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
641: IS
642: SELECT ppevs.element_version_id
643: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs
644: WHERE ppev.proj_element_id = c_structure_id
645: AND ppev.project_id = ppevs.project_id
646: AND ppev.proj_element_id = ppevs.proj_element_id
647: AND ppevs.published_date is null;