APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on WIP_OPERATION_RESOURCES

Line 482: WIP_OPERATION_RESOURCES wor

478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
481: (SELECT 1 FROM WIP_OPERATIONS wo,
482: WIP_OPERATION_RESOURCES wor
483: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID
484: AND wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
485: AND wo.ORGANIZATION_ID = wor.ORGANIZATION_ID
486: AND nvl(wo.REPETITIVE_SCHEDULE_ID, -1) = nvl(wor.REPETITIVE_SCHEDULE_ID, -1)