APPS.HR_API SQL Statements

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

Line: 120

  hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');

Line: 174

         select distinct
                business_group_id
           from per_business_groups_perf
          where name = p_name;

Line: 214

         select  hl.lookup_code
         from    hr_lookups hl
         where   hl.lookup_type     = p_lookup_type
         and     hl.meaning         = p_meaning;

Line: 286

    select inf.org_information9
         , inf.org_information14
      from hr_organization_information hoi
         , hr_organization_information inf
     where hoi.organization_id = p_business_group_id
       and hoi.org_information_context||'' = 'CLASS' /* disable index */
       and hoi.org_information1 = 'HR_BG'
       and hoi.org_information2 = 'Y'
       and inf.organization_id = hoi.organization_id   --Bug 3633231
       and inf.org_information_context || '' = 'Business Group Information';

Line: 459

    select idfst.concatenated_segment_delimiter	csd,
           idfsg.application_column_name	acn,
           idfsg.enabled_flag                   ef
    from   fnd_id_flex_segments   		idfsg,
           fnd_id_flex_structures 		idfst
    where  idfst.id_flex_num    = p_id_flex_num
    and    idfst.application_id = p_application_id
    and    idfst.id_flex_code   = p_id_flex_code
    and    idfsg.id_flex_num    = idfst.id_flex_num
    and    idfsg.application_id = idfst.application_id
    and    idfsg.id_flex_code   = idfst.id_flex_code
    order by idfsg.segment_num;

Line: 823

    select null
      from hr_lookups
     where lookup_code  = p_lookup_code
       and lookup_type  = p_lookup_type
       and enabled_flag = 'Y'
       and p_effective_date between
               nvl(start_date_active, p_effective_date)
           and nvl(end_date_active, p_effective_date);

Line: 881

    select null
      from hr_leg_lookups
     where lookup_code  = p_lookup_code
       and lookup_type  = p_lookup_type
       and enabled_flag = 'Y'
       and p_effective_date between
               nvl(start_date_active, p_effective_date)
           and nvl(end_date_active, p_effective_date);

Line: 934

    select null
      from hr_standard_lookups
     where lookup_code  = p_lookup_code
       and lookup_type  = p_lookup_type
       and enabled_flag = 'Y'
       and p_effective_date between
               nvl(start_date_active, p_effective_date)
           and nvl(end_date_active, p_effective_date);

Line: 987

    select null
      from fnd_lookups
     where lookup_code  = p_lookup_code
       and lookup_type  = p_lookup_type
       and enabled_flag = 'Y'
       and p_effective_date between
               nvl(start_date_active, p_effective_date)
           and nvl(end_date_active, p_effective_date);

Line: 1154

    select meaning
      from hr_lookups
     where lookup_type  = 'API_HOOK_TYPE'
       and enabled_flag = 'Y'
       and lookup_code  = p_hook_type;

Line: 1228

    select meaning
      from hr_lookups
     where lookup_type  = 'API_HOOK_TYPE'
       and enabled_flag = 'Y'
       and lookup_code  = p_hook_type;

Line: 1378

    select legislation_code
      from per_business_groups_perf
     where business_group_id = p_business_group_id;

Line: 1446

    select null
      from fnd_languages lan
     where lan.installed_flag in ('I', 'B')
       and lan.language_code  = l_lang;