APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDORS_VIEW

Line 296: SELECT vendor_id FROM po_vendors_view

292: PROCEDURE convert_order_header_val_to_id(
293: p_x_osp_order_rec IN OUT NOCOPY osp_order_rec_type
294: ) IS
295: CURSOR vendor_id_csr(p_vendor_name IN VARCHAR2) IS
296: SELECT vendor_id FROM po_vendors_view
297: WHERE vendor_name = p_vendor_name
298: AND enabled_flag = G_YES_FLAG
299: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
300: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;

Line 599: FROM po_vendors_view

595: -------------------------------------------------------------------------------------------------------------
596: PROCEDURE validate_vendor(p_vendor_id IN NUMBER) IS
597: CURSOR val_vendor_id_csr(p_vendor_id IN NUMBER) IS
598: SELECT 'X'
599: FROM po_vendors_view
600: WHERE vendor_id = p_vendor_id
601: AND enabled_flag = G_YES_FLAG
602: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
603: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;

Line 6720: FROM po_vendors_view

6716: p_vendor_contact_id IN NUMBER)
6717: IS
6718: CURSOR val_vendor_id_csr IS
6719: SELECT 'X'
6720: FROM po_vendors_view
6721: WHERE vendor_id = p_vendor_id
6722: AND enabled_flag = G_YES_FLAG
6723: AND TRUNC(NVL(vendor_start_date_active, SYSDATE - 1)) <= TRUNC(SYSDATE)
6724: AND TRUNC(NVL(vendor_end_date_active, SYSDATE + 1)) > TRUNC(SYSDATE);