DBA Data[Home] [Help]

APPS.OTA_EVAL_XMLP_PKG dependencies on HR_LOOKUPS

Line 35: from hr_lookups es

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