APPS.PER_FR_PEOPLE_LEG_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

   select hl.meaning, hl.lookup_code
   from hr_lookups hl
   where hl.lookup_type = 'FR_DEPARTMENT'
   and p_hire_date
       between nvl(hl.start_date_active,p_hire_date)
       and nvl(hl.end_date_active,p_hire_date)
   and hl.lookup_code = p_region_of_birth
   and hl.enabled_flag = 'Y' order by hl.meaning;

Line: 103

   select hl.meaning, hl.lookup_code
   from hr_lookups hl
   where hl.lookup_type = 'FR_DEPARTMENT'
   and p_effective_date
       between nvl(hl.start_date_active,p_effective_date)
       and nvl(hl.end_date_active,p_effective_date)
   and hl.lookup_code = l_use_region_of_birth
   and hl.enabled_flag = 'Y' order by hl.meaning;

Line: 128

        select region_of_birth, country_of_birth, per_information10
        into   l_old_region_of_birth, l_old_country_of_birth, l_old_information10
        from   per_all_people_f
        where  person_id = p_person_id
        and    p_effective_Date between effective_start_date and effective_end_Date;