APPS.PA_PROGRESS_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 551: FROM pa_object_relationships

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

Line 556: FROM pa_object_relationships

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

Line 5559: FROM pa_object_relationships

5555: SELECT pobj.object_id_to1, ppev1.proj_element_id,
5556: sch.scheduled_start_date
5557: FROM
5558: ( SELECT object_id_from1, object_id_to1
5559: FROM pa_object_relationships
5560: START WITH object_id_from1 = p_object_version_id
5561: and relationship_type = 'S'
5562: CONNECT BY object_id_from1 = PRIOR object_id_to1
5563: and relationship_type = 'S'

Line 11163: from pa_object_relationships por,

11159: AND ppr.current_flag(+) = 'Y'
11160: AND ppr.structure_type(+) = c_structure_type
11161: AND ppr.structure_version_id(+) is null -- Bug 3957457
11162: and not exists (select 1
11163: from pa_object_relationships por,
11164: pa_proj_element_versions ppv1
11165: where por.object_id_from1 = ppv.element_version_id
11166: and relationship_type = 'S'
11167: and ppv1.element_version_id = por.object_id_to1

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

11173: IS
11174: -- Bug 3952006 : get percent complete from pa_progress_rollup instead of pa_percent_complete
11175: --SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage
11176: SELECT ppv.proj_element_id, ppv.element_version_id, ppv.record_version_number, nvl(ppr.completed_percentage, ppr.base_percent_complete) completed_percentage
11177: FROM pa_proj_element_versions ppv, pa_progress_rollup ppr, pa_object_relationships por
11178: WHERE ppv.project_id = p_project_id
11179: AND ppv.parent_structure_version_id = c_structure_version_id -- Bug 3952006
11180: AND ppv.project_id = ppr.project_id(+)
11181: AND por.object_id_to1 = c_object_version_id

Line 13412: from pa_object_relationships

13408: and current_flag = 'Y'
13409: and object_type = 'PA_TASKS'
13410: and structure_type = 'WORKPLAN'
13411: and not exists (select '1' --- 4871809,5503428
13412: from pa_object_relationships
13413: where object_Type_from = 'PA_TASKS'
13414: and relationship_type = 'S'
13415: and object_id_from1 = ppc.object_version_id);
13416:

Line 22410: ,pa_object_relationships por1

22406: FROM
22407: --- removed join with pa_structures_links_v for performance improvement
22408: pa_proj_element_versions ppv1 --4871809
22409: ,pa_proj_element_versions ppv2
22410: ,pa_object_relationships por1
22411: ,pa_object_relationships por2
22412: ,pa_progress_rollup ppr
22413: WHERE
22414: ppv2.element_version_id = por1.object_id_to1

Line 22411: ,pa_object_relationships por2

22407: --- removed join with pa_structures_links_v for performance improvement
22408: pa_proj_element_versions ppv1 --4871809
22409: ,pa_proj_element_versions ppv2
22410: ,pa_object_relationships por1
22411: ,pa_object_relationships por2
22412: ,pa_progress_rollup ppr
22413: WHERE
22414: ppv2.element_version_id = por1.object_id_to1
22415: AND ppv2.object_type = 'PA_STRUCTURES'