DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on PO_VENDORS

Line 3848: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs

3844: l_payment_method VARCHAR2(30);
3845:
3846: --Added cursor for Bug 16301629 , to check if both vendor and vendor site is active
3847: CURSOR csr_active_vendor(cv_vendor_id IN NUMBER, cv_vendor_site_id IN NUMBER) IS
3848: SELECT 1 FROM po_vendors pv, po_vendor_sites pvs
3849: WHERE pv.vendor_id = pvs.vendor_id
3850: AND (sysdate between nvl(pv.start_date_active, sysdate-1) and nvl(pv.end_date_active, sysdate+1))
3851: AND (pvs.inactive_date is null or pvs.inactive_date > trunc(sysdate))
3852: AND pv.vendor_id = cv_vendor_id