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
1529: ,pa_proj_element_versions ppv
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
2344: ,pa_proj_element_versions ppv
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
3202: ,pa_proj_element_versions ppv
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
4173: ,pa_proj_element_versions ppv
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
4998: ,pa_proj_element_versions ppv
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
5824: ,pa_proj_element_versions ppv
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
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
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
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
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
8079: ,pa_proj_element_versions ppv
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
8839: ,pa_proj_element_versions ppv
8961: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8962: g1_debug_mode VARCHAR2(1) ;
8963:
8964: -- Bug Fix 5611760. Performance changes.
8965: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
8966: -- as it is not available in the pa_progress_rollup table thus causing the
8967: -- get_bcws function to get the same for every call.
8968:
8969: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
8965: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
8966: -- as it is not available in the pa_progress_rollup table thus causing the
8967: -- get_bcws function to get the same for every call.
8968:
8969: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
8970: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
8971:
8972: CURSOR c_task_weight_basis_code IS
8973: SELECT task_weight_basis_code
8966: -- as it is not available in the pa_progress_rollup table thus causing the
8967: -- get_bcws function to get the same for every call.
8968:
8969: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
8970: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
8971:
8972: CURSOR c_task_weight_basis_code IS
8973: SELECT task_weight_basis_code
8974: FROM pa_proj_progress_attr pppa
8970: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
8971:
8972: CURSOR c_task_weight_basis_code IS
8973: SELECT task_weight_basis_code
8974: FROM pa_proj_progress_attr pppa
8975: WHERE pppa.project_id = p_project_id
8976: AND pppa.structure_type = l_structure_type;
8977:
8978: -- End of Bug fix 5611760.
11575: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11576: g1_debug_mode VARCHAR2(1) ;
11577:
11578: -- Bug Fix 5611760. Performance changes.
11579: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11580: -- as it is not available in the pa_progress_rollup table thus causing the
11581: -- get_bcws function to get the same for every call.
11582:
11583: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11579: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11580: -- as it is not available in the pa_progress_rollup table thus causing the
11581: -- get_bcws function to get the same for every call.
11582:
11583: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11584: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11585:
11586: CURSOR c_task_weight_basis_code IS
11587: SELECT task_weight_basis_code
11580: -- as it is not available in the pa_progress_rollup table thus causing the
11581: -- get_bcws function to get the same for every call.
11582:
11583: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11584: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11585:
11586: CURSOR c_task_weight_basis_code IS
11587: SELECT task_weight_basis_code
11588: FROM pa_proj_progress_attr pppa
11584: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11585:
11586: CURSOR c_task_weight_basis_code IS
11587: SELECT task_weight_basis_code
11588: FROM pa_proj_progress_attr pppa
11589: WHERE pppa.project_id = p_project_id
11590: AND pppa.structure_type = l_structure_type;
11591:
11592: -- End of Bug Fix 5609629