eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_PER_IN_LER

Line 126: from ben_per_in_ler pil,

122:
123: cursor c_per_in_ler is
124: select pil.lf_evt_ocrd_dt,
125: pil.ler_id
126: from ben_per_in_ler pil,
127: ben_ler_f ler
128: where pil.person_id = p_person_id
129: and pil.business_group_id = l_business_group_id
130: and pil.per_in_ler_stat_cd = 'STRTD'

Line 251: ben_per_in_ler pil

247: pdp.effective_start_date,
248: pdp.cvg_strt_dt,
249: pdp.effective_end_date
250: from ben_elig_cvrd_dpnt_f pdp,
251: ben_per_in_ler pil
252: where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
253: and pdp.business_group_id = l_business_group_id
254: and pdp.dpnt_person_id = p_contact_person_id
255: and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)