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_RATE_CHG dependencies on BEN_PRTT_ENRT_RSLT_F

Line 405: from ben_prtt_enrt_rslt_f pen

401: pen.pen_attribute27,
402: pen.pen_attribute28,
403: pen.pen_attribute29,
404: pen.pen_attribute30
405: from ben_prtt_enrt_rslt_f pen
406: where pen.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id
407: and pen.person_id = p_person_id
408: and pen.sspndd_flag = 'N'
409: and ( (pen.enrt_ovridn_flag = 'N' ) OR

Line 416: and exists (select null from ben_prtt_enrt_rslt_f pen2

412: and pen.prtt_enrt_rslt_stat_cd is null
413: and l_effective_date -- Bug 3044116 p_effective_date
414: between pen.effective_start_date and pen.effective_end_date
415: --bug#3856424 - check for any deenrollment in future - defensive coding
416: and exists (select null from ben_prtt_enrt_rslt_f pen2
417: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
418: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
419: and pen2.effective_end_date = hr_api.g_eot)
420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results

Line 420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results

416: and exists (select null from ben_prtt_enrt_rslt_f pen2
417: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
418: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
419: and pen2.effective_end_date = hr_api.g_eot)
420: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
421: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
422: and pen3.sspndd_flag = 'Y'
423: and pen3.prtt_enrt_rslt_stat_cd is null
424: and pen3.enrt_cvg_thru_dt = hr_api.g_eot

Line 760: from ben_prtt_enrt_rslt_f

756: and epe.business_group_id = p_business_group_id;
757: --
758: cursor c_pen2 (p_prtt_enrt_rslt_id number) is
759: select enrt_mthd_cd
760: from ben_prtt_enrt_rslt_f
761: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
762: and prtt_enrt_rslt_stat_cd is null
763: and l_effective_date -- Bug 3044116 p_effective_date
764: between effective_start_date and effective_end_date;

Line 768: from ben_prtt_enrt_rslt_f pen,

764: between effective_start_date and effective_end_date;
765: --
766: cursor c_imputed_rslt is
767: select effective_start_date
768: from ben_prtt_enrt_rslt_f pen,
769: ben_elig_per_elctbl_chc epe
770: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
771: and epe.per_in_ler_id = p_per_in_ler_id
772: and epe.comp_lvl_cd = 'PLANIMP'