APPS.BEN_EXTRACT_SEED dependencies on FF_FORMULAS_F

Line 431: from ff_formulas_f

427:
428:
429:
430: cursor c8 is select formula_name
431: from ff_formulas_f
432: where --nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
433: -- = nvl(p_legislation_code,'~~nvl~~')
434: -- and nvl(business_group_id,nvl(p_business_group_id,-1))
435: -- = nvl(p_business_group_id,-1) and

Line 1195: from ff_formulas_f

1191: and full_name||' '||national_identifier||' '||employee_number = p_meaning
1192: and full_name like SUBSTR(p_meaning,1, INSTR(p_meaning,' ')-1)||'%'; -- 4300295. Perf fix.
1193:
1194: cursor c8 is select formula_id --formula_name
1195: from ff_formulas_f
1196: where --nvl(legislation_code,nvl(p_legislation_code,'~~nvl~~'))
1197: -- = nvl(p_legislation_code,'~~nvl~~')
1198: -- and nvl(business_group_id,nvl(p_business_group_id,-1))
1199: -- = nvl(p_business_group_id,-1) and

Line 2593: FROM ff_formulas_f

2589: CURSOR c_dt_rule(p_data_elmt_rl VARCHAR2
2590: ,l_new_business_group_id NUMBER
2591: ,l_last_update_date in date ) IS
2592: SELECT formula_id
2593: FROM ff_formulas_f
2594: WHERE formula_name = p_data_elmt_rl
2595: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
2596: AND nvl(l_last_update_date,trunc(sysdate)) BETWEEN effective_start_date and effective_end_date ;
2597: --

Line 4441: FROM ff_formulas_f

4437: l_ext_post_prcs_rl := NULL;
4438: ELSE
4439: SELECT formula_id
4440: INTO l_ext_post_prcs_rl
4441: FROM ff_formulas_f
4442: WHERE formula_name = p_post_processing_rule
4443: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4444: AND trunc(sysdate) BETWEEN effective_start_date and effective_end_date ;
4445: END IF;