APPS.HXC_EGC_BUS dependencies on HR_LOOKUPS

Line 533: FROM hr_lookups lk

529: SELECT 'error'
530: FROM sys.dual
531: WHERE NOT EXISTS (
532: SELECT 'x'
533: FROM hr_lookups lk
534: WHERE lk.lookup_type = 'HXC_ENTITIES'
535: AND lk.lookup_code = p_entity_type
536: AND p_effective_date BETWEEN
537: lk.start_date_active and NVL(lk.end_date_active, hr_general.end_of_time) );