APPS.HR_CONTACT_API SQL Statements

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

Line: 125

    select legislation_code
    from per_business_groups
    where business_group_id = p_business_group_id;

Line: 443

      select   person_type_id into l_person_type_id
      from     per_person_types
      where    person_type_id = p_person_type_id
      and      business_group_id = p_business_group_id
      and      active_flag = 'Y'
      and      system_person_type = 'OTHER';

Line: 617

  SELECT object_version_number
   INTO p_object_version_number
   FROM per_all_people_f
   WHERE person_id = l_person_id
   And effective_start_Date = l_effective_start_date
   and effective_end_Date = l_effective_end_date;