APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1477: * We are checking from pa_resource_assignments table.

1473:
1474: /********************************************
1475: * To Check if resource_list member is currently being
1476: * used in a planning transaction.
1477: * We are checking from pa_resource_assignments table.
1478: ************************************************/
1479: BEGIN
1480: /*********************************************************
1481: * Bug : 3485415

Line 1485: * found in either pa_resource_assignments

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'.
1488: **********************************************************/
1489: SELECT 'Y'

Line 1493: (SELECT 'Y' from pa_resource_assignments

1489: SELECT 'Y'
1490: INTO l_exist_res_list
1491: FROM DUAL
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 );