APPS.BEN_EXTRACT_SEED dependencies on FF_FORMULAS_F

Line 378: from ff_formulas_f

374:
375:
376:
377: cursor c8 is select formula_name
378: from ff_formulas_f
379: where --nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
380: -- = nvl(p_legislation_code,'~~nvl~~')
381: -- and nvl(business_group_id,nvl(p_business_group_id,-1))
382: -- = nvl(p_business_group_id,-1) and

Line 1142: from ff_formulas_f

1138: and full_name||' '||national_identifier||' '||employee_number = p_meaning
1139: and full_name like SUBSTR(p_meaning,1, INSTR(p_meaning,' ')-1)||'%'; -- 4300295. Perf fix.
1140:
1141: cursor c8 is select formula_id --formula_name
1142: from ff_formulas_f
1143: where --nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
1144: -- = nvl(p_legislation_code,'~~nvl~~')
1145: -- and nvl(business_group_id,nvl(p_business_group_id,-1))
1146: -- = nvl(p_business_group_id,-1) and

Line 2537: FROM ff_formulas_f

2533: CURSOR c_dt_rule(p_data_elmt_rl VARCHAR2
2534: ,l_new_business_group_id NUMBER
2535: ,l_last_update_date in date ) IS
2536: SELECT formula_id
2537: FROM ff_formulas_f
2538: WHERE formula_name = p_data_elmt_rl
2539: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
2540: AND nvl(l_last_update_date,trunc(sysdate)) BETWEEN effective_start_date and effective_end_date ;
2541: --

Line 4385: FROM ff_formulas_f

4381: l_ext_post_prcs_rl := NULL;
4382: ELSE
4383: SELECT formula_id
4384: INTO l_ext_post_prcs_rl
4385: FROM ff_formulas_f
4386: WHERE formula_name = p_post_processing_rule
4387: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4388: AND trunc(sysdate) BETWEEN effective_start_date and effective_end_date ;
4389: END IF;