APPS.BEN_BFT_BUS SQL Statements

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

Line: 171

Procedure chk_person_selection_rl(p_benefit_action_id     in number,
                                  p_person_selection_rl   in number,
                                  p_business_group_id     in number,
                                  p_effective_date        in date,
                                  p_object_version_number in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_person_selection_rl';

Line: 189

      and nvl(p_person_selection_rl,hr_api.g_number)
      <> ben_bft_shd.g_old_rec.person_selection_rl
      or not l_api_updating)
      and p_person_selection_rl is not null then
    --
    -- check if value of formula rule is valid.
    --
    if not benutils.formula_exists
       (p_formula_id        => p_person_selection_rl,
        p_formula_type_id   => -214,
        p_business_group_id => p_business_group_id,
        p_effective_date    => p_effective_date) then
      --
      -- raise error
      --
      fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

Line: 205

      fnd_message.set_token('ID',p_person_selection_rl);

Line: 215

end chk_person_selection_rl;

Line: 243

Procedure chk_comp_selection_rl(p_benefit_action_id      in number,
                                p_comp_selection_rl      in number,
                                p_business_group_id      in number,
                                p_effective_date         in date,
                                p_object_version_number  in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_comp_selection_rl';

Line: 261

      and nvl(p_comp_selection_rl,hr_api.g_number)
      <> ben_bft_shd.g_old_rec.comp_selection_rl
      or not l_api_updating)
      and p_comp_selection_rl is not null then
    --
    -- check if value of formula rule is valid.
    --
    if not benutils.formula_exists
       (p_formula_id        => p_comp_selection_rl,
        p_formula_type_id   => -213,
        p_business_group_id => p_business_group_id,
        p_effective_date    => p_effective_date) then
      --
      -- raise error
      --
      fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

Line: 277

      fnd_message.set_token('ID',p_comp_selection_rl);

Line: 287

end chk_comp_selection_rl;

Line: 716

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

Line: 744

  chk_person_selection_rl
  (p_benefit_action_id     => p_rec.benefit_action_id,
   p_person_selection_rl   => p_rec.person_selection_rl,
   p_business_group_id     => p_rec.business_group_id,
   p_effective_date        => p_effective_date,
   p_object_version_number => p_rec.object_version_number);

Line: 751

  chk_comp_selection_rl
  (p_benefit_action_id     => p_rec.benefit_action_id,
   p_comp_selection_rl     => p_rec.comp_selection_rl,
   p_business_group_id     => p_rec.business_group_id,
   p_effective_date        => p_effective_date,
   p_object_version_number => p_rec.object_version_number);

Line: 795

End insert_validate;

Line: 800

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

Line: 828

  chk_person_selection_rl
  (p_benefit_action_id     => p_rec.benefit_action_id,
   p_person_selection_rl   => p_rec.person_selection_rl,
   p_business_group_id     => p_rec.business_group_id,
   p_effective_date        => p_effective_date,
   p_object_version_number => p_rec.object_version_number);

Line: 835

  chk_comp_selection_rl
  (p_benefit_action_id     => p_rec.benefit_action_id,
   p_comp_selection_rl     => p_rec.comp_selection_rl,
   p_business_group_id     => p_rec.business_group_id,
   p_effective_date        => p_effective_date,
   p_object_version_number => p_rec.object_version_number);

Line: 879

End update_validate;

Line: 884

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

Line: 895

End delete_validate;

Line: 908

    select a.legislation_code
    from   per_business_groups a,
           ben_benefit_actions b
    where b.benefit_action_id = p_benefit_action_id
    and   a.business_group_id = b.business_group_id;