APPS.PA_PROGRESS_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 623: FROM pa_object_relationships por

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

Line 1103: FROM pa_object_relationships por

1099:
1100: CURSOR cur_dlv_get_asso_task(c_del_elem_id NUMBER)
1101: IS
1102: SELECT por.object_id_from2
1103: FROM pa_object_relationships por
1104: WHERE
1105: por.object_type_to = 'PA_DELIVERABLES'
1106: AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
1107: AND por.relationship_type = 'A'

Line 1308: FROM pa_object_relationships por

1304:
1305: CURSOR cur_dlv_get_asso_task(c_del_elem_id NUMBER)
1306: IS
1307: SELECT por.object_id_from2
1308: FROM pa_object_relationships por
1309: WHERE
1310: por.object_type_to = 'PA_DELIVERABLES'
1311: AND por.relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
1312: AND por.relationship_type = 'A'

Line 2234: FROM pa_object_relationships por,

2230: ) RETURN VARCHAR2 IS
2231: CURSOR cur_pa_proj
2232: IS
2233: SELECT ppe.status_code
2234: FROM pa_object_relationships por,
2235: pa_proj_element_versions ppev,
2236: pa_proj_elements ppe,
2237: pa_project_statuses pps
2238: WHERE object_id_to1 = p_object_version_id

Line 2540: FROM pa_object_relationships rel

2536:
2537: CURSOR l_get_parent_task(c_element_version_id NUMBER)
2538: IS
2539: SELECT rel.object_id_from1
2540: FROM pa_object_relationships rel
2541: WHERE rel.object_id_to1 = c_element_version_id
2542: AND rel.object_type_to = 'PA_TASKS'
2543: AND rel.relationship_type = 'S'
2544: AND rel.object_type_from = 'PA_TASKS';

Line 2786: pa_object_relationships por,

2782: l_dummy VARCHAR2(1);
2783: CURSOR c_get_del_associated_task IS
2784: SELECT 'x'
2785: FROM pa_proj_elements ppe,
2786: pa_object_relationships por,
2787: pa_task_types ttype
2788: WHERE
2789: ppe.object_type = 'PA_TASKS'
2790: and ppe.proj_element_id = por.object_id_from2

Line 7374: from pa_object_relationships

7370: and parent_structure_version_id = p_structure_version_id;
7371:
7372: cursor c2(p_fin_task_ver_id NUMBER) is
7373: select object_id_from1
7374: from pa_object_relationships
7375: where relationship_type='M'
7376: and object_type_from='PA_TASKS'
7377: and object_type_to='PA_TASKS'
7378: and object_id_to1 = p_fin_task_ver_id;

Line 12889: pa_object_relationships por,

12885: nvl(ppe.baseline_start_date,ppevs.scheduled_start_date) sch_start_date,
12886: nvl(ppe.baseline_finish_date,ppevs.scheduled_finish_date) sch_end_date
12887: from pa_proj_element_versions ppev1,
12888: pa_proj_element_versions ppev2,
12889: pa_object_relationships por,
12890: pa_proj_elements ppe,
12891: pa_proj_elem_ver_schedule ppevs
12892: where ppev1.parent_structure_version_id = p_structure_version_id
12893: and ppev1.proj_element_id=ppe.proj_element_id