eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 1483: * the Pa_project_assignments table as well before

1479: BEGIN
1480: /*********************************************************
1481: * Bug : 3485415
1482: * Description : Added the extra UNION condition to check from
1483: * the Pa_project_assignments table as well before
1484: * deleting. If the resource list member
1485: * found in either pa_resource_assignments
1486: * or pa_project_assignments we cannot delete
1487: * it. We will only set the enabled_flag = 'Y'.

Line 1486: * or pa_project_assignments we cannot delete

1482: * Description : Added the extra UNION condition to check from
1483: * the Pa_project_assignments table as well before
1484: * deleting. If the resource list member
1485: * found in either pa_resource_assignments
1486: * or pa_project_assignments we cannot delete
1487: * it. We will only set the enabled_flag = 'Y'.
1488: **********************************************************/
1489: SELECT 'Y'
1490: INTO l_exist_res_list

Line 1496: SELECT 'Y' from pa_project_assignments

1492: WHERE EXISTS
1493: (SELECT 'Y' from pa_resource_assignments
1494: WHERE resource_list_member_id = p_resource_list_member_id
1495: UNION
1496: SELECT 'Y' from pa_project_assignments
1497: WHERE resource_list_member_id = p_resource_list_member_id );
1498: EXCEPTION
1499: WHEN NO_DATA_FOUND THEN
1500: l_exist_res_list := 'N';