APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 920: FROM pa_resource_list_assignments

916: AND use_code = NVL(Tmp_Bud_Type_Code,use_code);
917:
918: CURSOR new_resource_list (l_project_id NUMBER) IS
919: SELECT DISTINCT resource_list_id
920: FROM pa_resource_list_assignments
921: WHERE project_id = l_project_id
922: AND NVL(resource_list_accumulated_flag,'N') = 'N';
923:
924: /* Added for bug 1751445 Cause Performance */

Line 1111: FROM pa_resource_list_assignments rla

1107: BETWEEN l_project_num_from AND l_project_num_to
1108: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1109: AND PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(proj.project_id) = 'N' --bug#16461684
1110: AND EXISTS (SELECT 'x'
1111: FROM pa_resource_list_assignments rla
1112: WHERE rla.project_id = proj.project_id
1113: AND NVL(rla.resource_list_accumulated_flag,
1114: 'N') = 'N')
1115: /* UNION ALL