APPS.BEN_LDC_BUS dependencies on PER_BUSINESS_GROUPS

Line 209: ,per_business_groups pbg

205: --
206: cursor c1 is
207: select null
208: from ff_formulas_f ff
209: ,per_business_groups pbg
210: where ff.formula_id = p_cvg_eff_end_rl
211: and ff.formula_type_id = -28 --Dependent Coverage End
212: and pbg.business_group_id = p_business_group_id
213: and nvl(ff.business_group_id, p_business_group_id) =

Line 302: ,per_business_groups pbg

298: --
299: cursor c1 is
300: select null
301: from ff_formulas_f ff
302: ,per_business_groups pbg
303: where ff.formula_id = p_cvg_eff_strt_rl
304: and ff.formula_type_id = -27 --Dependent Coverage Start
305: and pbg.business_group_id = p_business_group_id
306: and nvl(ff.business_group_id, p_business_group_id) =

Line 395: ,per_business_groups pbg

391: --
392: cursor c1 is
393: select null
394: from ff_formulas_f ff
395: ,per_business_groups pbg
396: where ff.formula_id = p_ler_chg_dpnt_cvg_rl
397: and ff.formula_type_id = -36 --Change Dependent Coverage
398: and pbg.business_group_id = p_business_group_id
399: and nvl(ff.business_group_id, p_business_group_id) =

Line 1628: from per_business_groups a,

1624: -- Declare cursor
1625: --
1626: cursor csr_leg_code is
1627: select a.legislation_code
1628: from per_business_groups a,
1629: ben_ler_chg_dpnt_cvg_f b
1630: where b.ler_chg_dpnt_cvg_id = p_ler_chg_dpnt_cvg_id
1631: and a.business_group_id = b.business_group_id;
1632: --