APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 665: FROM pa_object_relationships

661: SELECT 'Y'
662: FROM DUAL
663: WHERE EXISTS
664: (SELECT 1
665: FROM pa_object_relationships
666: WHERE relationship_type='D');
667:
668: CURSOR C3(c_ci_type VARCHAR2)
669: IS

Line 1530: ,pa_object_relationships por

1526: ,pa_proj_element_versions ppv2
1527: ,pa_tasks pt
1528: ,pa_proj_elements ppe
1529: ,pa_proj_element_versions ppv
1530: ,pa_object_relationships por
1531: ,pa_proj_elements ppeph
1532: ,pa_proj_element_versions ppevph
1533: ,pji_fm_xbs_accum_tmp1 pfxat
1534: WHERE

Line 2345: ,pa_object_relationships por

2341: ,pa_proj_element_versions ppv2
2342: ,pa_tasks pt
2343: ,pa_proj_elements ppe
2344: ,pa_proj_element_versions ppv
2345: ,pa_object_relationships por
2346: ,pa_proj_elements ppeph
2347: ,pa_proj_element_versions ppevph
2348: ,pji_fm_xbs_accum_tmp1 pfxat
2349: WHERE

Line 3203: ,pa_object_relationships por

3199: ,pa_proj_element_versions ppv2
3200: ,pa_tasks pt
3201: ,pa_proj_elements ppe
3202: ,pa_proj_element_versions ppv
3203: ,pa_object_relationships por
3204: ,pa_proj_elements ppeph
3205: ,pa_proj_element_versions ppevph
3206: ,pji_fm_xbs_accum_tmp1 pfxat
3207: WHERE

Line 4174: ,pa_object_relationships por

4170: ,pa_proj_element_versions ppv2
4171: ,pa_tasks pt
4172: ,pa_proj_elements ppe
4173: ,pa_proj_element_versions ppv
4174: ,pa_object_relationships por
4175: ,pa_proj_elements ppeph
4176: ,pa_proj_element_versions ppevph
4177: ,pji_fm_xbs_accum_tmp1 pfxat
4178: WHERE

Line 4999: ,pa_object_relationships por

4995: ,pa_proj_element_versions ppv2
4996: ,pa_tasks pt
4997: ,pa_proj_elements ppe
4998: ,pa_proj_element_versions ppv
4999: ,pa_object_relationships por
5000: ,pa_proj_elements ppeph
5001: ,pa_proj_element_versions ppevph
5002: ,pji_fm_xbs_accum_tmp1 pfxat
5003: WHERE

Line 5825: ,pa_object_relationships por

5821: ,pa_proj_element_versions ppv2
5822: ,pa_tasks pt
5823: ,pa_proj_elements ppe
5824: ,pa_proj_element_versions ppv
5825: ,pa_object_relationships por
5826: ,pa_proj_elements ppeph
5827: ,pa_proj_element_versions ppevph
5828: ,pji_fm_xbs_accum_tmp1 pfxat
5829: WHERE

Line 5979: from pa_object_relationships por1

5975:
5976: cursor get_structures IS
5977: select por1.object_id_to1, por1.object_id_to2
5978: ,display_sequence, por1.object_id_from2 --bug 4448499
5979: from pa_object_relationships por1
5980: ,pa_proj_element_versions ppv --bug 4448499
5981: where por1.relationship_type = 'LW'
5982: and ppv.element_version_id = por1.object_id_from1 --bug 4448499
5983: and por1.object_id_from1 IN (SELECT ppevs.element_version_id

Line 6001: pa_object_relationships b

5997: CURSOR cur_get_parent_disp( c_subproject_id NUMBER, c_subproj_struc_ver_id NUMBER )
5998: IS
5999: SELECT a.display_sequence
6000: FROM pa_structures_tasks_tmp a,
6001: pa_object_relationships b
6002: WHERE b.object_id_to1=c_subproj_struc_ver_id
6003: AND b.object_type_to IN ('PA_STRUCTURES', 'PA_TASKS')
6004: AND b.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
6005: AND b.relationship_type = 'S'

Line 6070: from pa_object_relationships por1

6066: -- re-populated in the context of the currently accessed parent project.
6067:
6068: delete from pa_structures_tasks_tmp pstt
6069: where pstt.project_id in (select por1.object_id_to2
6070: from pa_object_relationships por1
6071: ,pa_proj_element_versions ppv
6072: where por1.relationship_type = 'LW'
6073: and ppv.element_version_id = por1.object_id_from1
6074: and por1.object_id_from1 IN (SELECT ppevs.element_version_id

Line 6753: ,pa_object_relationships por

6749: ,pa_proj_element_versions ppv2
6750: ,pa_proj_elements ppe
6751: ,pa_proj_element_versions ppv3
6752: ,pa_proj_element_versions ppv1
6753: ,pa_object_relationships por
6754: ,pa_object_relationships por2
6755: ,pji_fm_xbs_accum_tmp1 pfxat
6756: ----,pa_percent_completes ppc
6757: ,pa_progress_rollup ppru

Line 6754: ,pa_object_relationships por2

6750: ,pa_proj_elements ppe
6751: ,pa_proj_element_versions ppv3
6752: ,pa_proj_element_versions ppv1
6753: ,pa_object_relationships por
6754: ,pa_object_relationships por2
6755: ,pji_fm_xbs_accum_tmp1 pfxat
6756: ----,pa_percent_completes ppc
6757: ,pa_progress_rollup ppru
6758: ,pa_proj_progress_attr pppa

Line 7243: ,pa_object_relationships por

7239: ,pa_proj_element_versions ppv2
7240: ,pa_proj_elements ppe
7241: ,pa_proj_element_versions ppv3
7242: ,pa_proj_element_versions ppv1
7243: ,pa_object_relationships por
7244: ,pa_object_relationships por2
7245: ,pji_fm_xbs_accum_tmp1 pfxat
7246: ----,pa_percent_completes ppc
7247: ,pa_progress_rollup ppru

Line 7244: ,pa_object_relationships por2

7240: ,pa_proj_elements ppe
7241: ,pa_proj_element_versions ppv3
7242: ,pa_proj_element_versions ppv1
7243: ,pa_object_relationships por
7244: ,pa_object_relationships por2
7245: ,pji_fm_xbs_accum_tmp1 pfxat
7246: ----,pa_percent_completes ppc
7247: ,pa_progress_rollup ppru
7248: ,pa_proj_progress_attr pppa

Line 8080: ,pa_object_relationships por

8076: ,pa_proj_element_versions ppv2
8077: ,pa_tasks pt
8078: ,pa_proj_elements ppe
8079: ,pa_proj_element_versions ppv
8080: ,pa_object_relationships por
8081: ,pa_proj_elements ppeph
8082: ,pa_proj_element_versions ppevph
8083: --,pji_fm_xbs_accum_tmp1 pfxat
8084: WHERE

Line 8840: ,pa_object_relationships por

8836: ,pa_proj_element_versions ppv2
8837: ,pa_tasks pt
8838: ,pa_proj_elements ppe
8839: ,pa_proj_element_versions ppv
8840: ,pa_object_relationships por
8841: ,pa_proj_elements ppeph
8842: ,pa_proj_element_versions ppevph
8843: --,pji_fm_xbs_accum_tmp1 pfxat
8844: WHERE

Line 9789: ,pa_object_relationships por

9785: ,pa_task_types tt
9786: ,pa_tasks pt
9787: ,pa_proj_elements ppe
9788: ,pa_proj_element_versions ppv
9789: ,pa_object_relationships por
9790: ,pji_fm_xbs_accum_tmp1 pfxat
9791: WHERE
9792: ppe.proj_element_id = ppv.proj_element_id
9793: AND ppe.project_id = ppv.project_id

Line 10616: ,pa_object_relationships por

10612: ,pa_task_types tt
10613: ,pa_tasks pt
10614: ,pa_proj_elements ppe
10615: ,pa_proj_element_versions ppv
10616: ,pa_object_relationships por
10617: ,pji_fm_xbs_accum_tmp1 pfxat
10618: WHERE
10619: ppe.proj_element_id = ppv.proj_element_id
10620: AND ppe.project_id = ppv.project_id

Line 11444: ,pa_object_relationships por

11440: ,pa_task_types tt
11441: ,pa_tasks pt
11442: ,pa_proj_elements ppe
11443: ,pa_proj_element_versions ppv
11444: ,pa_object_relationships por
11445: ,pji_fm_xbs_accum_tmp1 pfxat
11446: WHERE
11447: ppe.proj_element_id = ppv.proj_element_id
11448: AND ppe.project_id = ppv.project_id

Line 12368: ,pa_object_relationships por

12364: ,pa_task_types tt
12365: ,pa_tasks pt
12366: ,pa_proj_elements ppe
12367: ,pa_proj_element_versions ppv
12368: ,pa_object_relationships por
12369: ,pji_fm_xbs_accum_tmp1 pfxat
12370: WHERE
12371: ppe.proj_element_id = ppv.proj_element_id
12372: AND ppe.project_id = ppv.project_id

Line 13164: ,pa_object_relationships por

13160: ,pa_task_types tt
13161: ,pa_tasks pt
13162: ,pa_proj_elements ppe
13163: ,pa_proj_element_versions ppv
13164: ,pa_object_relationships por
13165: ,pji_fm_xbs_accum_tmp1 pfxat
13166: WHERE
13167: ppe.proj_element_id = ppv.proj_element_id
13168: AND ppe.project_id = ppv.project_id

Line 13961: ,pa_object_relationships por

13957: ,pa_task_types tt
13958: ,pa_tasks pt
13959: ,pa_proj_elements ppe
13960: ,pa_proj_element_versions ppv
13961: ,pa_object_relationships por
13962: ,pji_fm_xbs_accum_tmp1 pfxat
13963: WHERE
13964: ppe.proj_element_id = ppv.proj_element_id
13965: AND ppe.project_id = ppv.project_id