DBA Data[Home] [Help]

APPS.BEN_LPE_BUS dependencies on PER_BUSINESS_GROUPS

Line 119: per_business_groups pbg

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

Line 428: per_business_groups pbg

424: --
425: cursor c1 is
426: select null
427: from ff_formulas_f ff,
428: per_business_groups pbg
429: where ff.formula_id = p_enrt_rl
430: and ff.formula_type_id = - 393
431: and pbg.business_group_id = p_business_group_id
432: and nvl(ff.business_group_id, p_business_group_id) =

Line 595: per_business_groups pbg

591: --
592: cursor c1 is
593: select null
594: from ff_formulas_f ff,
595: per_business_groups pbg
596: where ff.formula_id = p_dflt_enrt_rl
597: and ff.formula_type_id = - 32
598: and pbg.business_group_id = p_business_group_id
599: and nvl(ff.business_group_id, p_business_group_id) =

Line 1305: from per_business_groups a,

1301: -- Declare cursor
1302: --
1303: cursor csr_leg_code is
1304: select a.legislation_code
1305: from per_business_groups a,
1306: ben_ler_chg_pl_nip_enrt_f b
1307: where b.ler_chg_pl_nip_enrt_id = p_ler_chg_pl_nip_enrt_id
1308: and a.business_group_id = b.business_group_id;
1309: --