DBA Data[Home] [Help]

APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on HZ_PARTIES

Line 221: hz_parties hp,

217: INTO l_total_spo,
218: l_total_bpa,
219: l_total_cpa
220: FROM po_vendors pv,
221: hz_parties hp,
222: po_headers poh
223: WHERE hp.party_id = p_tp_id
224: AND poh.vendor_id = pv.vendor_id
225: AND poh.authorization_status NOT IN

Line 322: hz_parties hp,

318: -- Fetch the total purchasing releases
319: SELECT COUNT(*) total_po_releases
320: INTO l_tot_po_rel
321: FROM po_vendors pv,
322: hz_parties hp,
323: po_releases_all por,
324: po_headers poh
325: WHERE hp.party_id = p_tp_id
326: AND poh.PO_HEADER_ID = por.PO_HEADER_ID