APPS.PER_PGH_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_perf  pbg
         , per_gen_hierarchy pgh
     where pgh.hierarchy_id = p_hierarchy_id
       and pbg.business_group_id (+) = pgh.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups_perf  pbg
         , per_gen_hierarchy pgh
     where pgh.hierarchy_id = p_hierarchy_id
       and pbg.business_group_id (+) = pgh.business_group_id;

Line: 535

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in per_pgh_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 582

End chk_non_updateable_args;

Line: 682

    SELECT 'Y'
    FROM   per_gen_hierarchy
    WHERE  (business_group_id = p_business_group_id or p_business_group_id is null)
    AND    hierarchy_id <> nvl(p_hierarchy_id,-1)
    AND    name = p_name;

Line: 854

SELECT  nvl(Information3, 'Y')
FROM    per_shared_types
WHERE   lookup_type = 'HIERARCHY_TYPE'
AND     system_type_cd = p_type
AND     system_type_cd = shared_type_code;

Line: 861

SELECT 'Y'
FROM   Per_Gen_Hierarchy
WHERE  type = p_type;

Line: 899

Procedure chk_delete
  (p_hierarchy_id  in number) is
  --
  -- Declare local variables
  --
  l_exists      varchar2(1)  := 'N';

Line: 905

  l_proc        varchar2(72) := g_package||'chk_delete';

Line: 908

    select  'Y'
    from    per_gen_hierarchy_versions
    where   hierarchy_id = p_hierarchy_id;

Line: 913

    select 'X'
    from per_calendar_entries
    where hierarchy_id = p_hierarchy_id;

Line: 960

end chk_delete;

Line: 965

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

Line: 1029

End insert_validate;

Line: 1034

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

Line: 1051

  chk_non_updateable_args
    (p_effective_date              => p_effective_date
      ,p_rec              => p_rec
    );

Line: 1081

End update_validate;

Line: 1086

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

Line: 1099

  chk_delete
    (p_hierarchy_id   => p_rec.hierarchy_id
    );

Line: 1104

End delete_validate;