APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 923: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1

919:
920: CURSOR l_op_network(l_wip_entity_id NUMBER) IS
921: SELECT
922: won.prior_operation,won.next_operation,wo.last_unit_completion_date,wo1.first_unit_start_date
923: FROM wip_operation_networks won,wip_operations wo,wip_operations wo1
924: WHERE won.wip_entity_id = wo.wip_entity_id AND
925: won.wip_entity_id = wo1.wip_entity_id AND
926: won.prior_operation = wo.operation_seq_num AND
927: won.next_operation = wo1.operation_seq_num AND

Line 971: FROM wip_operations

967: --1.Is Op Completed
968:
969: SELECT nvl(operation_completed, 'N')
970: INTO l_op_completed
971: FROM wip_operations
972: WHERE wip_entity_id = p_wip_entity_id
973: AND operation_seq_num = p_op_seq_num;
974:
975: IF l_op_completed = 'Y' THEN