APPS.HR_NL_CALC_TARGET_GROUP dependencies on FF_FORMULAS_F

Line 64: l_formula_id ff_formulas_f_v.formula_id%type;

60: p_business_group_id per_all_people_f.business_group_id%type,
61: p_session_date date)
62: return VARCHAR2 is
63:
64: l_formula_id ff_formulas_f_v.formula_id%type;
65: l_effective_start_date ff_formulas_f_v.effective_start_date%type;
66: l_target_group varchar2(10);
67:
68: begin

Line 65: l_effective_start_date ff_formulas_f_v.effective_start_date%type;

61: p_session_date date)
62: return VARCHAR2 is
63:
64: l_formula_id ff_formulas_f_v.formula_id%type;
65: l_effective_start_date ff_formulas_f_v.effective_start_date%type;
66: l_target_group varchar2(10);
67:
68: begin
69: begin

Line 72: from ff_formulas_f_v

68: begin
69: begin
70: select formula_id ,effective_start_date
71: into l_formula_id,l_effective_start_date
72: from ff_formulas_f_v
73: where formula_name = 'NL_TARGET_GROUP'
74: and p_session_date between effective_start_date and
75: effective_end_date
76: and verified = 'Y';

Line 101: l_formula_id ff_formulas_f.formula_id%type;

97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;
102: l_effective_start_date ff_formulas_f.effective_start_date%type;
103: l_target_group varchar2(10);
104: l_label_text hr_lookups.meaning%type;
105: l_rec_status varchar2(20);

Line 102: l_effective_start_date ff_formulas_f.effective_start_date%type;

98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;
102: l_effective_start_date ff_formulas_f.effective_start_date%type;
103: l_target_group varchar2(10);
104: l_label_text hr_lookups.meaning%type;
105: l_rec_status varchar2(20);
106: l_return_target_group varchar2(1);