APPS.PA_PROGRESS_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 550: FROM pa_object_relationships

546: -- Bug 4506461 Begin
547: -- 4651069 : Removed LF relationship here
548: CURSOR c_get_any_childs_have_subprj(c_task_version_id NUMBER) IS
549: SELECT 'Y'
550: FROM pa_object_relationships
551: WHERE --relationship_type in ( 'LW', 'LF' )
552: relationship_type = 'LW'
553: AND object_id_from1 IN
554: (SELECT object_id_to1

Line 555: FROM pa_object_relationships

551: WHERE --relationship_type in ( 'LW', 'LF' )
552: relationship_type = 'LW'
553: AND object_id_from1 IN
554: (SELECT object_id_to1
555: FROM pa_object_relationships
556: START WITH object_id_from1 = c_task_version_id
557: AND relationship_type = 'S'
558: CONNECT BY PRIOR object_id_to1 = object_id_from1
559: AND relationship_type = 'S')

Line 5155: FROM pa_object_relationships

5151: SELECT pobj.object_id_to1, ppev1.proj_element_id,
5152: sch.scheduled_start_date
5153: FROM
5154: ( SELECT object_id_from1, object_id_to1
5155: FROM pa_object_relationships
5156: START WITH object_id_from1 = p_object_version_id
5157: and relationship_type = 'S'
5158: CONNECT BY object_id_from1 = PRIOR object_id_to1
5159: and relationship_type = 'S'

Line 10721: from pa_object_relationships por,

10717: AND ppr.current_flag(+) = 'Y'
10718: AND ppr.structure_type(+) = c_structure_type
10719: AND ppr.structure_version_id(+) is null -- Bug 3957457
10720: and not exists (select 1
10721: from pa_object_relationships por,
10722: pa_proj_element_versions ppv1
10723: where por.object_id_from1 = ppv.element_version_id
10724: and relationship_type = 'S'
10725: and ppv1.element_version_id = por.object_id_to1

Line 10735: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr, pa_object_relationships por

10731: IS
10732: -- Bug 3952006 : get percent complete from pa_progress_rollup instead of pa_percent_complete
10733: --SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage
10734: SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.base_percent_complete) completed_percentage
10735: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr, pa_object_relationships por
10736: WHERE ppv.project_id = p_project_id
10737: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3952006
10738: AND ppv.project_id = ppr.project_id(+)
10739: AND por.object_id_to1 = c_object_version_id

Line 12941: from pa_object_relationships

12937: and current_flag = 'Y'
12938: and object_type = 'PA_TASKS'
12939: and structure_type = 'WORKPLAN'
12940: and not exists (select '1' --- 4871809,5503428
12941: from pa_object_relationships
12942: where object_Type_from = 'PA_TASKS'
12943: and relationship_type = 'S'
12944: and object_id_from1 = ppc.object_version_id);
12945:

Line 20947: ,pa_object_relationships por1

20943: FROM
20944: --- removed join with pa_structures_links_v for performance improvement
20945: pa_proj_element_versions ppv1 --4871809
20946: ,pa_proj_element_versions ppv2
20947: ,pa_object_relationships por1
20948: ,pa_object_relationships por2
20949: ,pa_progress_rollup ppr
20950: WHERE
20951: ppv2.element_version_id = por1.object_id_to1

Line 20948: ,pa_object_relationships por2

20944: --- removed join with pa_structures_links_v for performance improvement
20945: pa_proj_element_versions ppv1 --4871809
20946: ,pa_proj_element_versions ppv2
20947: ,pa_object_relationships por1
20948: ,pa_object_relationships por2
20949: ,pa_progress_rollup ppr
20950: WHERE
20951: ppv2.element_version_id = por1.object_id_to1
20952: AND ppv2.object_type = 'PA_STRUCTURES'