APPS.BEN_BPP_BUS dependencies on PER_BUSINESS_GROUPS

Line 585: per_business_groups pbg

581: --
582: cursor c1 is
583: select null
584: from ff_formulas_f ff ,
585: per_business_groups pbg
586: where ff.formula_id = p_val_rndg_rl
587: and ff.formula_type_id = -169 /*default enrollment det */
588: and pbg.business_group_id = p_business_group_id
589: and nvl(ff.business_group_id, p_business_group_id) =

Line 751: per_business_groups pbg

747: --
748: cursor c1 is
749: select null
750: from ff_formulas_f ff ,
751: per_business_groups pbg
752: where ff.formula_id = p_pct_rndg_rl
753: and ff.formula_type_id = -169 /*default enrollment det */
754: and pbg.business_group_id = p_business_group_id
755: and nvl(ff.business_group_id, p_business_group_id) =

Line 1741: ,per_business_groups pbg

1737: --
1738: cursor c1 is
1739: select null
1740: from ff_formulas_f ff
1741: ,per_business_groups pbg
1742: where ff.formula_id = p_dflt_excs_trtmt_rl
1743: and ff.formula_type_id = -533
1744: and pbg.business_group_id = p_business_group_id
1745: and nvl(ff.business_group_id, p_business_group_id) =

Line 2622: from per_business_groups a,

2618: -- Declare cursor
2619: --
2620: cursor csr_leg_code is
2621: select a.legislation_code
2622: from per_business_groups a,
2623: ben_bnft_prvdr_pool_f b
2624: where b.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
2625: and a.business_group_id = b.business_group_id;
2626: --