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

Line 396: ben_oipl_f oipl

392:
393: CURSOR c3 IS
394: SELECT oipl.oipl_id
395: FROM ben_prtt_enrt_rslt_f bper,
396: ben_oipl_f oipl
397: WHERE bper.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
398: AND oipl.oipl_id = bper.oipl_id
399: AND oipl.pcp_dsgn_cd in ('R','O')
400: AND p_effective_date BETWEEN oipl.effective_start_date and oipl.effective_end_date

Line 407: ben_oipl_f oipl

403: CURSOR c4 IS
404: SELECT bper.prtt_enrt_rslt_id
405: FROM ben_elig_cvrd_dpnt_f becd,
406: ben_prtt_enrt_rslt_f bper,
407: ben_oipl_f oipl
408: WHERE becd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
409: AND becd.prtt_enrt_rslt_id = bper.prtt_enrt_rslt_id
410: AND bper.oipl_id = oipl.oipl_id
411: AND oipl.pcp_dpnt_dsgn_cd in ('R','O')