APPS.PA_PROGRESS_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 625: FROM pa_object_relationships por

621:
622: CURSOR cur_dlv_get_asso_task(c_del_elem_id NUMBER)
623: IS
624: SELECT por.object_id_from2
625: FROM pa_object_relationships por
626: WHERE
627: por.object_type_to = 'PA_DELIVERABLES'
628: AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
629: AND por.relationship_type = 'A'

Line 1109: FROM pa_object_relationships por

1105:
1106: CURSOR cur_dlv_get_asso_task(c_del_elem_id NUMBER)
1107: IS
1108: SELECT por.object_id_from2
1109: FROM pa_object_relationships por
1110: WHERE
1111: por.object_type_to = 'PA_DELIVERABLES'
1112: AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
1113: AND por.relationship_type = 'A'

Line 1316: FROM pa_object_relationships por

1312:
1313: CURSOR cur_dlv_get_asso_task(c_del_elem_id NUMBER)
1314: IS
1315: SELECT por.object_id_from2
1316: FROM pa_object_relationships por
1317: WHERE
1318: por.object_type_to = 'PA_DELIVERABLES'
1319: AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
1320: AND por.relationship_type = 'A'

Line 2258: FROM pa_object_relationships por,

2254: ) RETURN VARCHAR2 IS
2255: CURSOR cur_pa_proj
2256: IS
2257: SELECT ppe.status_code
2258: FROM pa_object_relationships por,
2259: pa_proj_element_versions ppev,
2260: pa_proj_elements ppe,
2261: pa_project_statuses pps
2262: WHERE object_id_to1 = p_object_version_id

Line 2565: FROM pa_object_relationships rel

2561:
2562: CURSOR l_get_parent_task(c_element_version_id NUMBER)
2563: IS
2564: SELECT rel.object_id_from1
2565: FROM pa_object_relationships rel
2566: WHERE rel.object_id_to1 = c_element_version_id
2567: AND rel.object_type_to = 'PA_TASKS'
2568: AND rel.relationship_type = 'S'
2569: AND rel.object_type_from = 'PA_TASKS';

Line 2811: pa_object_relationships por,

2807: l_dummy VARCHAR2(1);
2808: CURSOR c_get_del_associated_task IS
2809: SELECT 'x'
2810: FROM pa_proj_elements ppe,
2811: pa_object_relationships por,
2812: pa_task_types ttype
2813: WHERE
2814: ppe.object_type = 'PA_TASKS'
2815: and ppe.proj_element_id = por.object_id_from2

Line 7414: from pa_object_relationships

7410: and parent_structure_version_id = p_structure_version_id;
7411:
7412: cursor c2(p_fin_task_ver_id NUMBER) is
7413: select object_id_from1
7414: from pa_object_relationships
7415: where relationship_type='M'
7416: and object_type_from='PA_TASKS'
7417: and object_type_to='PA_TASKS'
7418: and object_id_to1 = p_fin_task_ver_id;

Line 12984: pa_object_relationships por,

12980: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12981: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12982: from pa_proj_element_versions ppev1,
12983: pa_proj_element_versions ppev2,
12984: pa_object_relationships por,
12985: pa_proj_elements ppe,
12986: pa_proj_elem_ver_schedule ppevs
12987: where ppev1.parent_structure_version_id = p_structure_version_id
12988: and ppev1.proj_element_id=ppe.proj_element_id