APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_VENDOR_CERTIFICATIONS_V

Line 1536: FROM ahl_vendor_certifications_v

1532: ORDER BY IV.rank;
1533: l_get_vendor_certs get_vendor_certs%ROWTYPE;
1534: CURSOR get_vendor_name(c_vendor_cert_id NUMBER) IS
1535: SELECT vendor_name
1536: FROM ahl_vendor_certifications_v
1537: WHERE vendor_certification_id = c_vendor_cert_id
1538: AND trunc(active_start_date) <= trunc(SYSDATE)
1539: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1540: l_vendor_name VARCHAR2(240) := NULL;