APPS.BEN_ENP_BUS dependencies on FF_FORMULAS_F

Line 548: from ff_formulas_f ff ,

544: l_dummy varchar2(1);
545: --
546: cursor c1 is
547: select null
548: from ff_formulas_f ff ,
549: per_business_groups pbg
550: where ff.formula_id = p_rt_end_dt_rl
551: and ff.formula_type_id = -67 /*default enrollment det */
552: and pbg.business_group_id = p_business_group_id

Line 928: from ff_formulas_f ff ,

924: l_dummy varchar2(1);
925: --
926: cursor c1 is
927: select null
928: from ff_formulas_f ff ,
929: per_business_groups pbg
930: where ff.formula_id = p_enrt_cvg_end_dt_rl
931: and ff.formula_type_id = -30 /*default enrollment det */
932: and pbg.business_group_id = p_business_group_id

Line 1022: from ff_formulas_f ff ,

1018: l_dummy varchar2(1);
1019: --
1020: cursor c1 is
1021: select null
1022: from ff_formulas_f ff ,
1023: per_business_groups pbg
1024: where ff.formula_id = p_enrt_cvg_strt_dt_rl
1025: and ff.formula_type_id = -29 /*default enrollment det */
1026: and pbg.business_group_id = p_business_group_id

Line 1184: from ff_formulas_f ff

1180: l_dummy varchar2(1);
1181: --
1182: cursor c1 is
1183: select null
1184: from ff_formulas_f ff
1185: ,per_business_groups pbg
1186: where ff.formula_id = p_rt_strt_dt_rl
1187: and ff.formula_type_id = -66
1188: and pbg.business_group_id = p_business_group_id

Line 1485: from ff_formulas_f ff ,

1481:
1482:
1483: cursor c_hrchy_rl is
1484: select 'x'
1485: from ff_formulas_f ff ,
1486: per_business_groups pbg
1487: where ff.formula_id = p_hrchy_rl
1488: and ff.formula_type_id = -550 /*default enrollment det */
1489: and nvl(ff.legislation_code, pbg.legislation_code) = pbg.legislation_code