APPS.BEN_ENP_BUS dependencies on PER_BUSINESS_GROUPS

Line 549: per_business_groups pbg

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
553: and nvl(ff.business_group_id, p_business_group_id) =

Line 929: per_business_groups pbg

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
933: and nvl(ff.business_group_id, p_business_group_id) =

Line 1023: per_business_groups pbg

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
1027: and nvl(ff.business_group_id, p_business_group_id) =

Line 1185: ,per_business_groups pbg

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
1189: and nvl(ff.business_group_id, p_business_group_id) =

Line 1486: per_business_groups pbg

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
1490: and p_effective_date between ff.effective_start_date and ff.effective_end_date;

Line 2829: from per_business_groups a,

2825: -- Declare cursor
2826: --
2827: cursor csr_leg_code is
2828: select a.legislation_code
2829: from per_business_groups a,
2830: ben_enrt_perd b
2831: where b.enrt_perd_id = p_enrt_perd_id
2832: and a.business_group_id = b.business_group_id;
2833: --