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_CARRY_FORWARD_ITEMS dependencies on BEN_OIPL_F

Line 346: from ben_oipl_f oipl

342: pl.effective_end_date ;
343: --
344: cursor c_opt is
345: select opt_id
346: from ben_oipl_f oipl
347: where oipl.oipl_id = p_oipl_id
348: and p_effective_date between
349: oipl.effective_start_date and
350: oipl.effective_end_date ;

Line 363: ben_oipl_f oipl

359: --
360: cursor c_previous_ptip_oipl_result is
361: select pen.prtt_enrt_rslt_id,pen.ENRT_CVG_STRT_DT ,pen.per_in_ler_id
362: from ben_prtt_enrt_rslt_f pen,
363: ben_oipl_f oipl
364: where oipl.oipl_id = pen.oipl_id
365: and pen.pl_typ_id = l_pl_typ_id
366: and oipl.opt_id = l_opt_id
367: and pen.person_id = p_person_id

Line 390: ben_oipl_f oipl

386:
387: cursor c_previous_pl_oipl_result is
388: select pen.prtt_enrt_rslt_id,pen.ENRT_CVG_STRT_DT ,pen.per_in_ler_id
389: from ben_prtt_enrt_rslt_f pen,
390: ben_oipl_f oipl
391: where oipl.oipl_id = pen.oipl_id
392: and pen.pl_typ_id = l_pl_typ_id
393: and oipl.opt_id = l_opt_id
394: and pen.person_id = p_person_id

Line 509: from ben_oipl_f

505: or
506: (r.oipl_id = p_oipl_id)
507: or
508: (r.opt_id = (select opt_id
509: from ben_oipl_f
510: where oipl_id = p_oipl_id
511: and p_effective_date between effective_start_date
512: and effective_end_date
513: and business_group_id = p_business_group_id)))