APPS.BEN_BNR_BUS SQL Statements

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

Line: 39

       SELECT  1
	 FROM  ben_rptg_grp_tl rtl,
	       ben_rptg_grp rgp
	 WHERE upper(rgp.name)= upper(p_rpt_grp_name)
	 AND   rgp.rptg_grp_id = rtl.rptg_grp_id
	 AND   rtl.language = p_language
	 AND   (rtl.rptg_grp_id <> p_rpt_grp_id OR p_rpt_grp_id IS NULL)
	 AND   (rgp.business_group_id = p_bus_grp_id OR p_bus_grp_id IS NULL)
	 AND   (rgp.legislation_code = p_leg_code OR p_leg_code IS NULL);

Line: 243

    select null
    from ben_popl_rptg_grp_f rgr, ben_pl_f pln, ben_pl_typ_f ptp
    where rgr.rptg_grp_id = p_rptg_grp_id
    and rgr.pl_id = pln.pl_id
    and rgr.effective_start_date <= pln.effective_end_date
    and rgr.effective_end_date >= pln.effective_start_date
    and pln.pl_typ_id = ptp.pl_typ_id
    and ptp.business_group_id = rgr.business_group_id
    and greatest(rgr.effective_start_date, pln.effective_start_date) <= ptp.effective_end_date
    and least(rgr.effective_end_date, pln.effective_end_date) >= ptp.effective_start_date
    and ptp.opt_typ_cd <> 'COMP';

Line: 256

    select null
    from ben_popl_rptg_grp_f rgr
    where rgr.rptg_grp_id = p_rptg_grp_id
    and rgr.pgm_id is not null;

Line: 369

    select null
    from   ben_rptg_grp bnr
    ------ business group valiadted for global and non global
    where  nvl(bnr.business_group_id,nvl(p_business_group_id,-1)) =
           nvl(p_business_group_id,nvl(bnr.business_group_id,-1))
           ---  changes of busienss group  from non glbaol to gloabl
           ---  without changes in name may violate the uniqness
           ---  so allway chke the id
      and  bnr.rptg_grp_id <> nvl( p_rptg_grp_id , -1)
      and bnr.name = p_name;

Line: 416

      hr_utility.set_location(' comming for  update ' || p_rptg_grp_id, 99 );

Line: 477

    select null
    from   ben_popl_rptg_grp prg
    where  prg.business_group_id <> p_business_group_id
      and  prg.rptg_grp_id = p_rptg_grp_id
    union
    select null
    from   ben_pl_regy_bod_f prb
    where  prb.business_group_id <> p_business_group_id
      and  prb.rptg_grp_id = p_rptg_grp_id
    union
    select null
    from   ben_pl_regn_f pre
    where  pre.business_group_id <> p_business_group_id
      and  pre.rptg_grp_id = p_rptg_grp_id;

Line: 556

Procedure dt_delete_validate
            (p_rptg_grp_id		in number,
             p_datetrack_mode		in varchar2,
	     p_validation_start_date	in date,
	     p_validation_end_date	in date) Is
--
  l_proc	varchar2(72) 	:= g_package||'dt_delete_validate';

Line: 581

  If (p_datetrack_mode = 'DELETE' or
      p_datetrack_mode = 'ZAP') then
    --
    --
    -- Ensure the arguments are not null
    --

    hr_api.mandatory_arg_error
      (p_api_name       => l_proc,
       p_argument       => 'validation_start_date',
       p_argument_value => p_validation_start_date);

Line: 659

End dt_delete_validate;

Line: 664

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

Line: 706

End insert_validate;

Line: 711

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

Line: 763

End update_validate;

Line: 768

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

Line: 784

  dt_delete_validate
     (p_rptg_grp_id		=> p_rec.rptg_grp_id,
      p_datetrack_mode		=> 'ZAP',
     p_validation_start_date	=> to_date('01/01/1900','DD/MM/YYYY'),
     p_validation_end_date	=> to_date('31/12/4712','DD/MM/YYYY'));

Line: 794

End delete_validate;

Line: 807

    select a.legislation_code
    from   per_business_groups a,
           ben_rptg_grp b
    where b.rptg_grp_id      = p_rptg_grp_id
    and   a.business_group_id = b.business_group_id;