DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 992: FROM pa_proj_elem_ver_structure ppe

988: CURSOR l_struct_info_csr
989: IS
990: SELECT ppe.proj_element_id
991: ,ppe.element_version_id
992: FROM pa_proj_elem_ver_structure ppe
993: ,pa_proj_structure_types pst
994: ,pa_structure_types sty
995: WHERE ppe.project_id = p_project_id
996: AND ppe.proj_element_id = pst.proj_element_id

Line 1003: approach will be to retrieve the Structure Information from pa_proj_elem_ver_structure table

999: AND sty.structure_type_class_code = p_structure_type ;
1000:
1001: /* Commented following existing code for Performance Fix : Bug 3614361
1002: Instead of deriving structure information in the way mentioned in commented code,a better
1003: approach will be to retrieve the Structure Information from pa_proj_elem_ver_structure table
1004: as above */
1005:
1006: /*Select
1007: ppe.proj_element_id

Line 6092: PA_PROJ_ELEM_VER_STRUCTURE PPEVS

6088: CURSOR c_task_in_wp_version IS
6089: SELECT PPEVS.ELEMENT_VERSION_ID STRUCT_VER_ID
6090: ,PEV.ELEMENT_VERSION_ID TASK_VER_ID
6091: FROM
6092: PA_PROJ_ELEM_VER_STRUCTURE PPEVS
6093: ,PA_PROJ_ELEMENT_VERSIONS PEV
6094: WHERE PEV.PROJECT_ID = p_project_id
6095: AND PEV.PARENT_STRUCTURE_VERSION_ID = PPEVS.ELEMENT_VERSION_ID
6096: AND PEV.PROJ_ELEMENT_ID = p_task_id