APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on PO_VENDORS

Line 400: FROM po_vendors

396: l_contact_rec get_contact_info%ROWTYPE;
397: --
398: CURSOR get_supplier_name (p_vendor_id NUMBER) IS
399: SELECT vendor_name
400: FROM po_vendors
401: WHERE vendor_id = p_vendor_id;
402: --
403: l_supplier_name varchar2(360);
404: l_return_status VARCHAR2(2);

Line 1522: FROM po_vendors

1518: --
1519: CURSOR check_vendor_active (p_vendor_id NUMBER) IS
1520: SELECT end_date_active,
1521: vendor_name
1522: FROM po_vendors
1523: WHERE vendor_id = p_vendor_id;
1524: --
1525: l_end_date_active DATE;
1526: l_supplier_name VARCHAR2(360);

Line 2762: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes

2758: --
2759: l_fromPartyId NUMBER;
2760: l_toPartyId NUMBER;
2761: --
2762: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes
2763: -- that AP makes to their data model
2764: CURSOR c_getParty(p_vendorId IN NUMBER) IS
2765: SELECT party_id
2766: FROM po_vendors

Line 2766: FROM po_vendors

2762: -- Bug 4658824 : Use po_vendors, so we are isolated from any changes
2763: -- that AP makes to their data model
2764: CURSOR c_getParty(p_vendorId IN NUMBER) IS
2765: SELECT party_id
2766: FROM po_vendors
2767: WHERE vendor_id = p_vendorId;
2768:
2769: RTV_Exception exception;
2770: l_rec_exists varchar2(1);

Line 3374: FROM po_vendors pov,

3370: IS
3371:
3372: CURSOR get_loc_for_site ( c_vendor_id NUMBER, c_vendor_site NUMBER) IS
3373: SELECT pvs.location_id, hzp.party_site_use_id
3374: FROM po_vendors pov,
3375: po_vendor_sites pvs,
3376: hz_locations hz,
3377: hz_party_site_uses hzp
3378: WHERE pov.vendor_id = pvs.vendor_id