APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on PO_VENDORS

Line 1824: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs

1820: AND ca.cust_account_id = cv_cust_account_id;
1821:
1822: --Added cursor for Bug 16301629 , to check if both vendor and vendor site is active
1823: CURSOR csr_active_vendor(cv_vendor_id IN NUMBER, cv_vendor_site_id IN NUMBER) IS
1824: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs
1825: WHERE pv.vendor_id = pvs.vendor_id
1826: AND (sysdate between nvl(pv.start_date_active, sysdate-1) and nvl(pv.end_date_active, sysdate+1))
1827: AND (pvs.inactive_date is null or pvs.inactive_date > trunc(sysdate))
1828: AND pv.vendor_id = cv_vendor_id