APPS.GHG_PO_EMISSIONS_PKG dependencies on RCV_TRANSACTIONS

Line 179: FROM rcv_transactions rt

175: ELSIF v_po_match_emission_date = 'RECEIPT' THEN
176:
177: SELECT MAX(rt.transaction_date)
178: INTO v_emission_date
179: FROM rcv_transactions rt
180: WHERE rt.po_header_id IN (SELECT ph.po_header_id
181: FROM po_headers_v ph
182: WHERE ph.segment1 = x_po_number)
183: AND rt.transaction_type = 'RECEIVE';

Line 207: FROM rcv_transactions rt

203: ELSIF v_receipt_match_emission_date = 'RECEIPT' THEN
204:
205: SELECT rt.transaction_date
206: INTO v_emission_date
207: FROM rcv_transactions rt
208: WHERE rt.transaction_id = dist_rec.rcv_transaction_id;
209:
210: ELSE
211: