DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT_SUMMARY dependencies on FF_FORMULAS_F

Line 317: from ff_formulas_f

313: cursor c_get_ABV_formula
314: ( p_business_group_id NUMBER )
315: is
316: select formula_id
317: from ff_formulas_f
318: where p_business_group_id = business_group_id+0
319: and trunc(sysdate) between effective_start_date and effective_end_date
320: and formula_name = 'BUDGET_'||p_budget
321: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');

Line 326: from ff_formulas_f

322:
323:
324: cursor c_get_tmplt_ABV_formula is
325: select formula_id
326: from ff_formulas_f
327: where business_group_id+0 is null
328: and trunc(sysdate) between effective_start_date and effective_end_date
329: and formula_name = 'TEMPLATE_'||p_budget
330: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');