APPS.PA_DELIVERABLE_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 3004: /*3614361 Included Delete from PA_PROJ_ELEM_VER_STRUCTURE */

3000: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
3001: WHERE proj_element_id = l_proj_element_id
3002: AND project_id = p_project_id ;/* Included project_id clause for Performance Bug Fix 3614361 */
3003:
3004: /*3614361 Included Delete from PA_PROJ_ELEM_VER_STRUCTURE */
3005: DELETE FROM PA_PROJ_ELEM_VER_STRUCTURE
3006: WHERE proj_element_id = l_proj_element_id
3007: AND project_id = p_project_id ;
3008:

Line 3005: DELETE FROM PA_PROJ_ELEM_VER_STRUCTURE

3001: WHERE proj_element_id = l_proj_element_id
3002: AND project_id = p_project_id ;/* Included project_id clause for Performance Bug Fix 3614361 */
3003:
3004: /*3614361 Included Delete from PA_PROJ_ELEM_VER_STRUCTURE */
3005: DELETE FROM PA_PROJ_ELEM_VER_STRUCTURE
3006: WHERE proj_element_id = l_proj_element_id
3007: AND project_id = p_project_id ;
3008:
3009: /* Moved the following code to top for Performance Bug Fix 3614361

Line 3788: FROM pa_proj_elem_ver_structure ppe

3784:
3785: CURSOR c_structure_id IS
3786: SELECT ppe.proj_element_id
3787: ,ppe.element_version_id
3788: FROM pa_proj_elem_ver_structure ppe
3789: ,pa_proj_structure_types pst
3790: ,pa_structure_types sty
3791: WHERE ppe.project_id = p_target_project_id
3792: AND ppe.proj_element_id = pst.proj_element_id

Line 4051: INSERT INTO PA_PROJ_ELEM_VER_STRUCTURE

4047: ,fnd_global.login_id
4048: ,1
4049: ) ;
4050:
4051: INSERT INTO PA_PROJ_ELEM_VER_STRUCTURE
4052: ( pev_structure_id
4053: ,element_version_id
4054: ,version_number
4055: ,name

Line 4071: pa_proj_elem_ver_structure_s.nextval

4067: ,pm_source_reference
4068: ,source_object_id
4069: ,source_object_type)
4070: SELECT
4071: pa_proj_elem_ver_structure_s.nextval
4072: ,l_parent_structure_version_id
4073: ,ppe.element_number
4074: ,l_name
4075: ,p_target_project_id

Line 4089: FROM pa_proj_elem_ver_structure ver

4085: ,ppe.pm_source_code
4086: ,ppe.pm_source_reference
4087: ,p_target_project_id
4088: ,'PA_PROJECTS'
4089: FROM pa_proj_elem_ver_structure ver
4090: ,pa_proj_elements ppe
4091: ,pa_proj_structure_types pst
4092: WHERE ver.project_id = p_source_project_id
4093: AND ppe.proj_element_id = ver.proj_element_id