APPS.BEN_PRG_BUS dependencies on PER_BUSINESS_GROUPS

Line 265: ,per_business_groups pbg

261: --
262: cursor c1 is
263: select null
264: from ff_formulas_f ff
265: ,per_business_groups pbg
266: where ff.formula_id = p_hghly_compd_det_rl
267: and ff.formula_type_id = -31
268: and pbg.business_group_id = p_business_group_id
269: and nvl(ff.business_group_id, p_business_group_id) =

Line 357: ,per_business_groups pbg

353: --
354: cursor c1 is
355: select null
356: from ff_formulas_f ff
357: ,per_business_groups pbg
358: where ff.formula_id = p_key_ee_det_rl
359: and ff.formula_type_id = -39
360: and pbg.business_group_id = p_business_group_id
361: and nvl(ff.business_group_id, p_business_group_id) =

Line 449: ,per_business_groups pbg

445: --
446: cursor c1 is
447: select null
448: from ff_formulas_f ff
449: ,per_business_groups pbg
450: where ff.formula_id = p_cntr_nndscrn_rl
451: and ff.formula_type_id = -42
452: and pbg.business_group_id = p_business_group_id
453: and nvl(ff.business_group_id, p_business_group_id) =

Line 541: ,per_business_groups pbg

537: --
538: cursor c1 is
539: select null
540: from ff_formulas_f ff
541: ,per_business_groups pbg
542: where ff.formula_id = p_cvg_nndscrn_rl
543: and ff.formula_type_id = -41
544: and pbg.business_group_id = p_business_group_id
545: and nvl(ff.business_group_id, p_business_group_id) =

Line 633: ,per_business_groups pbg

629: --
630: cursor c1 is
631: select null
632: from ff_formulas_f ff
633: ,per_business_groups pbg
634: where ff.formula_id = p_five_pct_ownr_rl
635: and ff.formula_type_id = -154
636: and pbg.business_group_id = p_business_group_id
637: and nvl(ff.business_group_id, p_business_group_id) =

Line 1258: from per_business_groups a,

1254: -- Declare cursor
1255: --
1256: cursor csr_leg_code is
1257: select a.legislation_code
1258: from per_business_groups a,
1259: ben_pl_regn_f b
1260: where b.pl_regn_id = p_pl_regn_id
1261: and a.business_group_id = b.business_group_id;
1262: --

Line 1265: l_legislation_code per_business_groups.legislation_code%type; --varchar2(150);

1261: and a.business_group_id = b.business_group_id;
1262: --
1263: -- Declare local variables
1264: --
1265: l_legislation_code per_business_groups.legislation_code%type; --varchar2(150);
1266: l_proc varchar2(72) := g_package||'return_legislation_code';
1267: --
1268: begin
1269: --