DBA Data[Home] [Help]

APPS.BEN_LPL_BUS dependencies on PER_BUSINESS_GROUPS

Line 237: ,per_business_groups pbg

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

Line 940: from per_business_groups a,

936: -- Declare cursor
937: --
938: cursor csr_leg_code is
939: select a.legislation_code
940: from per_business_groups a,
941: ben_ler_per_info_cs_ler_f b
942: where b.ler_per_info_cs_ler_id = p_ler_per_info_cs_ler_id
943: and a.business_group_id = b.business_group_id;
944: --