APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDOR_SITES

Line 282: SELECT vendor_site_id FROM po_vendor_sites

278: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
279: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;
280: l_vendor_id NUMBER;
281: CURSOR vendor_site_id_csr(p_vendor_site_code IN VARCHAR2) IS
282: SELECT vendor_site_id FROM po_vendor_sites
283: WHERE vendor_site_code = p_vendor_site_code
284: AND NVL(inactive_date, SYSDATE + 1) > SYSDATE
285: AND purchasing_site_flag = G_YES_FLAG;
286: l_vendor_site_id NUMBER;

Line 621: SELECT 'x' FROM po_vendor_sites

617:
618: -------------------------------------------------------------------------------------------------------------
619: PROCEDURE validate_vendor_site(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
620: CURSOR val_vendor_site_id_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
621: SELECT 'x' FROM po_vendor_sites
622: WHERE vendor_site_id = p_vendor_site_id
623: AND vendor_id = p_vendor_id
624: AND NVL(inactive_date, SYSDATE + 1) > SYSDATE
625: AND purchasing_site_flag = G_YES_FLAG

Line 6284: FROM po_vendor_sites

6280: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6281: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
6282: CURSOR val_vendor_site_id_csr IS
6283: SELECT 'X'
6284: FROM po_vendor_sites
6285: WHERE vendor_site_id = p_vendor_site_id
6286: AND vendor_id = p_vendor_id
6287: AND TRUNC(NVL(inactive_date, SYSDATE + 1)) > TRUNC(SYSDATE)
6288: AND purchasing_site_flag = G_YES_FLAG