DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_PROJ_PROGRESS_ATTR

Line 1526: ,pa_proj_progress_attr pppa

1522: ,pa_proj_elements ppe5
1523: ,pa_proj_element_versions ppv5
1524: ,pa_proj_workplan_attr ppwa
1525: ,pa_proj_element_versions ppev6
1526: ,pa_proj_progress_attr pppa
1527: ,pa_proj_element_versions ppv2
1528: ,pa_tasks pt
1529: ,pa_proj_elements ppe
1530: ,pa_proj_element_versions ppv

Line 2103: ,pa_proj_progress_attr pppa

2099: ,pa_proj_elements ppe5
2100: ,pa_proj_element_versions ppv5
2101: ,pa_proj_workplan_attr ppwa
2102: ,pa_proj_element_versions ppev6
2103: ,pa_proj_progress_attr pppa
2104: ,pa_proj_element_versions ppv2
2105: ,pa_tasks pt
2106: ,pa_proj_elements ppe
2107: ,pa_proj_element_versions ppv

Line 2925: ,pa_proj_progress_attr pppa

2921: ,pa_proj_elements ppe5
2922: ,pa_proj_element_versions ppv5
2923: ,pa_proj_workplan_attr ppwa
2924: ,pa_proj_element_versions ppev6
2925: ,pa_proj_progress_attr pppa
2926: ,pa_proj_element_versions ppv2
2927: ,pa_tasks pt
2928: ,pa_proj_elements ppe
2929: ,pa_proj_element_versions ppv

Line 3505: ,pa_proj_progress_attr pppa

3501: ,pa_proj_elements ppe5
3502: ,pa_proj_element_versions ppv5
3503: ,pa_proj_workplan_attr ppwa
3504: ,pa_proj_element_versions ppev6
3505: ,pa_proj_progress_attr pppa
3506: ,pa_proj_element_versions ppv2
3507: ,pa_tasks pt
3508: ,pa_proj_elements ppe
3509: ,pa_proj_element_versions ppv

Line 4375: ,pa_proj_progress_attr pppa

4371: ,pa_proj_elements ppe5
4372: ,pa_proj_element_versions ppv5
4373: ,pa_proj_workplan_attr ppwa
4374: ,pa_proj_element_versions ppev6
4375: ,pa_proj_progress_attr pppa
4376: ,pa_proj_element_versions ppv2
4377: ,pa_tasks pt
4378: ,pa_proj_elements ppe
4379: ,pa_proj_element_versions ppv

Line 4950: ,pa_proj_progress_attr pppa

4946: ,pa_proj_elements ppe5
4947: ,pa_proj_element_versions ppv5
4948: ,pa_proj_workplan_attr ppwa
4949: ,pa_proj_element_versions ppev6
4950: ,pa_proj_progress_attr pppa
4951: ,pa_proj_element_versions ppv2
4952: ,pa_tasks pt
4953: ,pa_proj_elements ppe
4954: ,pa_proj_element_versions ppv

Line 5981: ,pa_proj_progress_attr pppa

5977: ,pa_proj_elements ppe5
5978: ,pa_proj_element_versions ppv5
5979: ,pa_proj_workplan_attr ppwa
5980: ,pa_proj_element_versions ppev6
5981: ,pa_proj_progress_attr pppa
5982: ,pa_proj_element_versions ppv2
5983: ,pa_tasks pt
5984: ,pa_proj_elements ppe
5985: ,pa_proj_element_versions ppv

Line 6807: ,pa_proj_progress_attr pppa

6803: ,pa_proj_elements ppe5
6804: ,pa_proj_element_versions ppv5
6805: ,pa_proj_workplan_attr ppwa
6806: ,pa_proj_element_versions ppev6
6807: ,pa_proj_progress_attr pppa
6808: ,pa_proj_element_versions ppv2
6809: ,pa_tasks pt
6810: ,pa_proj_elements ppe
6811: ,pa_proj_element_versions ppv

Line 7634: ,pa_proj_progress_attr pppa

7630: ,pa_proj_elements ppe5
7631: ,pa_proj_element_versions ppv5
7632: ,pa_proj_workplan_attr ppwa
7633: ,pa_proj_element_versions ppev6
7634: ,pa_proj_progress_attr pppa
7635: ,pa_proj_element_versions ppv2
7636: ,pa_tasks pt
7637: ,pa_proj_elements ppe
7638: ,pa_proj_element_versions ppv

Line 8573: ,pa_proj_progress_attr pppa

8569: ,pa_object_relationships por2
8570: ,pji_fm_xbs_accum_tmp1 pfxat
8571: ----,pa_percent_completes ppc
8572: ,pa_progress_rollup ppru
8573: ,pa_proj_progress_attr pppa
8574: where
8575: por.object_id_from1 in ( SELECT ppevs.element_version_id
8576: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
8577: WHERE ppes.project_id = ppevs.project_id

Line 9064: ,pa_proj_progress_attr pppa

9060: ,pa_object_relationships por2
9061: ,pji_fm_xbs_accum_tmp1 pfxat
9062: ----,pa_percent_completes ppc
9063: ,pa_progress_rollup ppru
9064: ,pa_proj_progress_attr pppa
9065: where
9066: por.object_id_from1 in ( SELECT ppevs.element_version_id
9067: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
9068: WHERE ppes.project_id = ppevs.project_id

Line 9572: ,pa_proj_progress_attr pppa

9568: ,pa_object_relationships por2
9569: ,pji_fm_xbs_accum_tmp1 pfxat
9570: ----,pa_percent_completes ppc
9571: ,pa_progress_rollup ppru
9572: ,pa_proj_progress_attr pppa
9573: where
9574: por.object_id_from1 in ( SELECT ppevs.element_version_id
9575: FROM pa_proj_elements ppes, pa_proj_element_versions ppevs
9576: WHERE ppes.project_id = ppevs.project_id

Line 10405: ,pa_proj_progress_attr pppa

10401: ,pa_proj_elements ppe5
10402: ,pa_proj_element_versions ppv5
10403: ,pa_proj_workplan_attr ppwa
10404: ,pa_proj_element_versions ppev6
10405: ,pa_proj_progress_attr pppa
10406: ,pa_proj_element_versions ppv2
10407: ,pa_tasks pt
10408: ,pa_proj_elements ppe
10409: ,pa_proj_element_versions ppv

Line 11165: ,pa_proj_progress_attr pppa

11161: ,pa_proj_elements ppe5
11162: ,pa_proj_element_versions ppv5
11163: ,pa_proj_workplan_attr ppwa
11164: ,pa_proj_element_versions ppev6
11165: ,pa_proj_progress_attr pppa
11166: ,pa_proj_element_versions ppv2
11167: ,pa_tasks pt
11168: ,pa_proj_elements ppe
11169: ,pa_proj_element_versions ppv

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

11291: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11292: g1_debug_mode VARCHAR2(1) ;
11293:
11294: -- Bug Fix 5611760. Performance changes.
11295: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11296: -- as it is not available in the pa_progress_rollup table thus causing the
11297: -- get_bcws function to get the same for every call.
11298:
11299: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

Line 11299: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

11295: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
11296: -- as it is not available in the pa_progress_rollup table thus causing the
11297: -- get_bcws function to get the same for every call.
11298:
11299: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11300: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11301:
11302: CURSOR c_task_weight_basis_code IS
11303: SELECT task_weight_basis_code

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

11296: -- as it is not available in the pa_progress_rollup table thus causing the
11297: -- get_bcws function to get the same for every call.
11298:
11299: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
11300: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11301:
11302: CURSOR c_task_weight_basis_code IS
11303: SELECT task_weight_basis_code
11304: FROM pa_proj_progress_attr pppa

Line 11304: FROM pa_proj_progress_attr pppa

11300: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
11301:
11302: CURSOR c_task_weight_basis_code IS
11303: SELECT task_weight_basis_code
11304: FROM pa_proj_progress_attr pppa
11305: WHERE pppa.project_id = p_project_id
11306: AND pppa.structure_type = l_structure_type;
11307:
11308: -- End of Bug fix 5611760.

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

13908: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
13909: g1_debug_mode VARCHAR2(1) ;
13910:
13911: -- Bug Fix 5611760. Performance changes.
13912: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
13913: -- as it is not available in the pa_progress_rollup table thus causing the
13914: -- get_bcws function to get the same for every call.
13915:
13916: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

Line 13916: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;

13912: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table
13913: -- as it is not available in the pa_progress_rollup table thus causing the
13914: -- get_bcws function to get the same for every call.
13915:
13916: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
13917: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
13918:
13919: CURSOR c_task_weight_basis_code IS
13920: SELECT task_weight_basis_code

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

13913: -- as it is not available in the pa_progress_rollup table thus causing the
13914: -- get_bcws function to get the same for every call.
13915:
13916: l_task_weight_basis_code pa_proj_progress_attr.task_weight_basis_code%TYPE;
13917: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
13918:
13919: CURSOR c_task_weight_basis_code IS
13920: SELECT task_weight_basis_code
13921: FROM pa_proj_progress_attr pppa

Line 13921: FROM pa_proj_progress_attr pppa

13917: l_structure_type pa_proj_progress_attr.structure_type%TYPE := 'WORKPLAN';
13918:
13919: CURSOR c_task_weight_basis_code IS
13920: SELECT task_weight_basis_code
13921: FROM pa_proj_progress_attr pppa
13922: WHERE pppa.project_id = p_project_id
13923: AND pppa.structure_type = l_structure_type;
13924:
13925: -- End of Bug Fix 5609629