APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on BOM_OPERATION_RESOURCES

Line 473: (SELECT 1 FROM BOM_OPERATION_RESOURCES bor,

469: AND bsor.RESOURCE_ID = X_Resource_Id);
470:
471: message_name := 'BOM_CANNOT_DELETE_RES_ROUTING';
472: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
473: (SELECT 1 FROM BOM_OPERATION_RESOURCES bor,
474: BOM_OPERATION_SEQUENCES bos
475: WHERE bor.OPERATION_SEQUENCE_ID = bos.OPERATION_SEQUENCE_ID
476: AND bor.RESOURCE_ID = X_Resource_Id
477: AND bos.DEPARTMENT_ID = X_Department_Id);