APPS.HR_HEAD_COUNT dependencies on FF_FORMULAS_F

Line 672: from ff_formulas_f

668: cursor c_get_PerType_formula
669: (p_business_group_id NUMBER )
670: is
671: select formula_id
672: from ff_formulas_f
673: where p_business_group_id = business_group_id+0
674: and trunc(sysdate) between effective_start_date and effective_end_date
675: and formula_name = 'HR_PERSON_TYPE'
676: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

Line 680: from ff_formulas_f

676: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
677:
678: cursor c_get_tmplt_PerType_formula is
679: select formula_id
680: from ff_formulas_f
681: where business_group_id+0 is null
682: and trunc(sysdate) between effective_start_date and effective_end_date
683: and formula_name = 'HR_PERSON_TYPE_TEMPLATE'
684: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

Line 690: from ff_formulas_f

686: cursor c_get_term_formula
687: (p_business_group_id NUMBER )
688: is
689: select formula_id
690: from ff_formulas_f
691: where business_group_id+0 = p_business_group_id
692: and trunc(sysdate) between effective_start_date and effective_end_date
693: and formula_name = 'HR_MOVE_TYPE'
694: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

Line 698: from ff_formulas_f

694: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');
695:
696: cursor c_get_tmplt_term_formula is
697: select formula_id
698: from ff_formulas_f
699: where business_group_id+0 is null
700: and trunc(sysdate) between effective_start_date and effective_end_date
701: and formula_name = 'HR_MOVE_TYPE_TEMPLATE'
702: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Oracle Payroll');

Line 708: from ff_formulas_f

704: cursor c_get_ABV_formula
705: ( p_business_group_id NUMBER )
706: is
707: select formula_id
708: from ff_formulas_f
709: where p_business_group_id = business_group_id+0
710: and trunc(sysdate) between effective_start_date and effective_end_date
711: and formula_name = 'BUDGET_'||p_budget
712: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');

Line 717: from ff_formulas_f

713:
714:
715: cursor c_get_tmplt_ABV_formula is
716: select formula_id
717: from ff_formulas_f
718: where business_group_id+0 is null
719: and trunc(sysdate) between effective_start_date and effective_end_date
720: and formula_name = 'TEMPLATE_'||p_budget
721: and formula_type_id = HR_PERSON_FLEX_LOGIC.GetFormulaTypeID('Quickpaint');