DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on FF_FORMULAS_F

Line 242: FROM ff_formulas_f fo, ff_formula_types ft

238: l_err NUMBER;
239: BEGIN
240: SELECT formula_id, effective_start_date
241: INTO l_formula_id, l_effective_date
242: FROM ff_formulas_f fo, ff_formula_types ft
243: WHERE ft.formula_type_name = 'Oracle Payroll'
244: AND fo.formula_type_id = ft.formula_type_id
245: AND fo.formula_name = 'RU_SPIFN_VALIDATION'
246: AND p_session_date BETWEEN fo.effective_start_date AND fo.effective_end_date;