APPS.PYUDET dependencies on FF_FORMULAS_F

Line 1044: l_formula_id ff_formulas_f.formula_id%type;

1040: FUNCTION validate_tax_code(p_tax_code in varchar2,
1041: p_effective_date in date,
1042: p_assignment_id in number) return VARCHAR2
1043: IS
1044: l_formula_id ff_formulas_f.formula_id%type;
1045: l_effective_start_date ff_formulas_f.effective_start_date%type;
1046: l_inputs ff_exec.inputs_t;
1047: l_outputs ff_exec.outputs_t;
1048: l_return_value varchar2(50):= null;

Line 1045: l_effective_start_date ff_formulas_f.effective_start_date%type;

1041: p_effective_date in date,
1042: p_assignment_id in number) return VARCHAR2
1043: IS
1044: l_formula_id ff_formulas_f.formula_id%type;
1045: l_effective_start_date ff_formulas_f.effective_start_date%type;
1046: l_inputs ff_exec.inputs_t;
1047: l_outputs ff_exec.outputs_t;
1048: l_return_value varchar2(50):= null;
1049: l_formula_mesg varchar2(50):= null;

Line 1059: from ff_formulas_f

1055: select formula_id,
1056: effective_start_date
1057: into l_formula_id,
1058: l_effective_start_date
1059: from ff_formulas_f
1060: where formula_name='TAX_CODE'
1061: and business_group_id is null
1062: and legislation_code='GB'
1063: and p_effective_date between effective_start_date and effective_end_date;