APPS.BEN_PGM_BUS dependencies on PER_BUSINESS_GROUPS

Line 118: per_business_groups pbg

114: --
115: cursor c1 is
116: select null
117: from ff_formulas_f ff ,
118: per_business_groups pbg
119: where ff.formula_id = p_auto_enrt_mthd_rl
120: and ff.formula_type_id = -146
121: and pbg.business_group_id = p_business_group_id
122: and nvl(ff.business_group_id, p_business_group_id) =

Line 263: per_business_groups pbg

259: --
260: cursor c1 is
261: select null
262: from ff_formulas_f ff ,
263: per_business_groups pbg
264: where ff.formula_id = p_enrt_rl
265: and ff.formula_type_id = -393
266: and pbg.business_group_id = p_business_group_id
267: and nvl(ff.business_group_id, p_business_group_id) =

Line 356: per_business_groups pbg

352: --
353: cursor c1 is
354: select null
355: from ff_formulas_f ff ,
356: per_business_groups pbg
357: where ff.formula_id = p_enrt_cvg_strt_dt_rl
358: and ff.formula_type_id = -29
359: and pbg.business_group_id = p_business_group_id
360: 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_enrt_cvg_end_dt_rl
451: and ff.formula_type_id = -30
452: and pbg.business_group_id = p_business_group_id
453: and nvl(ff.business_group_id, p_business_group_id) =

Line 649: per_business_groups pbg

645: --
646: cursor c1 is
647: select null
648: from ff_formulas_f ff ,
649: per_business_groups pbg
650: where ff.formula_id = p_dpnt_cvg_strt_dt_rl
651: and ff.formula_type_id = -27
652: and pbg.business_group_id = p_business_group_id
653: and nvl(ff.business_group_id, p_business_group_id) =

Line 741: per_business_groups pbg

737: --
738: cursor c1 is
739: select null
740: from ff_formulas_f ff ,
741: per_business_groups pbg
742: where ff.formula_id = p_rt_end_dt_rl
743: and ff.formula_type_id = -67
744: and pbg.business_group_id = p_business_group_id
745: and nvl(ff.business_group_id, p_business_group_id) =

Line 835: per_business_groups pbg

831: --
832: cursor c1 is
833: select null
834: from ff_formulas_f ff ,
835: per_business_groups pbg
836: where ff.formula_id = p_rt_strt_dt_rl
837: and ff.formula_type_id = -66
838: and pbg.business_group_id = p_business_group_id
839: and nvl(ff.business_group_id, p_business_group_id) =

Line 930: per_business_groups pbg

926: --
927: cursor c1 is
928: select null
929: from ff_formulas_f ff ,
930: per_business_groups pbg
931: where ff.formula_id = p_dpnt_cvg_end_dt_rl
932: and ff.formula_type_id = -28
933: and pbg.business_group_id = p_business_group_id
934: 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_prtn_end_dt_rl
1025: and ff.formula_type_id = -83
1026: and pbg.business_group_id = p_business_group_id
1027: and nvl(ff.business_group_id, p_business_group_id) =

Line 1116: per_business_groups pbg

1112: --
1113: cursor c1 is
1114: select null
1115: from ff_formulas_f ff ,
1116: per_business_groups pbg
1117: where ff.formula_id = p_prtn_strt_dt_rl
1118: and ff.formula_type_id = -82
1119: and pbg.business_group_id = p_business_group_id
1120: and nvl(ff.business_group_id, p_business_group_id) =

Line 3941: per_business_groups pbg

3937: --
3938: cursor c1(p_rule number,p_rule_type_id number) is
3939: select null
3940: from ff_formulas_f ff,
3941: per_business_groups pbg
3942: where ff.formula_id = p_rule
3943: and ff.formula_type_id = p_rule_type_id
3944: and pbg.business_group_id = p_business_group_id
3945: and nvl(ff.business_group_id,p_business_group_id) =

Line 7274: from per_business_groups a,

7270: -- Declare cursor
7271: --
7272: cursor csr_leg_code is
7273: select a.legislation_code
7274: from per_business_groups a,
7275: ben_pgm_f b
7276: where b.pgm_id = p_pgm_id
7277: and a.business_group_id = b.business_group_id;
7278: --