DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_PROGRESS_ATTR

Line 1525: ,pa_proj_progress_attr pppa

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

Line 2340: ,pa_proj_progress_attr pppa

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

Line 3198: ,pa_proj_progress_attr pppa

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

Line 4169: ,pa_proj_progress_attr pppa

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

Line 4994: ,pa_proj_progress_attr pppa

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

Line 5820: ,pa_proj_progress_attr pppa

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

Line 6758: ,pa_proj_progress_attr pppa

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

Line 7248: ,pa_proj_progress_attr pppa

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

Line 8075: ,pa_proj_progress_attr pppa

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

Line 8835: ,pa_proj_progress_attr pppa

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

Line 8965: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

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;

Line 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

Line 8970: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

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

Line 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.

Line 11579: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

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;

Line 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

Line 11584: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';

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

Line 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