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 3705: FROM pa_proj_elements

3701: ,scheduled_delay --For Bug 3948128
3702: FROM PA_RESOURCE_ASSIGNMENTS pra,
3703: (SELECT TO_NUMBER(attribute15) source_task_id,
3704: proj_element_id target_task_id
3705: FROM pa_proj_elements
3706: WHERE project_id = l_target_project_id
3707: AND object_type = 'PA_TASKS'
3708: UNION ALL
3709: SELECT 0 source_task_id,

Line 3978: FROM pa_proj_elements

3974: ,scheduled_delay --For Bug 3948128
3975: FROM PA_RESOURCE_ASSIGNMENTS pra,
3976: (SELECT TO_NUMBER(attribute15) source_task_id,
3977: proj_element_id target_task_id
3978: FROM pa_proj_elements
3979: WHERE project_id = l_target_project_id
3980: AND object_type='PA_TASKS'
3981: UNION ALL
3982: SELECT 0 source_task_id,

Line 8781: ,pa_proj_elements spe

8777: SELECT selv.element_version_id
8778: ,telv.element_version_id
8779: FROM pa_proj_element_versions telv
8780: ,pa_proj_element_versions selv
8781: ,pa_proj_elements spe
8782: ,pa_proj_elements tpe
8783: WHERE spe.project_id=p_source_project_id
8784: AND tpe.project_id=p_target_project_id
8785: AND spe.element_number=tpe.element_number

Line 8782: ,pa_proj_elements tpe

8778: ,telv.element_version_id
8779: FROM pa_proj_element_versions telv
8780: ,pa_proj_element_versions selv
8781: ,pa_proj_elements spe
8782: ,pa_proj_elements tpe
8783: WHERE spe.project_id=p_source_project_id
8784: AND tpe.project_id=p_target_project_id
8785: AND spe.element_number=tpe.element_number
8786: AND tpe.object_type='PA_TASKS'