APPS.BEN_LSF_BUS SQL Statements

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

Line: 112

    select null
    from   ben_oab_fast_formula_f a
    where  a.OAB_FAST_FORMULA_ID = p_oab_fast_formula_id     --  88888
    and    p_effective_date
           between a.effective_start_date
           and     a.effective_end_date;

Line: 263

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_los_calc_rl
    and    ff.formula_type_id = -510
    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: 728

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_los_det_rl
    and    ff.formula_type_id = -170
    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: 844

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_rndg_rl
    and    ff.formula_type_id = -169
    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: 958

    select null
    from   ff_formulas_f ff
           ,per_business_groups pbg
    where  ff.formula_id = p_los_dt_to_use_rl
    and    ff.formula_type_id = -156
    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: 1069

    select null
    from   ben_los_fctr  lsf
    where  lsf.business_group_id = p_business_group_id and
                 lsf.name = p_name;

Line: 1279

/*   cursor chk_cmbn_age_los_fctr is select null
                                   from   ben_cmbn_age_los_fctr cla
                                   where  cla.los_fctr_id = p_los_fctr_id;*/

Line: 1342

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

Line: 1456

End insert_validate;

Line: 1461

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

Line: 1575

End update_validate;

Line: 1580

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

Line: 1592

End delete_validate;

Line: 1605

    select a.legislation_code
    from   per_business_groups a,
           ben_los_fctr b
    where b.los_fctr_id      = p_los_fctr_id
    and   a.business_group_id = b.business_group_id;