APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 1375: * the Pa_project_assignments table as well before

1371: BEGIN
1372: /*********************************************************
1373: * Bug : 3485415
1374: * Description : Added the extra UNION condition to check from
1375: * the Pa_project_assignments table as well before
1376: * deleting. If the resource list member
1377: * found in either pa_resource_assignments
1378: * or pa_project_assignments we cannot delete
1379: * it. We will only set the enabled_flag = 'Y'.

Line 1378: * or pa_project_assignments we cannot delete

1374: * Description : Added the extra UNION condition to check from
1375: * the Pa_project_assignments table as well before
1376: * deleting. If the resource list member
1377: * found in either pa_resource_assignments
1378: * or pa_project_assignments we cannot delete
1379: * it. We will only set the enabled_flag = 'Y'.
1380: **********************************************************/
1381: SELECT 'Y'
1382: INTO l_exist_res_list

Line 1388: SELECT 'Y' from pa_project_assignments

1384: WHERE EXISTS
1385: (SELECT 'Y' from pa_resource_assignments
1386: WHERE resource_list_member_id = p_resource_list_member_id
1387: UNION
1388: SELECT 'Y' from pa_project_assignments
1389: WHERE resource_list_member_id = p_resource_list_member_id );
1390: EXCEPTION
1391: WHEN NO_DATA_FOUND THEN
1392: l_exist_res_list := 'N';