APPS.HR_NI_CHK_PKG dependencies on FF_FORMULAS_F

Line 171: l_formula_id ff_formulas_f.formula_id%type;

167: p_country_of_birth VARCHAR2 default NULL,
168: p_nationality varchar2 -- added for the bug 5961277
169: ) RETURN VARCHAR2 is
170:
171: l_formula_id ff_formulas_f.formula_id%type;
172: l_effective_start_date ff_formulas_f.effective_start_date%type;
173: l_inputs ff_exec.inputs_t;
174: l_outputs ff_exec.outputs_t;
175: l_return_value varchar2(240);

Line 172: l_effective_start_date ff_formulas_f.effective_start_date%type;

168: p_nationality varchar2 -- added for the bug 5961277
169: ) RETURN VARCHAR2 is
170:
171: l_formula_id ff_formulas_f.formula_id%type;
172: l_effective_start_date ff_formulas_f.effective_start_date%type;
173: l_inputs ff_exec.inputs_t;
174: l_outputs ff_exec.outputs_t;
175: l_return_value varchar2(240);
176: l_invalid_mesg varchar2(240);

Line 200: -- from ff_formulas_f

196: l_return_value := p_national_identifier;
197: --
198: -- select formula_id,effective_start_date
199: -- into l_formula_id,l_effective_start_date
200: -- from ff_formulas_f
201: -- where formula_name='NI_VALIDATION'
202: -- and business_group_id is null
203: -- and legislation_code=p_legislation_code
204: -- and p_session_date between effective_start_date and effective_end_date;

Line 211: FROM FF_FORMULAS_F fo, ff_formula_types ft

207: --bug 2091601
208: --
209: SELECT FORMULA_ID,EFFECTIVE_START_DATE
210: into l_formula_id,l_effective_start_date
211: FROM FF_FORMULAS_F fo, ff_formula_types ft
212: WHERE ft.formula_type_name = 'Oracle Payroll'
213: and fo.formula_type_id = ft.formula_type_id
214: and fo.FORMULA_NAME = 'NI_VALIDATION'
215: AND fo.BUSINESS_GROUP_ID IS NULL