DBA Data[Home] [Help]

APPS.BEN_RECN_REP dependencies on FF_FORMULAS_F

Line 645: l_per_sel_rule ff_formulas_f.formula_name%type;

641: l_person per_all_people_f.full_name%type;
642: l_emp_name_format varchar2(80);
643: l_pgm ben_pgm_f.name%type;
644: l_pl ben_pl_f.name%type;
645: l_per_sel_rule ff_formulas_f.formula_name%type;
646: l_business_group varchar2(250);
647: l_organization varchar2(250);
648: l_location varchar2(250);
649: l_benfts_grp varchar2(250);

Line 1836: from ff_formulas_f ff

1832: --
1833:
1834: cursor c_formula is
1835: select formula_name
1836: from ff_formulas_f ff
1837: where ff.formula_id(+) = p_per_sel_rule_id
1838: and p_run_date between nvl(ff.effective_start_date,p_run_date)
1839: and nvl(ff.effective_end_date,p_run_date);
1840: --