DBA Data[Home] [Help]

APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on AP_SUPPLIER_SITES_ALL

Line 568: FROM ap_supplier_sites_all

564: AND (((payee.org_type IS NULL) AND (cp_org_type IS NULL)) OR (payee.org_type = cp_org_type));
565:
566: CURSOR cur_get_to_party_site_id(cp_vendor_site_id IN NUMBER) IS
567: SELECT party_site_id
568: FROM ap_supplier_sites_all
569: WHERE vendor_site_id = cp_vendor_site_id;
570:
571: CURSOR cur_get_ext_payee_id (cp_party_id IN NUMBER, cp_vendor_site_id IN NUMBER, cp_party_site_id IN NUMBER, cp_org_id IN NUMBER, cp_org_type IN VARCHAR2) IS
572: SELECT ext_payee_id