APPS.PER_POS_BUS SQL Statements

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

Line: 15

Procedure chk_non_updateable_args
  (p_rec            in per_pos_shd.g_rec_type
  ) is
--
  l_proc     varchar2(72) := g_package||'chk_non_updateable_args';

Line: 75

end chk_non_updateable_args;

Line: 91

       select inf.org_information14
      from hr_organization_information inf
         , per_positions  pos
     where pos.position_id = p_position_id
       and inf.organization_id = pos.business_group_id
       and inf.org_information_context || '' = 'Business Group Information';

Line: 180

     select 'x'
     from per_jobs job
     where job.job_id = p_job_id
     and job.business_group_id + 0 = p_business_group_id;

Line: 186

     select 'x'
     from per_jobs job
     where job.job_id = p_job_id
       and p_date_effective between job.date_from
       and nvl(job.date_to,hr_api.g_eot);

Line: 280

     select 'x'
     from per_organization_units oru
     where oru.organization_id = p_organization_id
     and oru.business_group_id + 0 = p_business_group_id
     and oru.internal_external_flag = 'INT';

Line: 287

     select 'x'
     from hr_organization_units oru
     where oru.organization_id = p_organization_id
       and p_date_effective between oru.date_from
       and nvl(oru.date_to,hr_api.g_eot);

Line: 378

     select 'x'
     from per_positions pos
     where pos.position_id               = p_successor_position_id
     and pos.business_group_id + 0       = p_business_group_id
     and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;

Line: 475

     select 'x'
     from per_positions pos
     where pos.position_id               = p_relief_position_id
     and pos.business_group_id + 0       = p_business_group_id
     and nvl(pos.date_end,hr_api.g_eot) >= p_date_effective ;

Line: 580

     select 'x'
     from hr_locations loc
     where loc.location_id = p_location_id
       and p_date_effective < nvl(loc.inactive_date,
         hr_api.g_eot);

Line: 656

  select 'x'
  from per_position_definitions
  where position_definition_id = p_position_definition_id;

Line: 839

     select 'x'
     from fnd_common_lookups
     where lookup_type = 'FREQUENCY'
     and lookup_code = p_frequency
     and enabled_flag = 'Y';

Line: 956

     select 'x'
     from fnd_common_lookups
     where lookup_type = 'QUALIFYING_UNITS'
       and lookup_code = p_probation_period_units;

Line: 1053

     select 'x'
     from fnd_common_lookups
     where lookup_type = 'YES_NO'
     and lookup_code = p_replacement_required_flag;

Line: 1464

   SELECT 'x'
   from dual
   where exists
     (select null
         from hr_all_positions_f pos
         where pos.business_group_id = p_business_group_id
           and pos.position_definition_id = p_position_definition_id
           and pos.position_id <> nvl(p_position_id, -1)
           and hr_general.effective_date
           between pos.effective_start_date and  pos.effective_end_date
     ) ;

Line: 1584

      select  'x'
        from  per_all_positions posn
       where  posn.name = p_name
         and  (p_position_id is null or posn.position_id <> p_position_id)
         and  posn.business_group_id = p_business_group_id;

Line: 1639

Procedure insert_validate(p_rec in per_pos_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 1788

End insert_validate;

Line: 1793

Procedure update_validate(p_rec in per_pos_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 1807

  chk_non_updateable_args(p_rec => p_rec);

Line: 1935

End update_validate;

Line: 1940

Procedure delete_validate(p_rec in per_pos_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 1950

End delete_validate;

Line: 1964

    select pbg.legislation_code
      from per_business_groups  pbg
         , per_positions        pos
     where pos.position_id       = p_position_id
       and pbg.business_group_id = pos.business_group_id;