APPS.PA_TASK_PVT1 dependencies on PA_PROJ_STRUCTURE_TYPES

Line 265: FROM pa_proj_structure_types ppst

261:
262: CURSOR cur_struc_type
263: IS
264: SELECT 'Y'
265: FROM pa_proj_structure_types ppst
266: ,pa_structure_types pst
267: WHERE ppst.proj_element_id = p_structure_id
268: AND ppst.structure_type_id = pst.structure_type_id
269: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 1778: FROM pa_proj_structure_types ppst

1774:
1775: CURSOR cur_struc_type( c_structure_id NUMBER )
1776: IS
1777: SELECT 'Y'
1778: FROM pa_proj_structure_types ppst
1779: ,pa_structure_types pst
1780: WHERE ppst.proj_element_id = c_structure_id
1781: AND ppst.structure_type_id = pst.structure_type_id
1782: AND pst.structure_type_class_code IN( 'FINANCIAL' );

Line 8775: FROM pa_proj_workplan_attr a, pa_proj_structure_types b

8771: THEN
8772:
8773: SELECT a.wp_enable_version_flag
8774: INTO l_workplan_version_enable_flag
8775: FROM pa_proj_workplan_attr a, pa_proj_structure_types b
8776: WHERE a.proj_element_id = b.proj_element_id
8777: AND a.project_id = cur_proj_elem_ver_sch_rec.project_id
8778: AND structure_type_id = 1;
8779:

Line 8792: FROM pa_proj_element_versions pev, pa_proj_structure_types pst

8788: IF PA_PROJECT_PUB.G_MASS_UPDATE_TASKS = 'Y' THEN
8789: IF PA_PROJECT_PUB.G_STRUC_ELEMENT_ID IS NULL THEN
8790: SELECT pev.proj_element_id
8791: INTO l_proj_element_id_temp
8792: FROM pa_proj_element_versions pev, pa_proj_structure_types pst
8793: WHERE pev.proj_element_id = pst.proj_element_id
8794: AND pst.structure_type_id = 1
8795: AND pev.project_id = cur_proj_elem_ver_sch_rec.project_id;
8796:

Line 8805: FROM pa_proj_element_versions pev, pa_proj_structure_types pst

8801: ELSE
8802: /* Commented and added below caching logic for huawei
8803: SELECT pev.proj_element_id
8804: INTO l_proj_element_id_temp
8805: FROM pa_proj_element_versions pev, pa_proj_structure_types pst
8806: WHERE pev.proj_element_id = pst.proj_element_id
8807: AND pst.structure_type_id = 1
8808: AND pev.project_id = cur_proj_elem_ver_sch_rec.project_id;
8809: */

Line 8815: FROM pa_proj_element_versions pev, pa_proj_structure_types pst

8811: PA_PROGRESS_PUB.G_PROJECT_ID <> cur_proj_elem_ver_sch_rec.project_id
8812: THEN
8813: SELECT pev.proj_element_id
8814: INTO l_proj_element_id_temp
8815: FROM pa_proj_element_versions pev, pa_proj_structure_types pst
8816: WHERE pev.proj_element_id = pst.proj_element_id
8817: AND pst.structure_type_id = 1
8818: AND pev.project_id = cur_proj_elem_ver_sch_rec.project_id;
8819:

Line 8825: FROM pa_proj_element_versions pev, pa_proj_structure_types pst

8821: ELSE
8822: IF PA_PROGRESS_PUB.G_STRUC_ELEMENT_ID IS NULL OR PA_PROGRESS_PUB.G_STRUC_ELEMENT_ID=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
8823: SELECT pev.proj_element_id
8824: INTO l_proj_element_id_temp
8825: FROM pa_proj_element_versions pev, pa_proj_structure_types pst
8826: WHERE pev.proj_element_id = pst.proj_element_id
8827: AND pst.structure_type_id = 1
8828: AND pev.project_id = cur_proj_elem_ver_sch_rec.project_id;
8829: PA_PROGRESS_PUB.G_STRUC_ELEMENT_ID := l_proj_element_id_temp;