APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1522: ,pa_proj_element_versions ppv5

1518: -----,pa_percent_completes ppc
1519: ,pa_project_statuses pps
1520: ,pa_project_statuses pps5
1521: ,pa_proj_elements ppe5
1522: ,pa_proj_element_versions ppv5
1523: ,pa_proj_workplan_attr ppwa
1524: ,pa_proj_element_versions ppev6
1525: ,pa_proj_progress_attr pppa
1526: ,pa_proj_element_versions ppv2

Line 1524: ,pa_proj_element_versions ppev6

1520: ,pa_project_statuses pps5
1521: ,pa_proj_elements ppe5
1522: ,pa_proj_element_versions ppv5
1523: ,pa_proj_workplan_attr ppwa
1524: ,pa_proj_element_versions ppev6
1525: ,pa_proj_progress_attr pppa
1526: ,pa_proj_element_versions ppv2
1527: ,pa_tasks pt
1528: ,pa_proj_elements ppe

Line 1526: ,pa_proj_element_versions ppv2

1522: ,pa_proj_element_versions ppv5
1523: ,pa_proj_workplan_attr ppwa
1524: ,pa_proj_element_versions ppev6
1525: ,pa_proj_progress_attr pppa
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

Line 1529: ,pa_proj_element_versions ppv

1525: ,pa_proj_progress_attr pppa
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

Line 1532: ,pa_proj_element_versions ppevph

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
1535: ppe.proj_element_id = ppv.proj_element_id
1536: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 2337: ,pa_proj_element_versions ppv5

2333: -----,pa_percent_completes ppc Bug 5580992
2334: ,pa_project_statuses pps
2335: ,pa_project_statuses pps5
2336: ,pa_proj_elements ppe5
2337: ,pa_proj_element_versions ppv5
2338: ,pa_proj_workplan_attr ppwa
2339: ,pa_proj_element_versions ppev6
2340: ,pa_proj_progress_attr pppa
2341: ,pa_proj_element_versions ppv2

Line 2339: ,pa_proj_element_versions ppev6

2335: ,pa_project_statuses pps5
2336: ,pa_proj_elements ppe5
2337: ,pa_proj_element_versions ppv5
2338: ,pa_proj_workplan_attr ppwa
2339: ,pa_proj_element_versions ppev6
2340: ,pa_proj_progress_attr pppa
2341: ,pa_proj_element_versions ppv2
2342: ,pa_tasks pt
2343: ,pa_proj_elements ppe

Line 2341: ,pa_proj_element_versions ppv2

2337: ,pa_proj_element_versions ppv5
2338: ,pa_proj_workplan_attr ppwa
2339: ,pa_proj_element_versions ppev6
2340: ,pa_proj_progress_attr pppa
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

Line 2344: ,pa_proj_element_versions ppv

2340: ,pa_proj_progress_attr pppa
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

Line 2347: ,pa_proj_element_versions ppevph

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
2350: ppe.proj_element_id = ppv.proj_element_id
2351: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 3195: ,pa_proj_element_versions ppv5

3191: -----,pa_percent_completes ppc
3192: ,pa_project_statuses pps
3193: ,pa_project_statuses pps5
3194: ,pa_proj_elements ppe5
3195: ,pa_proj_element_versions ppv5
3196: ,pa_proj_workplan_attr ppwa
3197: ,pa_proj_element_versions ppev6
3198: ,pa_proj_progress_attr pppa
3199: ,pa_proj_element_versions ppv2

Line 3197: ,pa_proj_element_versions ppev6

3193: ,pa_project_statuses pps5
3194: ,pa_proj_elements ppe5
3195: ,pa_proj_element_versions ppv5
3196: ,pa_proj_workplan_attr ppwa
3197: ,pa_proj_element_versions ppev6
3198: ,pa_proj_progress_attr pppa
3199: ,pa_proj_element_versions ppv2
3200: ,pa_tasks pt
3201: ,pa_proj_elements ppe

Line 3199: ,pa_proj_element_versions ppv2

3195: ,pa_proj_element_versions ppv5
3196: ,pa_proj_workplan_attr ppwa
3197: ,pa_proj_element_versions ppev6
3198: ,pa_proj_progress_attr pppa
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

Line 3202: ,pa_proj_element_versions ppv

3198: ,pa_proj_progress_attr pppa
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

Line 3205: ,pa_proj_element_versions ppevph

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
3208: ppe.proj_element_id = ppv.proj_element_id
3209: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 4166: ,pa_proj_element_versions ppv5

4162: -----,pa_percent_completes ppc
4163: ,pa_project_statuses pps
4164: ,pa_project_statuses pps5
4165: ,pa_proj_elements ppe5
4166: ,pa_proj_element_versions ppv5
4167: ,pa_proj_workplan_attr ppwa
4168: ,pa_proj_element_versions ppev6
4169: ,pa_proj_progress_attr pppa
4170: ,pa_proj_element_versions ppv2

Line 4168: ,pa_proj_element_versions ppev6

4164: ,pa_project_statuses pps5
4165: ,pa_proj_elements ppe5
4166: ,pa_proj_element_versions ppv5
4167: ,pa_proj_workplan_attr ppwa
4168: ,pa_proj_element_versions ppev6
4169: ,pa_proj_progress_attr pppa
4170: ,pa_proj_element_versions ppv2
4171: ,pa_tasks pt
4172: ,pa_proj_elements ppe

Line 4170: ,pa_proj_element_versions ppv2

4166: ,pa_proj_element_versions ppv5
4167: ,pa_proj_workplan_attr ppwa
4168: ,pa_proj_element_versions ppev6
4169: ,pa_proj_progress_attr pppa
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

Line 4173: ,pa_proj_element_versions ppv

4169: ,pa_proj_progress_attr pppa
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

Line 4176: ,pa_proj_element_versions ppevph

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
4179: ppe.proj_element_id = ppv.proj_element_id
4180: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 4991: ,pa_proj_element_versions ppv5

4987: -----,pa_percent_completes ppc
4988: ,pa_project_statuses pps
4989: ,pa_project_statuses pps5
4990: ,pa_proj_elements ppe5
4991: ,pa_proj_element_versions ppv5
4992: ,pa_proj_workplan_attr ppwa
4993: ,pa_proj_element_versions ppev6
4994: ,pa_proj_progress_attr pppa
4995: ,pa_proj_element_versions ppv2

Line 4993: ,pa_proj_element_versions ppev6

4989: ,pa_project_statuses pps5
4990: ,pa_proj_elements ppe5
4991: ,pa_proj_element_versions ppv5
4992: ,pa_proj_workplan_attr ppwa
4993: ,pa_proj_element_versions ppev6
4994: ,pa_proj_progress_attr pppa
4995: ,pa_proj_element_versions ppv2
4996: ,pa_tasks pt
4997: ,pa_proj_elements ppe

Line 4995: ,pa_proj_element_versions ppv2

4991: ,pa_proj_element_versions ppv5
4992: ,pa_proj_workplan_attr ppwa
4993: ,pa_proj_element_versions ppev6
4994: ,pa_proj_progress_attr pppa
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

Line 4998: ,pa_proj_element_versions ppv

4994: ,pa_proj_progress_attr pppa
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

Line 5001: ,pa_proj_element_versions ppevph

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
5004: ppe.proj_element_id = ppv.proj_element_id
5005: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 5817: ,pa_proj_element_versions ppv5

5813: -----,pa_percent_completes ppc
5814: ,pa_project_statuses pps
5815: ,pa_project_statuses pps5
5816: ,pa_proj_elements ppe5
5817: ,pa_proj_element_versions ppv5
5818: ,pa_proj_workplan_attr ppwa
5819: ,pa_proj_element_versions ppev6
5820: ,pa_proj_progress_attr pppa
5821: ,pa_proj_element_versions ppv2

Line 5819: ,pa_proj_element_versions ppev6

5815: ,pa_project_statuses pps5
5816: ,pa_proj_elements ppe5
5817: ,pa_proj_element_versions ppv5
5818: ,pa_proj_workplan_attr ppwa
5819: ,pa_proj_element_versions ppev6
5820: ,pa_proj_progress_attr pppa
5821: ,pa_proj_element_versions ppv2
5822: ,pa_tasks pt
5823: ,pa_proj_elements ppe

Line 5821: ,pa_proj_element_versions ppv2

5817: ,pa_proj_element_versions ppv5
5818: ,pa_proj_workplan_attr ppwa
5819: ,pa_proj_element_versions ppev6
5820: ,pa_proj_progress_attr pppa
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

Line 5824: ,pa_proj_element_versions ppv

5820: ,pa_proj_progress_attr pppa
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

Line 5827: ,pa_proj_element_versions ppevph

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
5830: ppe.proj_element_id = ppv.proj_element_id
5831: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 5980: ,pa_proj_element_versions ppv --bug 4448499

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
5984: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

Line 5984: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

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
5984: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
5985: WHERE ppes.project_id = ppevs.project_id
5986: AND ppes.proj_element_id = ppevs.proj_element_id
5987: AND ppes.link_task_flag = 'Y'
5988: AND ppes.object_type = 'PA_TASKS'

Line 6071: ,pa_proj_element_versions ppv

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
6075: FROM pa_proj_elements ppes

Line 6076: , pa_proj_element_versions ppevs

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
6075: FROM pa_proj_elements ppes
6076: , pa_proj_element_versions ppevs
6077: WHERE ppes.project_id = ppevs.project_id
6078: AND ppes.proj_element_id = ppevs.proj_element_id
6079: AND ppes.link_task_flag = 'Y'
6080: AND ppes.object_type = 'PA_TASKS'

Line 6749: ,pa_proj_element_versions ppv2

6745: ,per_all_people_f papf
6746: ,pa_projects_all ppa
6747: ,pa_page_layouts ppl
6748: ,pa_project_statuses pps
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

Line 6751: ,pa_proj_element_versions ppv3

6747: ,pa_page_layouts ppl
6748: ,pa_project_statuses pps
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

Line 6752: ,pa_proj_element_versions ppv1

6748: ,pa_project_statuses pps
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

Line 6761: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

6757: ,pa_progress_rollup ppru
6758: ,pa_proj_progress_attr pppa
6759: where
6760: por.object_id_from1 in ( SELECT ppevs.element_version_id
6761: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
6762: WHERE ppes.project_id = ppevs.project_id
6763: AND ppes.proj_element_id = ppevs.proj_element_id
6764: AND ppes.link_task_flag = 'Y'
6765: AND ppes.object_type = 'PA_TASKS'

Line 7239: ,pa_proj_element_versions ppv2

7235: ,per_all_people_f papf
7236: ,pa_projects_all ppa
7237: ,pa_page_layouts ppl
7238: ,pa_project_statuses pps
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

Line 7241: ,pa_proj_element_versions ppv3

7237: ,pa_page_layouts ppl
7238: ,pa_project_statuses pps
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

Line 7242: ,pa_proj_element_versions ppv1

7238: ,pa_project_statuses pps
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

Line 7251: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs

7247: ,pa_progress_rollup ppru
7248: ,pa_proj_progress_attr pppa
7249: where
7250: por.object_id_from1 in ( SELECT ppevs.element_version_id
7251: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
7252: WHERE ppes.project_id = ppevs.project_id
7253: AND ppes.proj_element_id = ppevs.proj_element_id
7254: AND ppes.link_task_flag = 'Y'
7255: AND ppes.object_type = 'PA_TASKS'

Line 8072: ,pa_proj_element_versions ppv5

8068: ----,pa_percent_completes ppc
8069: ,pa_project_statuses pps
8070: ,pa_project_statuses pps5
8071: ,pa_proj_elements ppe5
8072: ,pa_proj_element_versions ppv5
8073: ,pa_proj_workplan_attr ppwa
8074: ,pa_proj_element_versions ppev6
8075: ,pa_proj_progress_attr pppa
8076: ,pa_proj_element_versions ppv2

Line 8074: ,pa_proj_element_versions ppev6

8070: ,pa_project_statuses pps5
8071: ,pa_proj_elements ppe5
8072: ,pa_proj_element_versions ppv5
8073: ,pa_proj_workplan_attr ppwa
8074: ,pa_proj_element_versions ppev6
8075: ,pa_proj_progress_attr pppa
8076: ,pa_proj_element_versions ppv2
8077: ,pa_tasks pt
8078: ,pa_proj_elements ppe

Line 8076: ,pa_proj_element_versions ppv2

8072: ,pa_proj_element_versions ppv5
8073: ,pa_proj_workplan_attr ppwa
8074: ,pa_proj_element_versions ppev6
8075: ,pa_proj_progress_attr pppa
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

Line 8079: ,pa_proj_element_versions ppv

8075: ,pa_proj_progress_attr pppa
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

Line 8082: ,pa_proj_element_versions ppevph

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
8085: ppe.proj_element_id = ppv.proj_element_id
8086: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 8832: ,pa_proj_element_versions ppv5

8828: ----,pa_percent_completes ppc
8829: ,pa_project_statuses pps
8830: ,pa_project_statuses pps5
8831: ,pa_proj_elements ppe5
8832: ,pa_proj_element_versions ppv5
8833: ,pa_proj_workplan_attr ppwa
8834: ,pa_proj_element_versions ppev6
8835: ,pa_proj_progress_attr pppa
8836: ,pa_proj_element_versions ppv2

Line 8834: ,pa_proj_element_versions ppev6

8830: ,pa_project_statuses pps5
8831: ,pa_proj_elements ppe5
8832: ,pa_proj_element_versions ppv5
8833: ,pa_proj_workplan_attr ppwa
8834: ,pa_proj_element_versions ppev6
8835: ,pa_proj_progress_attr pppa
8836: ,pa_proj_element_versions ppv2
8837: ,pa_tasks pt
8838: ,pa_proj_elements ppe

Line 8836: ,pa_proj_element_versions ppv2

8832: ,pa_proj_element_versions ppv5
8833: ,pa_proj_workplan_attr ppwa
8834: ,pa_proj_element_versions ppev6
8835: ,pa_proj_progress_attr pppa
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

Line 8839: ,pa_proj_element_versions ppv

8835: ,pa_proj_progress_attr pppa
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

Line 8842: ,pa_proj_element_versions ppevph

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
8845: ppe.proj_element_id = ppv.proj_element_id
8846: AND ppv.parent_structure_version_id = ppvs.element_version_id

Line 9765: ,pa_proj_element_versions ppv5

9761: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
9762: FROM pa_proj_elem_ver_structure ppvs
9763: ,pa_proj_elem_ver_schedule ppvsch
9764: ,pa_proj_elements ppe5
9765: ,pa_proj_element_versions ppv5
9766: ,per_all_people_f papf
9767: ,pa_project_statuses pps2
9768: ,pa_lookups fl3
9769: ,hr_all_organization_units_tl hou

Line 9771: ,pa_proj_element_versions ppv2

9767: ,pa_project_statuses pps2
9768: ,pa_lookups fl3
9769: ,hr_all_organization_units_tl hou
9770: ,pa_projects_all ppa
9771: ,pa_proj_element_versions ppv2
9772: ,pa_proj_structure_types ppst
9773: ,pa_structure_types pst
9774: ,fnd_lookups fl1
9775: ,fnd_lookups fl2

Line 9788: ,pa_proj_element_versions ppv

9784: ,pa_project_statuses pps5
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

Line 10592: ,pa_proj_element_versions ppv5

10588: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
10589: FROM pa_proj_elem_ver_structure ppvs
10590: ,pa_proj_elem_ver_schedule ppvsch
10591: ,pa_proj_elements ppe5
10592: ,pa_proj_element_versions ppv5
10593: ,per_all_people_f papf
10594: ,pa_project_statuses pps2
10595: ,pa_lookups fl3
10596: ,hr_all_organization_units_tl hou

Line 10598: ,pa_proj_element_versions ppv2

10594: ,pa_project_statuses pps2
10595: ,pa_lookups fl3
10596: ,hr_all_organization_units_tl hou
10597: ,pa_projects_all ppa
10598: ,pa_proj_element_versions ppv2
10599: ,pa_proj_structure_types ppst
10600: ,pa_structure_types pst
10601: ,fnd_lookups fl1
10602: ,fnd_lookups fl2

Line 10615: ,pa_proj_element_versions ppv

10611: ,pa_project_statuses pps5
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

Line 11420: ,pa_proj_element_versions ppv5

11416: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
11417: FROM pa_proj_elem_ver_structure ppvs
11418: ,pa_proj_elem_ver_schedule ppvsch
11419: ,pa_proj_elements ppe5
11420: ,pa_proj_element_versions ppv5
11421: ,per_all_people_f papf
11422: ,pa_project_statuses pps2
11423: ,pa_lookups fl3
11424: ,hr_all_organization_units_tl hou

Line 11426: ,pa_proj_element_versions ppv2

11422: ,pa_project_statuses pps2
11423: ,pa_lookups fl3
11424: ,hr_all_organization_units_tl hou
11425: ,pa_projects_all ppa
11426: ,pa_proj_element_versions ppv2
11427: ,pa_proj_structure_types ppst
11428: ,pa_structure_types pst
11429: ,fnd_lookups fl1
11430: ,fnd_lookups fl2

Line 11443: ,pa_proj_element_versions ppv

11439: ,pa_project_statuses pps5
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

Line 12344: ,pa_proj_element_versions ppv5

12340: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
12341: FROM pa_proj_elem_ver_structure ppvs
12342: ,pa_proj_elem_ver_schedule ppvsch
12343: ,pa_proj_elements ppe5
12344: ,pa_proj_element_versions ppv5
12345: ,per_all_people_f papf
12346: ,pa_project_statuses pps2
12347: ,pa_lookups fl3
12348: ,hr_all_organization_units_tl hou

Line 12350: ,pa_proj_element_versions ppv2

12346: ,pa_project_statuses pps2
12347: ,pa_lookups fl3
12348: ,hr_all_organization_units_tl hou
12349: ,pa_projects_all ppa
12350: ,pa_proj_element_versions ppv2
12351: ,pa_proj_structure_types ppst
12352: ,pa_structure_types pst
12353: ,fnd_lookups fl1
12354: ,fnd_lookups fl2

Line 12367: ,pa_proj_element_versions ppv

12363: ,pa_project_statuses pps5
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

Line 13140: ,pa_proj_element_versions ppv5

13136: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13137: FROM pa_proj_elem_ver_structure ppvs
13138: ,pa_proj_elem_ver_schedule ppvsch
13139: ,pa_proj_elements ppe5
13140: ,pa_proj_element_versions ppv5
13141: ,per_all_people_f papf
13142: ,pa_project_statuses pps2
13143: ,pa_lookups fl3
13144: ,hr_all_organization_units_tl hou

Line 13146: ,pa_proj_element_versions ppv2

13142: ,pa_project_statuses pps2
13143: ,pa_lookups fl3
13144: ,hr_all_organization_units_tl hou
13145: ,pa_projects_all ppa
13146: ,pa_proj_element_versions ppv2
13147: ,pa_proj_structure_types ppst
13148: ,pa_structure_types pst
13149: ,fnd_lookups fl1
13150: ,fnd_lookups fl2

Line 13163: ,pa_proj_element_versions ppv

13159: ,pa_project_statuses pps5
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

Line 13937: ,pa_proj_element_versions ppv5

13933: ,nvl(pfxat.prj_brdn_cost,0) - nvl(pfxat.prj_base_brdn_cost,0) PLANNED_BASELINE_COST_VAR -- Added for bug 5090355
13934: FROM pa_proj_elem_ver_structure ppvs
13935: ,pa_proj_elem_ver_schedule ppvsch
13936: ,pa_proj_elements ppe5
13937: ,pa_proj_element_versions ppv5
13938: ,per_all_people_f papf
13939: ,pa_project_statuses pps2
13940: ,pa_lookups fl3
13941: ,hr_all_organization_units_tl hou

Line 13943: ,pa_proj_element_versions ppv2

13939: ,pa_project_statuses pps2
13940: ,pa_lookups fl3
13941: ,hr_all_organization_units_tl hou
13942: ,pa_projects_all ppa
13943: ,pa_proj_element_versions ppv2
13944: ,pa_proj_structure_types ppst
13945: ,pa_structure_types pst
13946: ,fnd_lookups fl1
13947: ,fnd_lookups fl2

Line 13960: ,pa_proj_element_versions ppv

13956: ,pa_project_statuses pps5
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