APPS.PON_VENDORMERGE_GRP dependencies on PO_VENDORS

Line 473: FROM po_vendors pv, po_vendor_sites_all pvs

469: BEGIN --{
470: -- select the vendor information for the site we're merging to
471: SELECT pv.vendor_name, pvs.vendor_site_code
472: INTO x_trading_partner_name, x_vendor_site_code
473: FROM po_vendors pv, po_vendor_sites_all pvs
474: WHERE pv.vendor_id = p_vendor_id
475: AND pv.vendor_id = pvs.vendor_id
476: AND pvs.vendor_site_id = p_vendor_site_id;
477:

Line 568: FROM po_vendors pv, po_vendor_sites_all pvs

564: -- in list.
565:
566: SELECT pvs.vendor_site_code
567: INTO l_dup_vendor_site_code
568: FROM po_vendors pv, po_vendor_sites_all pvs
569: WHERE pv.vendor_id = p_dup_vendor_id
570: AND pv.vendor_id = pvs.vendor_id
571: AND pvs.vendor_site_id = p_dup_vendor_site_id;
572:

Line 734: FROM po_vendors pv, po_vendor_sites_all pvs

730: -- in list.
731:
732: SELECT pvs.vendor_site_code
733: INTO l_dup_vendor_site_code
734: FROM po_vendors pv, po_vendor_sites_all pvs
735: WHERE pv.vendor_id = p_dup_vendor_id
736: AND pv.vendor_id = pvs.vendor_id
737: AND pvs.vendor_site_id = p_dup_vendor_site_id;
738:

Line 921: FROM po_vendors pv, po_vendor_sites_all pvs

917: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bid_headers');
918:
919: SELECT pvs.vendor_site_code
920: INTO l_dup_vendor_site_code
921: FROM po_vendors pv, po_vendor_sites_all pvs
922: WHERE pv.vendor_id = p_dup_vendor_id
923: AND pv.vendor_id = pvs.vendor_id
924: AND pvs.vendor_site_id = p_dup_vendor_site_id;
925: