DBA Data[Home] [Help]

APPS.OTA_EVAL_XMLP_PKG dependencies on HR_LOOKUPS

Line 36: from hr_lookups es

32:
33: FUNCTION C_ANSWER_TYPE_p RETURN varchar2 IS
34: cursor c_lookup_code is
35: select es.meaning
36: from hr_lookups es
37: WHERE es.lookup_type='OTA_EVAL_REPORT_TYPE'
38: AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
39: AND es.enabled_flag ='Y'
40: AND es.lookup_code = P_ANSWER_TYPE ;