APPS.POS_VENDOR_REG_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1864: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr

1860: (p_country is null));
1861:
1862: CURSOR po_vendor_sites_cur IS
1863: SELECT pvsa.vendor_id
1864: FROM ap_supplier_sites_all pvsa, zx_party_tax_profile zxpr
1865: WHERE zxpr.rep_registration_number = p_taxreg_num
1866: AND zxpr.site_flag = 'Y'
1867: AND zxpr.party_id = pvsa.party_site_id
1868: AND ((zxpr.country_code is not null and p_country is not null and zxpr.country_code = p_country) OR