APPS.HR_PERSON_FLEX_LOGIC dependencies on FF_FORMULAS_F

Line 364: FROM ff_formulas_f

360:
361: CURSOR c_term_formula
362: IS
363: SELECT formula_id
364: FROM ff_formulas_f
365: WHERE business_group_id+0 = p_business_group_id
366: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
367: AND formula_name = 'HR_MOVE_TYPE';
368:

Line 372: FROM ff_formulas_f

368:
369: CURSOR c_tmplt_term_formula
370: IS
371: SELECT formula_id
372: FROM ff_formulas_f
373: WHERE business_group_id+0 is null
374: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
375: AND formula_name = 'HR_MOVE_TYPE_TEMPLATE';
376:

Line 893: from ff_formulas_f

889: ( p_formula_id in Number )
890: IS
891: cursor fast_formula_csr is
892: select formula_name
893: from ff_formulas_f
894: where formula_id = p_formula_id;
895:
896: l_formula_name ff_formulas_f.formula_name%type := null;
897: BEGIN

Line 896: l_formula_name ff_formulas_f.formula_name%type := null;

892: select formula_name
893: from ff_formulas_f
894: where formula_id = p_formula_id;
895:
896: l_formula_name ff_formulas_f.formula_name%type := null;
897: BEGIN
898: open fast_formula_csr;
899: fetch fast_formula_csr into l_formula_name;
900: close fast_formula_csr;

Line 964: FROM ff_formulas_f

960:
961: CURSOR c_formula
962: IS
963: SELECT formula_id
964: FROM ff_formulas_f
965: WHERE business_group_id+0 = p_business_group_id
966: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
967: AND formula_name = p_formula_name
968: AND formula_type_id

Line 974: FROM ff_formulas_f

970:
971: CURSOR c_tmplt_formula
972: IS
973: SELECT formula_id
974: FROM ff_formulas_f
975: WHERE business_group_id+0 is null
976: AND SYSDATE BETWEEN effective_start_date AND effective_end_date
977: AND formula_name = p_formula_name||'_TEMPLATE'
978: AND formula_type_id