APPS.OTA_CERT_XMLP_PKG dependencies on HR_LOOKUPS

Line 20: from hr_lookups es

16:
17: FUNCTION C_SUBSCRIPTION_STATUS_p RETURN varchar2 IS
18: cursor c_lookup_code is
19: select es.meaning
20: from hr_lookups es
21: WHERE es.lookup_type='OTA_CERT_ENROLL_STATUS'
22: AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
23: AND es.enabled_flag ='Y'
24: AND es.lookup_code = P_SUBSCRIPTION_STATUS ;