eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_NL_CALC_TARGET_GROUP dependencies on FF_FORMULAS_F_V

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';