APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on WIP_OPERATIONS

Line 482: (SELECT 1 FROM WIP_OPERATIONS wo,

478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: /* bug 9186572 - added WIP_DISCRETE_JOBS to check for the status of job also */
481: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
482: (SELECT 1 FROM WIP_OPERATIONS wo,
483: WIP_OPERATION_RESOURCES wor,
484: WIP_DISCRETE_JOBS wdj
485: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID
486: AND wdj.WIP_ENTITY_ID = wo.WIP_ENTITY_ID