APPS.HRI_BPL_ABV dependencies on FF_FORMULAS_F

Line 85: FROM ff_formulas_f fff

81: -- The customer formula is called 'BUDGET_'
82: --
83: CURSOR customer_formula_csr IS
84: SELECT fff.formula_id
85: FROM ff_formulas_f fff
86: WHERE fff.formula_type_id = g_formula_type_id
87: AND fff.business_group_id = p_business_group_id
88: AND trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
89: AND fff.formula_name = 'BUDGET_' || p_budget_type;

Line 95: FROM ff_formulas_f fff

91: -- The template formula is called 'TEMPLATE_'
92: --
93: CURSOR template_formula_csr IS
94: SELECT fff.formula_id
95: FROM ff_formulas_f fff
96: WHERE fff.formula_type_id = g_formula_type_id
97: AND fff.business_group_id IS NULL
98: AND trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
99: AND fff.formula_name = 'TEMPLATE_' || p_budget_type;

Line 105: FROM ff_formulas_f fff

101: -- The customer formula is called 'GLOBAL_BUDGET_'
102: --
103: CURSOR global_formula_csr IS
104: SELECT fff.formula_id
105: FROM ff_formulas_f fff
106: WHERE fff.formula_type_id = g_formula_type_id
107: AND fff.business_group_id = 0
108: AND trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date
109: AND fff.formula_name = 'GLOBAL_BUDGET_' || p_budget_type;

Line 416: FROM ff_formulas_f

412: IS
413:
414: CURSOR fast_formula_csr IS
415: SELECT formula_name
416: FROM ff_formulas_f
417: WHERE formula_id = p_formula_id;
418:
419: l_formula_name ff_formulas_f.formula_name%TYPE := NULL;
420:

Line 419: l_formula_name ff_formulas_f.formula_name%TYPE := NULL;

415: SELECT formula_name
416: FROM ff_formulas_f
417: WHERE formula_id = p_formula_id;
418:
419: l_formula_name ff_formulas_f.formula_name%TYPE := NULL;
420:
421: BEGIN
422:
423: /* Get the formula name */

Line 457: ,ff_formulas_f fff

453:
454: CURSOR compiled_csr IS
455: SELECT fci.formula_id
456: FROM ff_compiled_info_f fci
457: ,ff_formulas_f fff
458: WHERE fci.formula_id = fff.formula_id
459: AND fff.formula_type_id = g_formula_type_id
460: AND fff.formula_name = p_formula_name
461: AND trunc(sysdate) BETWEEN fff.effective_start_date AND fff.effective_end_date

Line 516: FROM ff_formulas_f

512: FROM ff_formula_types
513: WHERE formula_type_name = 'QuickPaint';
514:
515: SELECT formula_id INTO g_template_head_id
516: FROM ff_formulas_f
517: WHERE formula_type_id = g_formula_type_id
518: AND formula_name = 'TEMPLATE_HEAD'
519: AND business_group_id IS NULL
520: AND trunc(sysdate) BETWEEN effective_start_date AND effective_end_date;