APPS.PA_FP_COPY_FROM_PKG dependencies on PA_PROJ_ELEMENTS

Line 1921: l_targ_proj_element_id pa_proj_elements.proj_element_id%TYPE;

1917: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1918: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1919: IS
1920: i NUMBER;
1921: l_targ_proj_element_id pa_proj_elements.proj_element_id%TYPE;
1922: --Start of variables used for debugging
1923: l_return_status VARCHAR2(1);
1924: l_msg_count NUMBER := 0;
1925: l_msg_data VARCHAR2(2000);

Line 3715: FROM pa_proj_elements

3711: ,pra.CBS_ELEMENT_ID -- bug#16200605
3712: FROM PA_RESOURCE_ASSIGNMENTS pra,
3713: (SELECT TO_NUMBER(attribute15) source_task_id,
3714: proj_element_id target_task_id
3715: FROM pa_proj_elements
3716: WHERE project_id = l_target_project_id
3717: AND object_type = 'PA_TASKS'
3718: UNION ALL
3719: SELECT 0 source_task_id,

Line 3990: FROM pa_proj_elements

3986: ,pra.CBS_ELEMENT_ID -- bug#16200605
3987: FROM PA_RESOURCE_ASSIGNMENTS pra,
3988: (SELECT TO_NUMBER(attribute15) source_task_id,
3989: proj_element_id target_task_id
3990: FROM pa_proj_elements
3991: WHERE project_id = l_target_project_id
3992: AND object_type='PA_TASKS'
3993: UNION ALL
3994: SELECT 0 source_task_id,

Line 8808: ,pa_proj_elements spe

8804: SELECT selv.element_version_id
8805: ,telv.element_version_id
8806: FROM pa_proj_element_versions telv
8807: ,pa_proj_element_versions selv
8808: ,pa_proj_elements spe
8809: ,pa_proj_elements tpe
8810: WHERE spe.project_id=p_source_project_id
8811: AND tpe.project_id=p_target_project_id
8812: AND spe.element_number=tpe.element_number

Line 8809: ,pa_proj_elements tpe

8805: ,telv.element_version_id
8806: FROM pa_proj_element_versions telv
8807: ,pa_proj_element_versions selv
8808: ,pa_proj_elements spe
8809: ,pa_proj_elements tpe
8810: WHERE spe.project_id=p_source_project_id
8811: AND tpe.project_id=p_target_project_id
8812: AND spe.element_number=tpe.element_number
8813: AND tpe.object_type='PA_TASKS'