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:
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:
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
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;
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
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