APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_RESOURCE_LIST_ASSIGNMENTS

Line 890: FROM pa_resource_list_assignments

886: AND use_code = NVL(Tmp_Bud_Type_Code,use_code);
887:
888: CURSOR new_resource_list (l_project_id NUMBER) IS
889: SELECT DISTINCT resource_list_id
890: FROM pa_resource_list_assignments
891: WHERE project_id = l_project_id
892: AND NVL(resource_list_accumulated_flag,'N') = 'N';
893:
894: /* Added for bug 1751445 Cause Performance */

Line 1076: FROM pa_resource_list_assignments rla

1072: WHERE proj.segment1
1073: BETWEEN l_project_num_from AND l_project_num_to
1074: AND proj.project_type = NVL(x_project_type, project_type) --for bug 2543021
1075: AND EXISTS (SELECT 'x'
1076: FROM pa_resource_list_assignments rla
1077: WHERE rla.project_id = proj.project_id
1078: AND NVL(rla.resource_list_accumulated_flag,
1079: 'N') = 'N')
1080: /* UNION ALL