DBA Data[Home] [Help]

APPS.BEN_RCL_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_rltd_per_chg_cs_ler_rl
120: and ff.formula_type_id = -168 -- Person Information Causes Life Event
121: and pbg.business_group_id = p_business_group_id
122: and nvl(ff.business_group_id, p_business_group_id) = p_business_group_id

Line 774: from per_business_groups a,

770: -- Declare cursor
771: --
772: cursor csr_leg_code is
773: select a.legislation_code
774: from per_business_groups a,
775: ben_rltd_per_chg_cs_ler_f b
776: where b.rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
777: and a.business_group_id = b.business_group_id;
778: --