APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 128: -- Retrieve task Scheduled Start and Scheduled End Date from PA_PROJ_ELEM_VER_SCHEDULE table

124: ORDER BY ppev.display_sequence;
125:
126: l_proj_elements_rec pa_proj_elements_csr%ROWTYPE;
127:
128: -- Retrieve task Scheduled Start and Scheduled End Date from PA_PROJ_ELEM_VER_SCHEDULE table
129: CURSOR pa_schedule_dates_csr (c_structure_version_id NUMBER, c_proj_element_id NUMBER)
130: IS
131: SELECT ppevs.scheduled_start_date, ppevs.scheduled_finish_date
132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs

Line 132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs

128: -- Retrieve task Scheduled Start and Scheduled End Date from PA_PROJ_ELEM_VER_SCHEDULE table
129: CURSOR pa_schedule_dates_csr (c_structure_version_id NUMBER, c_proj_element_id NUMBER)
130: IS
131: SELECT ppevs.scheduled_start_date, ppevs.scheduled_finish_date
132: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs
133: WHERE ppev.element_version_id = ppevs.element_version_id
134: AND ppev.project_id = ppevs.project_id -- 3693934 added for peformance fix
135: AND ppev.object_type = 'PA_TASKS'
136: AND ppev.proj_element_id = c_proj_element_id