DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE

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

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

Line 134: FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs

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