APPS.AP_VENDOR_PUB_PKG dependencies on AP_VENDOR_SITES_V

Line 2031: FROM ap_vendor_sites_v

2027: Begin
2028:
2029: SELECT nvl(count(primary_pay_site_flag),0)
2030: INTO l_dummy_1
2031: FROM ap_vendor_sites_v
2032: WHERE nvl(primary_pay_site_flag,'N') = 'Y'
2033: AND vendor_id = p_vendor_id
2034: AND nvl(inactive_date, sysdate + 1) > sysdate
2035: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);

Line 2058: FROM ap_vendor_sites_v

2054: ELSIF p_column_name = 'TAX_REPORTING_SITE_FLAG' THEN
2055:
2056: SELECT nvl(count(tax_reporting_site_flag),0)
2057: INTO l_dummy_1
2058: FROM ap_vendor_sites_v
2059: WHERE nvl(tax_reporting_site_flag,'N') = 'Y'
2060: AND vendor_id = p_vendor_id
2061: AND nvl(inactive_date, sysdate + 1) > sysdate
2062: AND nvl(vendor_site_id, -99) <> nvl(p_vendor_site_id, -99);