APPS.BEN_EAT_BUS SQL Statements

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

Line: 109

    SELECT  'x'
    FROM    ben_actn_typ
    WHERE   type_cd                    = nvl(p_type_cd, hr_api.g_varchar2)
    AND     business_group_id + 0     = p_business_group_id;

Line: 194

         cursor c1 is select null
                      from ben_prtt_enrt_actn_f
                      where actn_typ_id = p_actn_typ_id;

Line: 248

  select null
  from ben_actn_typ
  where name = p_name
    and p_actn_typ_id <> nvl(p_actn_typ_id, hr_api.g_number)
    and business_group_id + 0 = p_business_group_id;

Line: 324

    select type_cd
    from ben_actn_typ
    where actn_typ_id = p_actn_typ_id;

Line: 347

       fnd_message.set_name('PAY','HR_6044_STARTUP_CANNOT_DELETE');

Line: 363

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

Line: 398

End insert_validate;

Line: 403

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

Line: 435

End update_validate;

Line: 440

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

Line: 455

End delete_validate;

Line: 468

    select a.legislation_code
    from   per_business_groups a,
           ben_actn_typ b
    where b.actn_typ_id      = p_actn_typ_id
    and   a.business_group_id = b.business_group_id;