eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PPV_BUS SQL Statements

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

Line: 86


    select null
    from ben_prtl_mo_rt_prtn_val_f ppv
    where ppv.PRORATE_BY_DAY_TO_MON_FLAG = 'Y'
    and   ppv.acty_base_rt_id = p_acty_base_rt_id
    and   p_effective_date between ppv.effective_start_date
          and ppv.effective_end_date;

Line: 94


     select null
     from ben_prtl_mo_rt_prtn_val_f ppv
     where ppv.PRORATE_BY_DAY_TO_MON_FLAG = 'Y'
     and   ppv.acty_base_rt_id = p_acty_base_rt_id
     and   ppv.prtl_mo_rt_prtn_val_id <> p_prtl_mo_rt_prtn_val_id
     and   p_effective_date between ppv.effective_start_date
          and ppv.effective_end_date;

Line: 106


  if p_mode = 'Insert' then
    open c1;

Line: 121


  elsif p_mode = 'Update' then
    --
    open c2;

Line: 248


    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_prtl_mo_prortn_rl
    and    ff.formula_type_id = -528
    and    pbg.business_group_id = p_business_group_id
    and    nvl(ff.business_group_id, p_business_group_id) =
               p_business_group_id
    and    nvl(ff.legislation_code, pbg.legislation_code) =
               pbg.legislation_code
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 343


    select null
    from   ff_formulas_f ff
    where  ff.formula_id = p_rndg_rl
    and    p_effective_date
           between ff.effective_start_date
           and     ff.effective_end_date;

Line: 572


             select 'Y'
             from   ben_prtl_mo_rt_prtn_val_f
             Where  prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
             and    (acty_base_rt_id = p_acty_base_rt_id  or
                     actl_prem_id = p_actl_prem_id)   -- Bug 4440097
	     and    prorate_by_day_to_mon_flag = 'Y'
 --Bug 6242951
      /*     and    p_validation_start_date <= effective_end_date
             and    p_validation_end_date >= effective_start_date
       */
       	     and    not ((p_validation_end_date < effective_start_date)
	            or (p_validation_start_date > effective_end_date))
 --Bug 6242951
             and    business_group_id = p_business_group_id;

Line: 726


cursor c1 is select from_dy_mo_num, to_dy_mo_num
             from   ben_prtl_mo_rt_prtn_val_f
             Where  prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
             and    acty_base_rt_id = p_acty_base_rt_id
             and    strt_r_stp_cvg_cd = p_strt_r_stp_cvg_cd
	     and    num_days_month = p_num_days_month           -- Bug No 4366086
        --     and    p_effective_date between effective_start_date
        --            and effective_end_date
 	     and p_validation_start_date <= effective_end_date
             and p_validation_end_date >= effective_start_date
             and    business_group_id = p_business_group_id;

Line: 738


cursor c2 is select strt_r_stp_cvg_cd
             from   ben_prtl_mo_rt_prtn_val_f
             Where  prtl_mo_rt_prtn_val_id <> nvl(p_prtl_mo_rt_prtn_val_id,-1)
             and    acty_base_rt_id = p_acty_base_rt_id
             and    num_days_month = p_num_days_month           -- Bug No 4366086
         --    and    p_effective_date between effective_start_date
         --           and effective_end_date
    	     and p_validation_start_date <= effective_end_date
             and p_validation_end_date >= effective_start_date
             and    business_group_id = p_business_group_id;

Line: 782


        fnd_message.set_name('BEN','BEN_92306_MAY_NOT_SELECT_ETHR');

Line: 828


Procedure dt_update_validate
            (p_actl_prem_id                  in number default hr_api.g_number,
             p_cvg_amt_calc_mthd_id          in number default hr_api.g_number,
             p_acty_base_rt_id               in number default hr_api.g_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_update_validate';

Line: 919


End dt_update_validate;

Line: 956


Procedure dt_delete_validate
            (p_prtl_mo_rt_prtn_val_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: 979


  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: 1023


End dt_delete_validate;

Line: 1028


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

Line: 1049


                               p_mode => 'Insert');

Line: 1115


End insert_validate;

Line: 1120


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

Line: 1141


                               p_mode => 'Update',
                               p_prtl_mo_rt_prtn_val_id => p_rec.prtl_mo_rt_prtn_val_id);

Line: 1209


  dt_update_validate
    (p_actl_prem_id                  => p_rec.actl_prem_id,
             p_cvg_amt_calc_mthd_id          => p_rec.cvg_amt_calc_mthd_id,
             p_acty_base_rt_id               => p_rec.acty_base_rt_id,
     p_datetrack_mode                => p_datetrack_mode,
     p_validation_start_date	     => p_validation_start_date,
     p_validation_end_date	     => p_validation_end_date);

Line: 1218


End update_validate;

Line: 1223


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

Line: 1237


  dt_delete_validate
    (p_datetrack_mode		=> p_datetrack_mode,
     p_validation_start_date	=> p_validation_start_date,
     p_validation_end_date	=> p_validation_end_date,
     p_prtl_mo_rt_prtn_val_id		=> p_rec.prtl_mo_rt_prtn_val_id);

Line: 1244


End delete_validate;

Line: 1257


    select a.legislation_code
    from   per_business_groups a,
           ben_prtl_mo_rt_prtn_val_f b
    where b.prtl_mo_rt_prtn_val_id      = p_prtl_mo_rt_prtn_val_id
    and   a.business_group_id = b.business_group_id;