APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 1300: from pa_proj_elem_ver_schedule a,

1296: )
1297: IS
1298: CURSOR c1 IS
1299: select min(a.scheduled_start_date)
1300: from pa_proj_elem_ver_schedule a,
1301: pa_object_relationships b,
1302: pa_proj_element_versions c
1303: where relationship_type IN ('S', 'L')
1304: and b.object_id_from1 = p_element_version_id

Line 1313: from pa_proj_elem_ver_schedule a,

1309: and c.element_version_id = a.element_version_id;
1310:
1311: CURSOR c2 IS
1312: select max(a.scheduled_finish_date)
1313: from pa_proj_elem_ver_schedule a,
1314: pa_object_relationships b,
1315: pa_proj_element_versions c
1316: where relationship_type IN ('S', 'L')
1317: and b.object_id_from1 = p_element_version_id

Line 1341: from pa_proj_elem_ver_schedule a,

1337: --bug 3074706
1338: --add pa_proj_element_versions and add condition project_id to use index
1339: CURSOR c4 IS
1340: select max(a.last_update_date)
1341: from pa_proj_elem_ver_schedule a,
1342: pa_object_relationships b,
1343: pa_proj_element_versions c
1344: where a.element_version_id = c.element_version_id
1345: and a.project_id = c.project_id

Line 2291: pa_proj_elem_ver_schedule a,

2287: /*
2288: CURSOR c1 IS
2289: SELECT MAX(a.last_update_date), b.parent_structure_version_id
2290: FROM pa_proj_element_versions b,
2291: pa_proj_elem_ver_schedule a,
2292: pa_proj_elem_ver_structure c
2293: WHERE a.element_version_id (+)= b.element_version_id
2294: AND a.project_id (+) = b.project_id
2295: AND a.proj_element_id (+) = b.proj_element_id

Line 3949: pa_proj_elem_ver_schedule a,

3945: IS
3946: CURSOR c1 IS
3947: SELECT MAX(a.last_update_date), b.parent_structure_version_id
3948: FROM pa_proj_element_versions b,
3949: pa_proj_elem_ver_schedule a,
3950: pa_proj_elem_ver_structure c
3951: WHERE a.element_version_id (+)= b.element_version_id
3952: AND a.project_id (+) = b.project_id
3953: AND a.proj_element_id (+) = b.proj_element_id