APPS.HR_TMPLT dependencies on FF_FORMULAS_F

Line 32: from ff_formulas_f

28: l_return := null;
29: else
30: select formula_name
31: into l_return
32: from ff_formulas_f
33: where formula_id = p_formula_id
34: and sysdate between effective_start_date and effective_end_date;
35: end if;
36: return l_return;

Line 48: ff_formulas_f ff

44: SELECT
45: ff.formula_name
46: FROM
47: pay_status_processing_rules_f pspr,
48: ff_formulas_f ff
49: WHERE
50: pspr.element_type_id = p_element_type_id AND
51: p_effective_date BETWEEN pspr.effective_start_date AND
52: pspr.effective_end_date AND

Line 80: from ff_formulas_f

76: l_return := null;
77: else
78: select legislation_code
79: into l_leg_code
80: from ff_formulas_f
81: where formula_id = p_formula_id
82: and sysdate between effective_start_date and effective_end_date;
83:
84: if l_leg_code is null then

Line 104: from ff_formulas_f

100: l_return := null;
101: else
102: select business_group_id
103: into l_bus_group_id
104: from ff_formulas_f
105: where formula_id = p_formula_id
106: and sysdate between effective_start_date and effective_end_date;
107:
108: if l_bus_group_id is null then