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_PRTT_ENRT_CTFN_PRVDD_API dependencies on BEN_PER_IN_LER

Line 231: from ben_per_in_ler pil,

227: cursor c_future_pils( p_person_id number,
228: p_business_group_id number,
229: p_lf_evt_ocrd_dt date ) is
230: select 1
231: from ben_per_in_ler pil,
232: ben_ler_f ler
233: where pil.business_group_id = p_business_group_id
234: and pil.person_id = p_person_id
235: and pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt

Line 249: from ben_per_in_ler pil1, ben_prtt_enrt_actn_f actn

245: cursor c_pil(p_PRTT_ENRT_ACTN_ID number) is
246: select pil1.lf_evt_ocrd_dt lf_evt_ocrd_dt,
247: pil1.person_id person_id,
248: pil1.business_group_id business_group_id
249: from ben_per_in_ler pil1, ben_prtt_enrt_actn_f actn
250: where pil1.per_in_ler_id = actn.per_in_ler_id
251: and actn.PRTT_ENRT_ACTN_ID = p_PRTT_ENRT_ACTN_ID
252: and p_effective_date
253: between actn.effective_start_date