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 381: from ben_prtt_enrt_rslt_f pen

377: pen.pen_attribute27,
378: pen.pen_attribute28,
379: pen.pen_attribute29,
380: pen.pen_attribute30
381: from ben_prtt_enrt_rslt_f pen
382: where pen.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id
383: and pen.person_id = p_person_id
384: and pen.sspndd_flag = 'N'
385: and ( (pen.enrt_ovridn_flag = 'N' ) OR

Line 392: and exists (select null from ben_prtt_enrt_rslt_f pen2

388: and pen.prtt_enrt_rslt_stat_cd is null
389: and l_effective_date -- Bug 3044116 p_effective_date
390: between pen.effective_start_date and pen.effective_end_date
391: --bug#3856424 - check for any deenrollment in future - defensive coding
392: and exists (select null from ben_prtt_enrt_rslt_f pen2
393: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
394: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
395: and pen2.effective_end_date = hr_api.g_eot)
396: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results

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

392: and exists (select null from ben_prtt_enrt_rslt_f pen2
393: where pen2.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
394: and pen2.enrt_cvg_thru_dt = hr_api.g_eot
395: and pen2.effective_end_date = hr_api.g_eot)
396: and not exists ( select 'x' from ben_prtt_enrt_rslt_f pen3 --Bug 5617091 exclude interim results
397: where pen3.rplcs_sspndd_rslt_id= pen.prtt_enrt_rslt_id
398: and pen3.sspndd_flag = 'Y'
399: and pen3.prtt_enrt_rslt_stat_cd is null
400: and pen3.enrt_cvg_thru_dt = hr_api.g_eot

Line 712: from ben_prtt_enrt_rslt_f

708: and epe.business_group_id = p_business_group_id;
709: --
710: cursor c_pen2 (p_prtt_enrt_rslt_id number) is
711: select enrt_mthd_cd
712: from ben_prtt_enrt_rslt_f
713: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
714: and prtt_enrt_rslt_stat_cd is null
715: and l_effective_date -- Bug 3044116 p_effective_date
716: between effective_start_date and effective_end_date;

Line 720: from ben_prtt_enrt_rslt_f pen,

716: between effective_start_date and effective_end_date;
717: --
718: cursor c_imputed_rslt is
719: select effective_start_date
720: from ben_prtt_enrt_rslt_f pen,
721: ben_elig_per_elctbl_chc epe
722: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
723: and epe.per_in_ler_id = p_per_in_ler_id
724: and epe.comp_lvl_cd = 'PLANIMP'