APPS.BEN_LER_BUS SQL Statements

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

Line: 34

       SELECT  1
	 FROM  ben_ler_f_tl ler_tl,
	       ben_ler_f ler
	 WHERE upper(ler.name)= upper(p_ler_name)
	 AND   ler.ler_id = ler_tl.ler_id
	 AND   ler_tl.language = p_language
	 AND   (ler_tl.ler_id <> p_ler_id OR p_ler_id IS NULL)
	 AND   (ler.business_group_id = p_bus_grp_id OR p_bus_grp_id IS NULL);

Line: 168

           p_delete_flag                 in  varchar2 default 'N',
           p_table_name                  out nocopy varchar2) is
  --
  l_proc         varchar2(72) := g_package||'chk_child_rows';

Line: 268

       if p_delete_flag = 'Y' then
          ben_utility.child_exists_error(p_table_name => l_table_name);

Line: 290

  select null into dummy from ben_ler_f ler
    where ler.ler_id = p_ler_id and ler.typ_cd in
    (select typ_cd from ben_startup_lers);

Line: 294

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

Line: 409

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_ler_eval_rl
    and    ff.formula_type_id = -157   -- Life Event Evaluation
    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: 644

  select null
    from ben_ler_f
   where lf_evt_oper_cd = p_lf_evt_oper_cd
     and ler_id <> nvl(p_ler_id,-1)
     and business_group_id      = p_business_group_id
     and effective_end_date     >= p_validation_start_date
     and effective_start_date   <= p_validation_end_date  ;

Line: 696

    if p_typ_cd = 'ABS' and p_lf_evt_oper_cd not in ('START', 'END', 'DELETE') then
      --
      fnd_message.set_name('BEN', 'BEN_94033_ABS_OPER_CD_FALSE');

Line: 729

    elsif p_lf_evt_oper_cd = 'DELETE' then
      open c1;

Line: 868

    SELECT  'x'
    FROM    ben_ler_f
    WHERE   typ_cd                    = nvl(p_typ_cd, hr_api.g_varchar2)
    AND     business_group_id + 0     = p_business_group_id
    AND     effective_end_date       >= p_validation_start_date
    AND     effective_start_date     <= p_validation_end_date  ;

Line: 1067

    select  null
    from    ben_ler_f ler
    where   ler.typ_cd                    = 'IREC'
    and     ler.ler_id                   <> nvl(p_ler_id, -1)
    and     ler.business_group_id + 0     = p_business_group_id
    and     p_validation_start_date      <= ler.effective_end_date
    and     p_validation_end_date        >= ler.effective_start_date;

Line: 1306

    SELECT  name
    FROM    ben_ler_f
    WHERE   ler_id                    <> nvl(p_ler_id, hr_api.g_number)
    AND     name                      = p_name
    AND     business_group_id + 0     = p_business_group_id
    AND     effective_end_date       >= p_validation_start_date
    AND     effective_start_date     <= p_validation_end_date  ;

Line: 1806

Procedure dt_update_validate
            (p_formula_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: 1873

End dt_update_validate;

Line: 1907

Procedure dt_delete_validate
            (p_ler_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: 1929

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

           p_delete_flag                 => 'Y',
           p_table_name                  => l_table_name);

Line: 1979

End dt_delete_validate;

Line: 1984

Procedure insert_validate
	(p_rec 			 in ben_ler_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: 2136

End insert_validate;

Line: 2141

Procedure update_validate
	(p_rec 			 in ben_ler_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: 2288

  dt_update_validate
    (p_formula_id           => p_rec.ler_eval_rl,
     p_datetrack_mode                => p_datetrack_mode,
     p_validation_start_date	     => p_validation_start_date,
     p_validation_end_date	     => p_validation_end_date);

Line: 2295

End update_validate;

Line: 2300

Procedure delete_validate
	(p_rec 			 in ben_ler_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: 2314

  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_ler_id		=> p_rec.ler_id);

Line: 2321

End delete_validate;

Line: 2334

    select a.legislation_code
    from   per_business_groups a,
           ben_ler_f b
    where b.ler_id      = p_ler_id
    and   a.business_group_id = b.business_group_id;