APPS.AHL_OSP_ORDERS_PVT dependencies on PO_VENDORS_VIEW

Line 275: SELECT vendor_id FROM po_vendors_view

271: PROCEDURE convert_order_header_val_to_id(
272: p_x_osp_order_rec IN OUT NOCOPY osp_order_rec_type
273: ) IS
274: CURSOR vendor_id_csr(p_vendor_name IN VARCHAR2) IS
275: SELECT vendor_id FROM po_vendors_view
276: WHERE vendor_name = p_vendor_name
277: AND enabled_flag = G_YES_FLAG
278: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
279: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;

Line 578: FROM po_vendors_view

574: -------------------------------------------------------------------------------------------------------------
575: PROCEDURE validate_vendor(p_vendor_id IN NUMBER) IS
576: CURSOR val_vendor_id_csr(p_vendor_id IN NUMBER) IS
577: SELECT 'X'
578: FROM po_vendors_view
579: WHERE vendor_id = p_vendor_id
580: AND enabled_flag = G_YES_FLAG
581: AND NVL(vendor_start_date_active, SYSDATE - 1) <= SYSDATE
582: AND NVL(vendor_end_date_active, SYSDATE + 1) > SYSDATE;

Line 6271: FROM po_vendors_view

6267: p_vendor_contact_id IN NUMBER)
6268: IS
6269: CURSOR val_vendor_id_csr IS
6270: SELECT 'X'
6271: FROM po_vendors_view
6272: WHERE vendor_id = p_vendor_id
6273: AND enabled_flag = G_YES_FLAG
6274: AND TRUNC(NVL(vendor_start_date_active, SYSDATE - 1)) <= TRUNC(SYSDATE)
6275: AND TRUNC(NVL(vendor_end_date_active, SYSDATE + 1)) > TRUNC(SYSDATE);