APPS.RCV_FTE_CALL_PVT dependencies on RCV_TRANSACTIONS

Line 67: FROM rcv_transactions

63: IF (p_interface_id IS NOT NULL AND l_rcv_txn <> 'CANCEL')
64: THEN
65: SELECT transaction_id
66: INTO l_txn_id
67: FROM rcv_transactions
68: WHERE shipment_header_id = p_shipment_header_id
69: AND transaction_type = l_rcv_txn
70: AND interface_transaction_id = p_interface_id
71: AND rownum = 1;

Line 77: FROM rcv_transactions parent, rcv_transactions child

73:
74: IF (p_action = 'CORRECT') THEN
75: SELECT parent.transaction_type
76: INTO l_txn_type
77: FROM rcv_transactions parent, rcv_transactions child
78: WHERE child.transaction_id = l_txn_id
79: AND parent.transaction_id = child.parent_transaction_id;
80:
81: IF (l_txn_type = 'RECEIVE') THEN