APPS.BEN_RULES SQL Statements

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

Line: 12

                                benutils.formula in procedure chk_person_selection.
  ---------------------------------------------------------------------------------
*/
--
g_package    varchar2(80) := 'ben_rules';

Line: 18

function chk_person_selection
    (p_person_selection_rule_id in number,
     p_person_id                in number,
     p_business_group_id        in number,
     p_effective_date           in date,
     p_ler_id                   in number) return boolean is
  --
  l_outputs       ff_exec.outputs_t;

Line: 30

  if p_person_selection_rule_id is null then
    --
    return true;

Line: 42

      (p_formula_id     => p_person_selection_rule_id,
       p_effective_date => p_effective_date,
       p_business_group_id => p_business_group_id,
       p_assignment_id  => l_assignment_id,
       p_param1         => 'BEN_IV_PERSON_ID',           -- Bug 5331889
       p_param1_value   => to_char(p_person_id),
       p_param2         => 'BEN_LER_IV_LER_ID',
       p_param2_value   => to_char(p_ler_id)
);

Line: 69

end chk_person_selection;

Line: 74

function chk_comp_object_selection
           (p_oipl_id                  in number,
            p_pl_id                    in number,
            p_pgm_id                   in number,
            p_pl_typ_id                in number,
            p_opt_id                   in number,
            p_business_group_id        in number,
            p_comp_selection_rule_id   in number,
            p_effective_date           in date) return boolean is
  --
  l_package   varchar2(80) := g_package||'.chk_comp_object_selection';

Line: 92

  if p_comp_selection_rule_id is not null then
    --
    -- Call formula initialise routine
    --
    hr_utility.set_location ('call formula '||l_package,20);

Line: 98

       (p_formula_id        => p_comp_selection_rule_id,
        p_effective_date    => p_effective_date,
        p_business_group_id => p_business_group_id,
        p_assignment_id     => null,
        p_organization_id   => null,
        p_pl_id             => p_pl_id,
        p_pl_typ_id         => p_pl_typ_id,
        p_pgm_id            => p_pgm_id,
        p_opt_id            => p_opt_id,
        p_jurisdiction_code => null);

Line: 139

end chk_comp_object_selection;