DBA Data[Home] [Help]

APPS.BEN_EXT_CONTACT dependencies on BEN_LER_F

Line 269: from ben_ler_f ler

265: and p_effective_date between pen.effective_start_date and pen.effective_end_date;
266:
267: cursor c_start_ler (p_start_life_reason_id number) is
268: select name
269: from ben_ler_f ler
270: where ler_id = p_start_life_reason_id
271: and p_effective_date between ler.effective_start_date and ler.effective_end_date;
272:
273: cursor c_end_ler (p_end_life_reason_id number) is

Line 275: from ben_ler_f ler

271: and p_effective_date between ler.effective_start_date and ler.effective_end_date;
272:
273: cursor c_end_ler (p_end_life_reason_id number) is
274: select name
275: from ben_ler_f ler
276: where ler_id = p_end_life_reason_id
277: and p_effective_date between ler.effective_start_date and ler.effective_end_date;
278:
279: --