APPS.BEN_ECR_BUS SQL Statements

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

Line: 109

    select null
    from   ben_elig_per_elctbl_chc a
    where  a.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;

Line: 185

    select null
    from   ben_enrt_bnft a
    where  a.enrt_bnft_id = p_enrt_bnft_id;

Line: 726

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

Line: 794

End insert_validate;

Line: 799

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

Line: 867

End update_validate;

Line: 872

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

Line: 883

End delete_validate;

Line: 895

    select a.legislation_code
    from   per_business_groups a,
           ben_enrt_rt b
    where b.enrt_rt_id        = p_enrt_rt_id
    and   a.business_group_id = b.business_group_id;