APPS.PER_PSE_BUS SQL Statements

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

Line: 27

    select pbg.security_group_id
      from per_business_groups pbg
         , per_pos_structure_elements pse
     where pse.pos_structure_element_id = p_pos_structure_element_id
       and pbg.business_group_id = pse.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups pbg
         , per_pos_structure_elements pse
     where pse.pos_structure_element_id = p_pos_structure_element_id
       and pbg.business_group_id = pse.business_group_id;

Line: 175

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

Line: 251

End chk_non_updateable_args;

Line: 270

                select null
                into l_temp
                from sys.dual
                where exists(select 1
                from per_pos_structure_elements pse
                where pse.parent_position_id = p_Subordinate_position_Id
                and   pse.pos_structure_version_id = p_Pos_Structure_version_Id);

Line: 294

   select null
   into l_dummy
   from sys.dual
   where exists(select 1
   from per_security_profiles psp
   where  psp.business_group_id + 0     = p_Business_Group_Id
   and    psp.position_id = p_Subordinate_position_Id
   and    psp.position_structure_id = (select psv.position_structure_id
                                      from per_pos_structure_versions psv
                                      where psv.Pos_Structure_version_Id
                                            = p_Pos_Structure_version_Id)
   );

Line: 350

  SELECT 'X'
  from per_pos_structure_versions psv
  where psv.pos_structure_version_id = p_pos_structure_version_id
  and psv.business_group_id = p_business_group_id
  and p_effective_date between psv.DATE_FROM
                       and nvl(psv.DATE_TO,hr_general.end_of_time);

Line: 443

  SELECT 'X'
  from hr_all_positions_f pos
  where pos.POSITION_ID = p_pos_id
  and pos.business_group_id = p_business_group_id
  and p_effective_date between pos.EFFECTIVE_START_DATE
                       and pos.EFFECTIVE_END_DATE;

Line: 451

  SELECT 'X'
  from per_pos_structure_elements ele
  where ele.pos_structure_version_id = p_pos_structure_version_id
  and ele.subordinate_position_id = p_subordinate_position_id;

Line: 535

Procedure insert_validate
  (p_rec                          in per_pse_shd.g_rec_type
  ,p_effective_date               in date
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 569

End insert_validate;

Line: 574

Procedure update_validate
  (p_rec                          in per_pse_shd.g_rec_type
  ,p_effective_date               in date
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 588

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 594

End update_validate;

Line: 599

Procedure delete_validate
  (p_rec                          in per_pse_shd.g_rec_type
  ,p_hr_installed                 in VARCHAR2
  ,p_chk_children                 in VARCHAR2
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 628

End delete_validate;