APPS.BEN_BPR_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
588: and pbg.business_group_id = p_business_group_id
589: and nvl(ff.business_group_id, p_business_group_id) =

Line 820: per_business_groups pbg

816: --
817: cursor c1 is
818: select null
819: from ff_formulas_f ff ,
820: per_business_groups pbg
821: where ff.formula_id = p_rlovr_val_rl
822: and ff.formula_type_id = -532 /* */
823: and pbg.business_group_id = p_business_group_id
824: and nvl(ff.business_group_id, p_business_group_id) =

Line 1197: per_business_groups pbg

1193: --
1194: cursor c1 is
1195: select null
1196: from ff_formulas_f ff ,
1197: per_business_groups pbg
1198: where ff.formula_id = p_pct_rndg_rl
1199: and ff.formula_type_id = -169 /*default enrollment det */
1200: and pbg.business_group_id = p_business_group_id
1201: and nvl(ff.business_group_id, p_business_group_id) =

Line 1292: ,per_business_groups pbg

1288: --
1289: cursor c1 is
1290: select null
1291: from ff_formulas_f ff
1292: ,per_business_groups pbg
1293: where ff.formula_id = p_prtt_elig_rlovr_rl
1294: and ff.formula_type_id = -294
1295: and pbg.business_group_id = p_business_group_id
1296: and nvl(ff.business_group_id, p_business_group_id) =

Line 1935: from per_business_groups a,

1931: -- Declare cursor
1932: --
1933: cursor csr_leg_code is
1934: select a.legislation_code
1935: from per_business_groups a,
1936: ben_bnft_pool_rlovr_rqmt_f b
1937: where b.bnft_pool_rlovr_rqmt_id = p_bnft_pool_rlovr_rqmt_id
1938: and a.business_group_id = b.business_group_id;
1939: --