APPS.OZF_AUTOPAY_PVT dependencies on PO_VENDORS

Line 114: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs

110: AND ca.cust_account_id = cv_cust_account_id;
111:
112: --Added cursor for Bug 16301629, to check if both vendor and vendor site is active
113: CURSOR csr_active_vendor(cv_vendor_id IN NUMBER, cv_vendor_site_id IN NUMBER) IS
114: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs
115: WHERE pv.vendor_id = pvs.vendor_id
116: AND (sysdate between nvl(pv.start_date_active, sysdate-1) and nvl(pv.end_date_active, sysdate+1))
117: AND (pvs.inactive_date is null or pvs.inactive_date > trunc(sysdate))
118: AND pv.vendor_id = cv_vendor_id