APPS.HXC_TER_UPLOAD_PKG dependencies on FF_FORMULAS_F

Line 51: l_formula_id ff_formulas_f.formula_id%TYPE;

47: , p_custom_mode IN VARCHAR2 ) IS
48:
49: l_time_entry_rule_id hxc_time_entry_rules.time_entry_rule_id%TYPE;
50: l_mapping_id hxc_mappings.mapping_id%TYPE;
51: l_formula_id ff_formulas_f.formula_id%TYPE;
52: l_ovn hxc_deposit_processes.object_version_number%TYPE := NULL;
53: l_owner VARCHAR2(6);
54: l_formula_name Varchar2(150);
55:

Line 64: FROM ff_formulas_f ff

60: FUNCTION get_ff_id ( p_formula_name VARCHAR2 ) RETURN NUMBER IS
61:
62: CURSOR csr_get_ff_id IS
63: SELECT formula_id
64: FROM ff_formulas_f ff
65: WHERE ff.formula_name = p_formula_name
66: AND TO_DATE(p_start_date, 'DD-MM-YYYY') BETWEEN ff.effective_start_date AND ff.effective_end_date;
67:
68: l_formula_id ff_formulas_f.formula_id%TYPE;

Line 68: l_formula_id ff_formulas_f.formula_id%TYPE;

64: FROM ff_formulas_f ff
65: WHERE ff.formula_name = p_formula_name
66: AND TO_DATE(p_start_date, 'DD-MM-YYYY') BETWEEN ff.effective_start_date AND ff.effective_end_date;
67:
68: l_formula_id ff_formulas_f.formula_id%TYPE;
69:
70: BEGIN
71:
72: OPEN csr_get_ff_id;