APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on BOM_RESOURCE_SHIFTS

Line 451: (SELECT 1 FROM BOM_RESOURCE_SHIFTS

447:
448: err_code := 1;
449: message_name := 'BOM_CANNOT_DELETE_RESOURCE';
450: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
451: (SELECT 1 FROM BOM_RESOURCE_SHIFTS
452: WHERE DEPARTMENT_ID = X_Department_Id
453: AND RESOURCE_ID = X_Resource_Id);
454:
455: err_code := 2;