APPS.POS_VENDOR_REG_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1571: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr

1567: (p_country is null));
1568:
1569: CURSOR po_vendor_sites_cur IS
1570: SELECT pvsa.vendor_id
1571: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr
1572: WHERE zxpr.rep_registration_number = p_taxreg_num
1573: AND zxpr.site_flag = 'Y'
1574: AND zxpr.party_id = pvsa.party_site_id
1575: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR