APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 590: FROM PA_PROJ_ELEM_VER_STRUCTURE

586: SELECT 'Y'
587: FROM DUAL
588: WHERE NOT EXISTS
589: (SELECT 'Y'
590: FROM PA_PROJ_ELEM_VER_STRUCTURE
591: WHERE proj_element_id = c_structure_id
592: AND published_date is not null);
593:
594: l_temp VARCHAR2(1);

Line 621: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

617: /*
618: CURSOR l_get_working_version_csr(c_structure_id NUMBER)
619: IS
620: SELECT ppev.element_version_id
621: FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
622: WHERE ppev.proj_element_id = c_structure_id
623: AND ppev.element_version_id = ppevs.element_version_id
624: AND ppevs.published_date is null;
625: */

Line 632: FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs

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