APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HR_LOOKUPS

Line 497: FROM hr_lookups h

493: SELECT 'error'
494: FROM sys.dual
495: WHERE EXISTS (
496: SELECT 'x'
497: FROM hr_lookups h
498: WHERE h.lookup_type = 'HXC_TK_CRITERIA_TYPES'
499: AND h.lookup_code = p_criteria_type
500: AND h.enabled_flag = 'Y'
501: AND sysdate BETWEEN h.start_date_active AND NVL(h.end_date_active, hr_general.end_of_time) );