APPS.PA_PLANNING_RESOURCE_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1369: * We are checking from pa_resource_assignments table.

1365:
1366: /********************************************
1367: * To Check if resource_list member is currently being
1368: * used in a planning transaction.
1369: * We are checking from pa_resource_assignments table.
1370: ************************************************/
1371: BEGIN
1372: /*********************************************************
1373: * Bug : 3485415

Line 1377: * found in either pa_resource_assignments

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'.
1380: **********************************************************/
1381: SELECT 'Y'

Line 1385: (SELECT 'Y' from pa_resource_assignments

1381: SELECT 'Y'
1382: INTO l_exist_res_list
1383: FROM DUAL
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 );