DBA Data[Home] [Help]

APPS.BEN_LRC_BUS dependencies on PER_BUSINESS_GROUPS

Line 235: ,per_business_groups pbg

231: --
232: cursor c1 is
233: select null
234: from ff_formulas_f ff
235: ,per_business_groups pbg
236: where ff.formula_id = p_ler_rltd_per_cs_chg_rl
237: and ff.formula_type_id = -168 -- Person Information Causes Life Event
238: and pbg.business_group_id = p_business_group_id
239: and nvl(ff.business_group_id, p_business_group_id) = p_business_group_id

Line 653: from per_business_groups a,

649: -- Declare cursor
650: --
651: cursor csr_leg_code is
652: select a.legislation_code
653: from per_business_groups a,
654: ben_ler_rltd_per_cs_ler_f b
655: where b.ler_rltd_per_cs_ler_id = p_ler_rltd_per_cs_ler_id
656: and a.business_group_id = b.business_group_id;
657: --