APPS.PYUDET dependencies on FF_FORMULAS_F

Line 1170: l_formula_id ff_formulas_f.formula_id%type;

1166: FUNCTION validate_tax_code(p_tax_code in varchar2,
1167: p_effective_date in date,
1168: p_assignment_id in number) return VARCHAR2
1169: IS
1170: l_formula_id ff_formulas_f.formula_id%type;
1171: l_effective_start_date ff_formulas_f.effective_start_date%type;
1172: l_inputs ff_exec.inputs_t;
1173: l_outputs ff_exec.outputs_t;
1174: l_return_value varchar2(50):= null;

Line 1171: l_effective_start_date ff_formulas_f.effective_start_date%type;

1167: p_effective_date in date,
1168: p_assignment_id in number) return VARCHAR2
1169: IS
1170: l_formula_id ff_formulas_f.formula_id%type;
1171: l_effective_start_date ff_formulas_f.effective_start_date%type;
1172: l_inputs ff_exec.inputs_t;
1173: l_outputs ff_exec.outputs_t;
1174: l_return_value varchar2(50):= null;
1175: l_formula_mesg varchar2(50):= null;

Line 1185: from ff_formulas_f

1181: select formula_id,
1182: effective_start_date
1183: into l_formula_id,
1184: l_effective_start_date
1185: from ff_formulas_f
1186: where formula_name='TAX_CODE'
1187: and business_group_id is null
1188: and legislation_code='GB'
1189: and p_effective_date between effective_start_date and effective_end_date;