APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDOR_SITES

Line 303: SELECT vendor_site_id FROM po_vendor_sites

299: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
300: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;
301: l_vendor_id NUMBER;
302: CURSOR vendor_site_id_csr(p_vendor_site_code IN VARCHAR2) IS
303: SELECT vendor_site_id FROM po_vendor_sites
304: WHERE vendor_site_code = p_vendor_site_code
305: AND NVL(inactive_date, SYSDATE + 1) > SYSDATE
306: AND purchasing_site_flag = G_YES_FLAG;
307: l_vendor_site_id NUMBER;

Line 642: SELECT 'x' FROM po_vendor_sites

638:
639: -------------------------------------------------------------------------------------------------------------
640: PROCEDURE validate_vendor_site(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
641: CURSOR val_vendor_site_id_csr(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
642: SELECT 'x' FROM po_vendor_sites
643: WHERE vendor_site_id = p_vendor_site_id
644: AND vendor_id = p_vendor_id
645: AND NVL(inactive_date, SYSDATE + 1) > SYSDATE
646: AND purchasing_site_flag = G_YES_FLAG

Line 6733: FROM po_vendor_sites

6729: AND TRUNC(active_start_date) <= TRUNC(SYSDATE)
6730: AND TRUNC(nvl(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
6731: CURSOR val_vendor_site_id_csr IS
6732: SELECT 'X'
6733: FROM po_vendor_sites
6734: WHERE vendor_site_id = p_vendor_site_id
6735: AND vendor_id = p_vendor_id
6736: AND TRUNC(NVL(inactive_date, SYSDATE + 1)) > TRUNC(SYSDATE)
6737: AND purchasing_site_flag = G_YES_FLAG