APPS.PER_OSE_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_org_structure_elements ose
     where ose.org_structure_element_id = p_org_structure_element_id
       and pbg.business_group_id = ose.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups pbg
         , per_org_structure_elements ose
     where ose.org_structure_element_id = p_org_structure_element_id
       and pbg.business_group_id (+) = ose.business_group_id;

Line: 175

Procedure chk_non_updateable_args
  (p_rec in per_ose_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 null
                     from per_org_structure_elements      ose
                     where   ose.org_structure_version_id    =
                                          p_org_structure_version_id
                     and     ose.organization_id_parent      =
                                          p_organization_id_child);

Line: 317

         select null
         into l_temp
         from sys.dual
         where exists( select null
                     from per_security_profiles psp
                     where   psp.include_top_organization_flag = 'Y'
                     and     psp.organization_structure_id     =
                           (select osv.organization_structure_id
                           from    per_org_structure_versions osv
                           where   osv.org_structure_version_id =
                                 p_org_structure_version_id)
                     and   ((psp.organization_id = p_organization_id_child)
                        or(psp.organization_id = p_organization_id_parent
                           and not exists (
                              select  null
                              from    per_org_structure_elements ose
                              where   ose.org_structure_version_id  =
                                       p_org_structure_version_id
                              and     ose.organization_id_child     =
                                       p_organization_id_parent
                              )
                           and     not exists (
                              select  null
                              from    per_org_structure_elements ose
                              where   ose.org_structure_version_id  =
                                       p_org_structure_version_id
                              and     ose.org_structure_element_id  <>
                                       p_org_structure_element_id
                              and     ose.organization_id_parent    =
                                       p_organization_id_parent
                              )
                           )
                        ) );

Line: 383

select str.position_control_structure_flg
from per_organization_structures str,
     per_org_structure_versions osv
where osv.org_structure_version_id = p_org_structure_version_id
and osv.organization_structure_id = str.organization_structure_id;

Line: 454

  SELECT 'X'
  from per_org_structure_versions osv
  where osv.org_structure_version_id = p_org_structure_version_id
  and (osv.business_group_id = p_business_group_id or p_business_group_id is null)
  and p_effective_date between osv.DATE_FROM
                       and nvl(osv.DATE_TO,hr_general.end_of_time);

Line: 546

  SELECT 'X'
  from hr_all_organization_units org
  where org.organization_id = p_org_id
  and (org.business_group_id = p_business_group_id
       or p_business_group_id is null)
  and p_effective_date between org.DATE_FROM
                       and nvl(org.DATE_TO,hr_general.end_of_time);

Line: 555

  SELECT 'X'
  from per_org_structure_elements ele
  where ele.org_structure_version_id = p_org_structure_version_id
  and ele.organization_id_child = p_organization_id_child;

Line: 562

  SELECT organization_id_parent
    from per_org_structure_elements
    where org_structure_version_id=p_org_structure_version_id
    START WITH organization_id_child=p_organization_id_parent
      and  org_structure_version_id=p_org_structure_version_id
    CONNECT BY organization_id_child= prior organization_id_parent
      and org_structure_version_id=p_org_structure_version_id ;

Line: 665

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

Line: 724

End insert_validate;

Line: 729

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

Line: 759

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 786

End update_validate;

Line: 791

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

Line: 828

End delete_validate;