DBA Data[Home] [Help]

APPS.BEN_SEED_LIFE_EVENTS dependencies on BEN_LER_F_TL

Line 96: insert into ben_ler_f_tl (

92: -- from the above select statement to make it lesser restrictive.
93: --
94: -- Insert into MLS table.
95: --
96: insert into ben_ler_f_tl (
97: ler_id,
98: effective_start_date,
99: effective_end_date,
100: typ_cd,

Line 128: from ben_ler_f_tl t

124: where b.business_group_id = p_business_group_id
125: and b.typ_cd = tl.typ_cd
126: and not exists
127: (select 'Y'
128: from ben_ler_f_tl t
129: where t.ler_id = b.ler_id
130: and t.effective_start_date = b.effective_start_date
131: and t.source_lang = userenv('LANG'));
132: