eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PVT dependencies on PA_PROJECT_STATUSES

Line 370: from pa_project_statuses

366:
367: CURSOR cur_task_status( c_status_weight VARCHAR2 )
368: IS
369: select project_status_code
370: from pa_project_statuses
371: where project_status_weight = c_status_weight
372: and status_type = 'TASK'
373: and predefined_flag = 'Y';
374:

Line 476: pa_project_statuses pps1,

472: ,'N' update_required
473: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
474: FROM pa_proj_element_versions ppev,
475: pa_progress_rollup ppr,
476: pa_project_statuses pps1,
477: pa_project_statuses pps2,
478: pa_project_statuses pps3 ,
479: pa_proj_rollup_temp temp
480: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 477: pa_project_statuses pps2,

473: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
474: FROM pa_proj_element_versions ppev,
475: pa_progress_rollup ppr,
476: pa_project_statuses pps1,
477: pa_project_statuses pps2,
478: pa_project_statuses pps3 ,
479: pa_proj_rollup_temp temp
480: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
481: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 478: pa_project_statuses pps3 ,

474: FROM pa_proj_element_versions ppev,
475: pa_progress_rollup ppr,
476: pa_project_statuses pps1,
477: pa_project_statuses pps2,
478: pa_project_statuses pps3 ,
479: pa_proj_rollup_temp temp
480: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
481: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
482: temp.object_id = ppev.element_version_id

Line 601: pa_project_statuses pps1,

597: pa_proj_element_versions ppev1,
598: pa_proj_element_versions ppev2,
599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,
601: pa_project_statuses pps1,
602: pa_project_statuses pps2,
603: pa_project_statuses pps3,
604: pa_project_statuses pps4,
605: pa_task_types ttype ,

Line 602: pa_project_statuses pps2,

598: pa_proj_element_versions ppev2,
599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,
601: pa_project_statuses pps1,
602: pa_project_statuses pps2,
603: pa_project_statuses pps3,
604: pa_project_statuses pps4,
605: pa_task_types ttype ,
606: pa_proj_rollup_temp temp

Line 603: pa_project_statuses pps3,

599: pa_progress_rollup ppr,
600: pa_proj_elements ppe,
601: pa_project_statuses pps1,
602: pa_project_statuses pps2,
603: pa_project_statuses pps3,
604: pa_project_statuses pps4,
605: pa_task_types ttype ,
606: pa_proj_rollup_temp temp
607: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 604: pa_project_statuses pps4,

600: pa_proj_elements ppe,
601: pa_project_statuses pps1,
602: pa_project_statuses pps2,
603: pa_project_statuses pps3,
604: pa_project_statuses pps4,
605: pa_task_types ttype ,
606: pa_proj_rollup_temp temp
607: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
608: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 843: pa_project_statuses pps4,

839: pa_object_relationships pobj,
840: pa_proj_element_versions ppev1,
841: pa_proj_element_versions ppev2,
842: pa_proj_elements ppe,
843: pa_project_statuses pps4,
844: pa_task_types ttype ,
845: pa_proj_rollup_temp temp
846: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
847: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 1196: , pa_project_statuses pps2

1192: , pps3.project_status_weight base_weight --base prog status
1193: FROM pa_proj_elements elem
1194: , pa_object_relationships obj
1195: , pa_progress_rollup ppr
1196: , pa_project_statuses pps2
1197: , pa_project_statuses pps3
1198: WHERE obj.object_id_from2= c_task_proj_elem_id
1199: AND obj.object_type_from = 'PA_TASKS'
1200: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 1197: , pa_project_statuses pps3

1193: FROM pa_proj_elements elem
1194: , pa_object_relationships obj
1195: , pa_progress_rollup ppr
1196: , pa_project_statuses pps2
1197: , pa_project_statuses pps3
1198: WHERE obj.object_id_from2= c_task_proj_elem_id
1199: AND obj.object_type_from = 'PA_TASKS'
1200: AND obj.object_type_to = 'PA_DELIVERABLES'
1201: AND obj.relationship_type = 'A'

Line 1239: , pa_project_statuses status

1235: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
1236: IS
1237: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED','Y','N')
1238: FROM pa_proj_elem_ver_structure str
1239: , pa_project_statuses status
1240: where str.element_version_id = c_structure_version_id
1241: AND str.project_id = c_project_id
1242: AND str.status_code = status.project_status_code;
1243:

Line 1360: ,pa_project_statuses pps1

1356: , nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0)) bac_value
1357: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
1358: FROM
1359: pa_progress_rollup ppr
1360: ,pa_project_statuses pps1
1361: ,pa_project_statuses pps2
1362: ,pa_project_statuses pps3
1363: ,pa_project_statuses pps4
1364: ,pa_proj_elements ppe

Line 1361: ,pa_project_statuses pps2

1357: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
1358: FROM
1359: pa_progress_rollup ppr
1360: ,pa_project_statuses pps1
1361: ,pa_project_statuses pps2
1362: ,pa_project_statuses pps3
1363: ,pa_project_statuses pps4
1364: ,pa_proj_elements ppe
1365: WHERE

Line 1362: ,pa_project_statuses pps3

1358: FROM
1359: pa_progress_rollup ppr
1360: ,pa_project_statuses pps1
1361: ,pa_project_statuses pps2
1362: ,pa_project_statuses pps3
1363: ,pa_project_statuses pps4
1364: ,pa_proj_elements ppe
1365: WHERE
1366: ppr.project_id = c_sub_project_id

Line 1363: ,pa_project_statuses pps4

1359: pa_progress_rollup ppr
1360: ,pa_project_statuses pps1
1361: ,pa_project_statuses pps2
1362: ,pa_project_statuses pps3
1363: ,pa_project_statuses pps4
1364: ,pa_proj_elements ppe
1365: WHERE
1366: ppr.project_id = c_sub_project_id
1367: AND ppe.project_id = c_sub_project_id

Line 4503: FROM pa_project_statuses

4499: AND as_of_date = p_as_of_date;
4500:
4501: CURSOR cur_get_status( c_status_weight VARCHAR2, c_status_type VARCHAR2 ) IS
4502: SELECT project_status_code
4503: FROM pa_project_statuses
4504: WHERE project_status_weight = c_status_weight
4505: AND status_type = c_status_type
4506: AND predefined_flag = 'Y';
4507:

Line 4510: FROM pa_project_statuses

4506: AND predefined_flag = 'Y';
4507:
4508: CURSOR cur_get_status_weight(c_status_code VARCHAR2, c_status_type VARCHAR2 ) IS
4509: SELECT project_status_weight
4510: FROM pa_project_statuses
4511: WHERE project_status_code = c_status_code
4512: AND status_type = c_status_type;
4513:
4514: l_child_prog_cycle_id number; ---4701759, 4701727

Line 4569: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

4565: l_current_flag VARCHAR2(1);
4566: l_dummy VARCHAR2(1);
4567: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;
4568: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4569: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4570: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4571: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4572: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;
4573: l_actual_start_date DATE;

Line 4570: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

4566: l_dummy VARCHAR2(1);
4567: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;
4568: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4569: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4570: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4571: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4572: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;
4573: l_actual_start_date DATE;
4574: l_actual_finish_date DATE;

Line 4571: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

4567: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;
4568: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4569: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4570: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4571: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4572: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;
4573: l_actual_start_date DATE;
4574: l_actual_finish_date DATE;
4575: l_estimated_start_date DATE;

Line 5721: pa_project_statuses pps1,

5717: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5718: FROM pa_proj_element_versions ppev,
5719: pa_object_relationships obj,
5720: pa_progress_rollup ppr,
5721: pa_project_statuses pps1,
5722: pa_project_statuses pps2,
5723: pa_project_statuses pps3,
5724: pa_proj_elements ppe -- 4392189
5725: WHERE ppev.element_version_id = c_task_ver_id

Line 5722: pa_project_statuses pps2,

5718: FROM pa_proj_element_versions ppev,
5719: pa_object_relationships obj,
5720: pa_progress_rollup ppr,
5721: pa_project_statuses pps1,
5722: pa_project_statuses pps2,
5723: pa_project_statuses pps3,
5724: pa_proj_elements ppe -- 4392189
5725: WHERE ppev.element_version_id = c_task_ver_id
5726: AND ppev.element_version_id = obj.object_id_to1

Line 5723: pa_project_statuses pps3,

5719: pa_object_relationships obj,
5720: pa_progress_rollup ppr,
5721: pa_project_statuses pps1,
5722: pa_project_statuses pps2,
5723: pa_project_statuses pps3,
5724: pa_proj_elements ppe -- 4392189
5725: WHERE ppev.element_version_id = c_task_ver_id
5726: AND ppev.element_version_id = obj.object_id_to1
5727: AND obj.relationship_type = 'S'

Line 6026: pa_project_statuses pps1,

6022: FROM pa_proj_element_versions ppev1,
6023: pa_proj_element_versions ppev2,
6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,
6027: pa_project_statuses pps2,
6028: pa_project_statuses pps3,
6029: pa_proj_elements ppe -- 4392189
6030: WHERE obj.object_id_from1 = c_task_ver_id

Line 6027: pa_project_statuses pps2,

6023: pa_proj_element_versions ppev2,
6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,
6027: pa_project_statuses pps2,
6028: pa_project_statuses pps3,
6029: pa_proj_elements ppe -- 4392189
6030: WHERE obj.object_id_from1 = c_task_ver_id
6031: AND obj.object_id_from1 = ppev1.element_version_id

Line 6028: pa_project_statuses pps3,

6024: pa_object_relationships obj,
6025: pa_progress_rollup ppr,
6026: pa_project_statuses pps1,
6027: pa_project_statuses pps2,
6028: pa_project_statuses pps3,
6029: pa_proj_elements ppe -- 4392189
6030: WHERE obj.object_id_from1 = c_task_ver_id
6031: AND obj.object_id_from1 = ppev1.element_version_id
6032: AND obj.object_id_to1 = ppev2.element_version_id

Line 6507: , pa_project_statuses pps2

6503: , pps3.project_status_weight base_weight --base prog status
6504: FROM pa_proj_elements elem
6505: , pa_object_relationships obj
6506: , pa_progress_rollup ppr
6507: , pa_project_statuses pps2
6508: , pa_project_statuses pps3
6509: WHERE obj.object_id_from2= c_task_proj_elem_id
6510: ---AND obj.object_id_from1 = c_task_ver_id ---to get delv for specific task ver , object_id_from1 is not populated in this case
6511: AND obj.object_type_from = 'PA_TASKS'

Line 6508: , pa_project_statuses pps3

6504: FROM pa_proj_elements elem
6505: , pa_object_relationships obj
6506: , pa_progress_rollup ppr
6507: , pa_project_statuses pps2
6508: , pa_project_statuses pps3
6509: WHERE obj.object_id_from2= c_task_proj_elem_id
6510: ---AND obj.object_id_from1 = c_task_ver_id ---to get delv for specific task ver , object_id_from1 is not populated in this case
6511: AND obj.object_type_from = 'PA_TASKS'
6512: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 6566: , pa_project_statuses stat

6562: IS
6563: SELECT elem.status_code, stat.project_system_status_code, decode(elem.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code), ttype.prog_entry_enable_flag
6564: FROM pa_proj_elements elem
6565: , pa_task_types ttype
6566: , pa_project_statuses stat
6567: where elem.proj_element_id = c_task_proj_elem_id
6568: AND elem.project_id = c_project_id
6569: AND elem.object_type ='PA_TASKS'
6570: AND elem.type_id = ttype.task_type_id

Line 6585: from pa_project_statuses

6581:
6582: CURSOR cur_task_status( c_status_weight VARCHAR2 )
6583: IS
6584: select project_status_code
6585: from pa_project_statuses
6586: where project_status_weight = c_status_weight
6587: and status_type = 'TASK'
6588: and predefined_flag = 'Y';
6589:

Line 6692: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;

6688: l_POU_LABOR_RAW_COST NUMBER ;
6689: l_PRJ_LABOR_RAW_COST NUMBER ;
6690: l_POU_EQUIP_RAW_COST NUMBER ;
6691: l_PRJ_EQUIP_RAW_COST NUMBER ;
6692: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;
6693: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;
6694: L_TASK_WEIGHTING_PERCENTAGE NUMBER ;
6695: L_PROG_ENTRY_ENABLE_FLAG VARCHAR2(1) ;
6696: l_BASE_PERCENT_COMP_DERIV_CODE VARCHAR2(30) ;

Line 6693: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;

6689: l_PRJ_LABOR_RAW_COST NUMBER ;
6690: l_POU_EQUIP_RAW_COST NUMBER ;
6691: l_PRJ_EQUIP_RAW_COST NUMBER ;
6692: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;
6693: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;
6694: L_TASK_WEIGHTING_PERCENTAGE NUMBER ;
6695: L_PROG_ENTRY_ENABLE_FLAG VARCHAR2(1) ;
6696: l_BASE_PERCENT_COMP_DERIV_CODE VARCHAR2(30) ;
6697: -- Bug 5675437

Line 6710: L_EXISTING_OBJECT_STATUS pa_project_statuses.project_status_code%TYPE ;

6706: FROM PA_PROJ_ELEMENTS
6707: WHERE PROJ_ELEMENT_ID=l_proj_element_id
6708: AND PROJECT_ID = l_project_id;
6709:
6710: L_EXISTING_OBJECT_STATUS pa_project_statuses.project_status_code%TYPE ;
6711: l_Oth_quantity_to_date NUMBER;
6712: l_Oth_etc_quantity NUMBER;
6713:
6714: -- Bug 3879461 End

Line 6846: ,pa_project_statuses pps1

6842: nvl(pfxat.ETC_PRJ_BRDN_COST,0), nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0))) bac_value
6843: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage -- Bug 4506009
6844: FROM
6845: pa_progress_rollup ppr
6846: ,pa_project_statuses pps1
6847: ,pa_project_statuses pps2
6848: ,pa_project_statuses pps3
6849: ,pa_project_statuses pps4
6850: ,pa_proj_elements ppe

Line 6847: ,pa_project_statuses pps2

6843: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage -- Bug 4506009
6844: FROM
6845: pa_progress_rollup ppr
6846: ,pa_project_statuses pps1
6847: ,pa_project_statuses pps2
6848: ,pa_project_statuses pps3
6849: ,pa_project_statuses pps4
6850: ,pa_proj_elements ppe
6851: ,pji_fm_xbs_accum_tmp1 pfxat

Line 6848: ,pa_project_statuses pps3

6844: FROM
6845: pa_progress_rollup ppr
6846: ,pa_project_statuses pps1
6847: ,pa_project_statuses pps2
6848: ,pa_project_statuses pps3
6849: ,pa_project_statuses pps4
6850: ,pa_proj_elements ppe
6851: ,pji_fm_xbs_accum_tmp1 pfxat
6852: WHERE

Line 6849: ,pa_project_statuses pps4

6845: pa_progress_rollup ppr
6846: ,pa_project_statuses pps1
6847: ,pa_project_statuses pps2
6848: ,pa_project_statuses pps3
6849: ,pa_project_statuses pps4
6850: ,pa_proj_elements ppe
6851: ,pji_fm_xbs_accum_tmp1 pfxat
6852: WHERE
6853: ppr.project_id = c_sub_project_id

Line 10881: from pa_project_statuses

10877:
10878: CURSOR cur_task_status( c_status_weight VARCHAR2 )
10879: IS
10880: select project_status_code
10881: from pa_project_statuses
10882: where project_status_weight = c_status_weight
10883: and status_type = 'TASK'
10884: and predefined_flag = 'Y';
10885:

Line 10987: pa_project_statuses pps1,

10983: ,'N' update_required
10984: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
10985: FROM pa_proj_element_versions ppev,
10986: pa_progress_rollup ppr,
10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 10988: pa_project_statuses pps2,

10984: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
10985: FROM pa_proj_element_versions ppev,
10986: pa_progress_rollup ppr,
10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
10992: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 10989: pa_project_statuses pps3 ,

10985: FROM pa_proj_element_versions ppev,
10986: pa_progress_rollup ppr,
10987: pa_project_statuses pps1,
10988: pa_project_statuses pps2,
10989: pa_project_statuses pps3 ,
10990: pa_proj_rollup_temp temp
10991: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
10992: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
10993: temp.object_id = ppev.element_version_id

Line 11112: pa_project_statuses pps1,

11108: pa_proj_element_versions ppev1,
11109: pa_proj_element_versions ppev2,
11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,

Line 11113: pa_project_statuses pps2,

11109: pa_proj_element_versions ppev2,
11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp

Line 11114: pa_project_statuses pps3,

11110: pa_progress_rollup ppr,
11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 11115: pa_project_statuses pps4,

11111: pa_proj_elements ppe,
11112: pa_project_statuses pps1,
11113: pa_project_statuses pps2,
11114: pa_project_statuses pps3,
11115: pa_project_statuses pps4,
11116: pa_task_types ttype ,
11117: pa_proj_rollup_temp temp
11118: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11119: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 11354: pa_project_statuses pps4,

11350: pa_object_relationships pobj,
11351: pa_proj_element_versions ppev1,
11352: pa_proj_element_versions ppev2,
11353: pa_proj_elements ppe,
11354: pa_project_statuses pps4,
11355: pa_task_types ttype ,
11356: pa_proj_rollup_temp temp
11357: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
11358: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 11465: , pa_project_statuses pps2

11461: , pps3.project_status_weight base_weight --base prog status
11462: FROM pa_proj_elements elem
11463: , pa_object_relationships obj
11464: , pa_progress_rollup ppr
11465: , pa_project_statuses pps2
11466: , pa_project_statuses pps3
11467: WHERE obj.object_id_from2= c_task_proj_elem_id
11468: AND obj.object_type_from = 'PA_TASKS'
11469: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 11466: , pa_project_statuses pps3

11462: FROM pa_proj_elements elem
11463: , pa_object_relationships obj
11464: , pa_progress_rollup ppr
11465: , pa_project_statuses pps2
11466: , pa_project_statuses pps3
11467: WHERE obj.object_id_from2= c_task_proj_elem_id
11468: AND obj.object_type_from = 'PA_TASKS'
11469: AND obj.object_type_to = 'PA_DELIVERABLES'
11470: AND obj.relationship_type = 'A'

Line 11508: , pa_project_statuses status

11504: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
11505: IS
11506: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED','Y','N')
11507: FROM pa_proj_elem_ver_structure str
11508: , pa_project_statuses status
11509: where str.element_version_id = c_structure_version_id
11510: AND str.project_id = c_project_id
11511: AND str.status_code = status.project_status_code;
11512:

Line 11629: ,pa_project_statuses pps1

11625: , nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0)) bac_value
11626: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
11627: FROM
11628: pa_progress_rollup ppr
11629: ,pa_project_statuses pps1
11630: ,pa_project_statuses pps2
11631: ,pa_project_statuses pps3
11632: ,pa_project_statuses pps4
11633: ,pa_proj_elements ppe

Line 11630: ,pa_project_statuses pps2

11626: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
11627: FROM
11628: pa_progress_rollup ppr
11629: ,pa_project_statuses pps1
11630: ,pa_project_statuses pps2
11631: ,pa_project_statuses pps3
11632: ,pa_project_statuses pps4
11633: ,pa_proj_elements ppe
11634: WHERE

Line 11631: ,pa_project_statuses pps3

11627: FROM
11628: pa_progress_rollup ppr
11629: ,pa_project_statuses pps1
11630: ,pa_project_statuses pps2
11631: ,pa_project_statuses pps3
11632: ,pa_project_statuses pps4
11633: ,pa_proj_elements ppe
11634: WHERE
11635: ppr.project_id = c_sub_project_id

Line 11632: ,pa_project_statuses pps4

11628: pa_progress_rollup ppr
11629: ,pa_project_statuses pps1
11630: ,pa_project_statuses pps2
11631: ,pa_project_statuses pps3
11632: ,pa_project_statuses pps4
11633: ,pa_proj_elements ppe
11634: WHERE
11635: ppr.project_id = c_sub_project_id
11636: AND ppe.project_id = c_sub_project_id

Line 14441: from pa_project_statuses

14437:
14438: CURSOR cur_task_status( c_status_weight VARCHAR2 )
14439: IS
14440: select project_status_code
14441: from pa_project_statuses
14442: where project_status_weight = c_status_weight
14443: and status_type = 'TASK'
14444: and predefined_flag = 'Y';
14445:

Line 14547: pa_project_statuses pps1,

14543: ,'N' update_required
14544: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14545: FROM pa_proj_element_versions ppev,
14546: pa_progress_rollup ppr,
14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 14548: pa_project_statuses pps2,

14544: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
14545: FROM pa_proj_element_versions ppev,
14546: pa_progress_rollup ppr,
14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14552: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 14549: pa_project_statuses pps3 ,

14545: FROM pa_proj_element_versions ppev,
14546: pa_progress_rollup ppr,
14547: pa_project_statuses pps1,
14548: pa_project_statuses pps2,
14549: pa_project_statuses pps3 ,
14550: pa_proj_rollup_temp temp
14551: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14552: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
14553: temp.object_id = ppev.element_version_id

Line 14672: pa_project_statuses pps1,

14668: pa_proj_element_versions ppev1,
14669: pa_proj_element_versions ppev2,
14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,

Line 14673: pa_project_statuses pps2,

14669: pa_proj_element_versions ppev2,
14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp

Line 14674: pa_project_statuses pps3,

14670: pa_progress_rollup ppr,
14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 14675: pa_project_statuses pps4,

14671: pa_proj_elements ppe,
14672: pa_project_statuses pps1,
14673: pa_project_statuses pps2,
14674: pa_project_statuses pps3,
14675: pa_project_statuses pps4,
14676: pa_task_types ttype ,
14677: pa_proj_rollup_temp temp
14678: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14679: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 14914: pa_project_statuses pps4,

14910: pa_object_relationships pobj,
14911: pa_proj_element_versions ppev1,
14912: pa_proj_element_versions ppev2,
14913: pa_proj_elements ppe,
14914: pa_project_statuses pps4,
14915: pa_task_types ttype ,
14916: pa_proj_rollup_temp temp
14917: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
14918: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 15026: , pa_project_statuses pps2

15022: , pps3.project_status_weight base_weight --base prog status
15023: FROM pa_proj_elements elem
15024: , pa_object_relationships obj
15025: , pa_progress_rollup ppr
15026: , pa_project_statuses pps2
15027: , pa_project_statuses pps3
15028: WHERE obj.object_id_from2= c_task_proj_elem_id
15029: AND obj.object_type_from = 'PA_TASKS'
15030: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 15027: , pa_project_statuses pps3

15023: FROM pa_proj_elements elem
15024: , pa_object_relationships obj
15025: , pa_progress_rollup ppr
15026: , pa_project_statuses pps2
15027: , pa_project_statuses pps3
15028: WHERE obj.object_id_from2= c_task_proj_elem_id
15029: AND obj.object_type_from = 'PA_TASKS'
15030: AND obj.object_type_to = 'PA_DELIVERABLES'
15031: AND obj.relationship_type = 'A'

Line 15069: , pa_project_statuses status

15065: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
15066: IS
15067: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED','Y','N')
15068: FROM pa_proj_elem_ver_structure str
15069: , pa_project_statuses status
15070: where str.element_version_id = c_structure_version_id
15071: AND str.project_id = c_project_id
15072: AND str.status_code = status.project_status_code;
15073:

Line 15190: ,pa_project_statuses pps1

15186: , nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0)) bac_value
15187: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
15188: FROM
15189: pa_progress_rollup ppr
15190: ,pa_project_statuses pps1
15191: ,pa_project_statuses pps2
15192: ,pa_project_statuses pps3
15193: ,pa_project_statuses pps4
15194: ,pa_proj_elements ppe

Line 15191: ,pa_project_statuses pps2

15187: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
15188: FROM
15189: pa_progress_rollup ppr
15190: ,pa_project_statuses pps1
15191: ,pa_project_statuses pps2
15192: ,pa_project_statuses pps3
15193: ,pa_project_statuses pps4
15194: ,pa_proj_elements ppe
15195: WHERE

Line 15192: ,pa_project_statuses pps3

15188: FROM
15189: pa_progress_rollup ppr
15190: ,pa_project_statuses pps1
15191: ,pa_project_statuses pps2
15192: ,pa_project_statuses pps3
15193: ,pa_project_statuses pps4
15194: ,pa_proj_elements ppe
15195: WHERE
15196: 1 = 2 and --sridhar_rollup

Line 15193: ,pa_project_statuses pps4

15189: pa_progress_rollup ppr
15190: ,pa_project_statuses pps1
15191: ,pa_project_statuses pps2
15192: ,pa_project_statuses pps3
15193: ,pa_project_statuses pps4
15194: ,pa_proj_elements ppe
15195: WHERE
15196: 1 = 2 and --sridhar_rollup
15197: ppr.project_id = c_sub_project_id