APPS.WSMPLBMI dependencies on WSM_SERIAL_TXN_INTERFACE

Line 11005: -- DELETE wsm_serial_txn_interface

11001:
11002: -- ST : Serial Support Project --
11003: -- User inserted records...
11004:
11005: -- DELETE wsm_serial_txn_interface
11006: -- WHERE header_id in (SELECT header_id
11007: -- from wsm_lot_move_txn_interface wlmti
11008: -- WHERE group_id = l_wmti_group_id
11009: -- and status = WIP_CONSTANTS.COMPLETED

Line 11017: -- DELETE wsm_serial_txn_interface

11013: -- AND action_flag in (1,2,3,4,5,6)
11014: -- and transaction_type_id = 2;
11015: --
11016: -- -- Delete the inserted records for Attributes...
11017: -- DELETE wsm_serial_txn_interface
11018: -- WHERE header_id IN (Select wmt.transaction_id
11019: -- from wip_move_transactions wmt,
11020: -- wsm_lot_move_txn_interface wlmti
11021: -- where wlmti.group_id = l_wmti_group_id

Line 11037: DELETE wsm_serial_txn_interface

11033: -- ST : Serial Support Project --
11034: -- User inserted records...
11035: IF l_header_id_tbl.count > 0 THEN
11036: forall l_index in l_header_id_tbl.first..l_header_id_tbl.last
11037: DELETE wsm_serial_txn_interface
11038: WHERE header_id = l_header_id_tbl(l_index)
11039: AND transaction_type_id = 2;
11040: END IF;
11041: -- ST : Serial Support Project --