APPS.AP_VENDOR_PUB_PKG dependencies on AP_VENDOR_SITES_V

Line 2316: FROM ap_vendor_sites_v

2312: Begin
2313:
2314: SELECT nvl(count(primary_pay_site_flag),0)
2315: INTO l_dummy_1
2316: FROM ap_vendor_sites_v
2317: WHERE nvl(primary_pay_site_flag,'N') = 'Y'
2318: AND vendor_id = p_vendor_id
2319: AND nvl(inactive_date, sysdate + 1) > sysdate
2320: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);

Line 2345: FROM ap_vendor_sites_v

2341: ELSIF p_column_name = 'TAX_REPORTING_SITE_FLAG' THEN
2342:
2343: SELECT nvl(count(tax_reporting_site_flag),0)
2344: INTO l_dummy_1
2345: FROM ap_vendor_sites_v
2346: WHERE nvl(tax_reporting_site_flag,'N') = 'Y'
2347: AND vendor_id = p_vendor_id
2348: AND nvl(inactive_date, sysdate + 1) > sysdate
2349: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);