APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1238: FROM pa_proj_elem_ver_structure str

1234:
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;

Line 1321: ,pa_proj_elem_ver_structure ppevs2

1317: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
1318: 'WORKPLAN','N') sub_project_bac_value
1319: FROM
1320: pa_proj_element_versions ppv2
1321: ,pa_proj_elem_ver_structure ppevs2
1322: ,pa_object_relationships por1
1323: ,pa_object_relationships por2
1324: WHERE
1325: por1.object_id_from1 = c_task_version_id

Line 4411: ,pa_proj_elem_ver_structure ppevs1

4407: ,ppv1.element_version_id PARENT_TASK_VERSION_ID
4408: ,ppv1.proj_element_id PARENT_TASK_ID
4409: FROM
4410: pa_proj_element_versions ppv1
4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1
4415: ,pa_object_relationships por2

Line 4413: ,pa_proj_elem_ver_structure ppevs2

4409: FROM
4410: pa_proj_element_versions ppv1
4411: ,pa_proj_elem_ver_structure ppevs1
4412: ,pa_proj_element_versions ppv2
4413: ,pa_proj_elem_ver_structure ppevs2
4414: ,pa_object_relationships por1
4415: ,pa_object_relationships por2
4416: WHERE
4417: ppv2.element_version_id = por1.object_id_to1

Line 6761: ,pa_proj_elem_ver_structure ppevs2

6757: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
6758: 'WORKPLAN','N') sub_project_bac_value
6759: FROM
6760: pa_proj_element_versions ppv2
6761: ,pa_proj_elem_ver_structure ppevs2
6762: ,pa_object_relationships por1
6763: ,pa_object_relationships por2
6764: WHERE
6765: por1.object_id_from1 = c_task_version_id

Line 10262: pa_proj_elem_ver_structure b,

10258: , a.element_version_id
10259: , a.prg_level
10260: , ppr.as_of_date
10261: FROM pa_proj_element_versions a,
10262: pa_proj_elem_ver_structure b,
10263: pa_proj_structure_types ppst,
10264: pa_proj_element_versions c,
10265: pa_progress_rollup ppr
10266: WHERE

Line 10294: pa_proj_elem_ver_structure b,

10290: , a.element_version_id
10291: , a.prg_level
10292: , ppr.as_of_date
10293: FROM pa_proj_element_versions a,
10294: pa_proj_elem_ver_structure b,
10295: pa_proj_structure_types ppst,
10296: pa_proj_element_versions c,
10297: pa_progress_rollup ppr
10298: WHERE

Line 10459: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst

10455: x_msg_data OUT NOCOPY VARCHAR2) IS
10456:
10457: cursor new_str_version_id is
10458: select ppevs.element_version_id
10459: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst
10460: where ppevs.project_id = p_project_id
10461: and ppevs.proj_element_id = ppst.proj_element_id
10462: and ppst.structure_type_id = 1
10463: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'

Line 10465: from pa_proj_elem_ver_structure ppevs,

10461: and ppevs.proj_element_id = ppst.proj_element_id
10462: and ppst.structure_type_id = 1
10463: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10464: and ppevs.PUBLISHED_DATE = (select min(ppevs.published_date)
10465: from pa_proj_elem_ver_structure ppevs,
10466: pa_proj_structure_types ppst
10467: where ppevs.project_id = p_project_id
10468: and ppevs.proj_element_id = ppst.proj_element_id
10469: and ppst.structure_type_id = 1

Line 10472: from pa_proj_elem_ver_structure

10468: and ppevs.proj_element_id = ppst.proj_element_id
10469: and ppst.structure_type_id = 1
10470: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10471: and ppevs.published_date > (select published_date
10472: from pa_proj_elem_ver_structure
10473: where project_id = p_project_id
10474: and element_version_id = p_str_ver_id_to_del));
10475:
10476: l_str_ver_id number;

Line 11507: FROM pa_proj_elem_ver_structure str

11503:
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;

Line 11590: ,pa_proj_elem_ver_structure ppevs2

11586: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
11587: 'WORKPLAN','N') sub_project_bac_value
11588: FROM
11589: pa_proj_element_versions ppv2
11590: ,pa_proj_elem_ver_structure ppevs2
11591: ,pa_object_relationships por1
11592: ,pa_object_relationships por2
11593: WHERE
11594: por1.object_id_from1 = c_task_version_id

Line 15068: FROM pa_proj_elem_ver_structure str

15064:
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;

Line 15151: ,pa_proj_elem_ver_structure ppevs2

15147: , pa_progress_utils.Get_BAC_Value(ppv2.project_id, c_task_per_comp_deriv_method, ppv2.proj_element_id, ppv2.parent_structure_version_id,
15148: 'WORKPLAN','N') sub_project_bac_value
15149: FROM
15150: pa_proj_element_versions ppv2
15151: ,pa_proj_elem_ver_structure ppevs2
15152: ,pa_object_relationships por1
15153: ,pa_object_relationships por2
15154: WHERE
15155: por1.object_id_from1 = c_task_version_id