Line 537: lk.start_date_active and NVL(lk.end_date_active, hr_general.end_of_time) );
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) ); 538: --
539: l_error varchar2(5) := NULL;
540: --
541: BEGIN