APPS.HRI_BPL_UTILIZATION dependencies on FF_FORMULAS_F

Line 21: FROM ff_formulas_f fff

17: WHERE formula_type_name = 'QuickPaint';
18:
19: CURSOR g_template_formula_csr IS
20: SELECT fff.formula_id
21: FROM ff_formulas_f fff
22: WHERE fff.formula_type_id = g_formula_type_id
23: AND fff.business_group_id IS NULL
24: AND sysdate BETWEEN fff.effective_start_date AND fff.effective_end_date
25: AND fff.formula_name = 'TEMPLATE_BIS_DAYS_TO_HOURS';

Line 36: FROM ff_formulas_f fff

32: RETURN VARCHAR2 IS
33:
34: CURSOR use_customer_formula_csr IS
35: SELECT 'Y'
36: FROM ff_formulas_f fff
37: WHERE fff.formula_type_id = g_formula_type_id
38: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
39: AND fff.business_group_id = p_business_group_id
40: AND fff.formula_name = 'BG_ABSENCE_DURATION'

Line 44: ff_formulas_f fff

40: AND fff.formula_name = 'BG_ABSENCE_DURATION'
41: UNION ALL
42: SELECT 'Y'
43: FROM
44: ff_formulas_f fff
45: ,per_business_groups bgr
46: WHERE fff.formula_type_id = g_formula_type_id
47: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
48: AND fff.business_group_id IS NULL

Line 54: FROM ff_formulas_f fff

50: AND bgr.legislation_code = fff.legislation_code
51: AND fff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
52: UNION ALL
53: SELECT 'Y'
54: FROM ff_formulas_f fff
55: WHERE fff.formula_type_id = g_formula_type_id
56: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
57: AND fff.business_group_id IS NULL
58: AND fff.formula_name = 'CORE_ABSENCE_DURATION';

Line 99: FROM ff_formulas_f fff

95: RETURN NUMBER IS
96:
97: CURSOR customer_formula_csr IS
98: SELECT fff.formula_id
99: FROM ff_formulas_f fff
100: WHERE fff.formula_type_id = g_formula_type_id
101: AND fff.business_group_id = p_business_group_id
102: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
103: AND fff.formula_name = 'BIS_DAYS_TO_HOURS';

Line 107: FROM ff_formulas_f fff

103: AND fff.formula_name = 'BIS_DAYS_TO_HOURS';
104:
105: CURSOR customer_global_formula_csr IS
106: SELECT fff.formula_id
107: FROM ff_formulas_f fff
108: WHERE fff.formula_type_id = g_formula_type_id
109: AND fff.business_group_id = 0
110: AND TRUNC(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
111: AND fff.formula_name = 'BIS_DAYS_TO_HOURS';