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

Line 1338: and not exists (select null from ben_prtt_enrt_rslt_f pen

1334: and (p_pgm_id is NULL or epe.pgm_id = p_pgm_id)
1335: and (p_pl_nip_id is null
1336: or (p_pl_nip_id = epe.pl_id and epe.pgm_id is NULL) )
1337: and (epe.dflt_flag = 'Y' or epe.crntly_enrd_flag = 'Y')
1338: and not exists (select null from ben_prtt_enrt_rslt_f pen
1339: where pen.per_in_ler_id = epe.per_in_ler_id
1340: -- Bug 6319484 Instead of checking for same pen_id,
1341: -- check if not already enrolled in same plan
1342: and nvl(pen.pgm_id,hr_api.g_number) = nvl(epe.pgm_id,hr_api.g_number)

Line 1394: From ben_prtt_enrt_rslt_f

1390: ,enrt_cvg_thru_dt
1391: ,ERLST_DEENRT_DT
1392: ,enrt_ovrid_thru_dt
1393: ,enrt_ovridn_flag
1394: From ben_prtt_enrt_rslt_f
1395: Where prtt_enrt_rslt_id = lc_prtt_enrt_rslt_id
1396: and p_effective_date between
1397: effective_start_date and effective_end_date
1398: and prtt_enrt_rslt_stat_cd IS NULL