APPS.GHG_PO_EMISSIONS_PKG dependencies on PO_HEADERS_V
Line 181: FROM po_headers_v ph
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';
184:
185: IF v_emission_date IS NULL THEN