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_REOPEN_ENDED_RESULTS dependencies on HR_API

Line 200: and pen.effective_end_date = hr_api.g_eot

196: select pen.*
197: from ben_prtt_enrt_rslt_f pen,
198: ben_elig_per_elctbl_chc epe
199: where pen.prtt_enrt_rslt_stat_cd is null
200: and pen.effective_end_date = hr_api.g_eot
201: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
202: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
203: and pen.per_in_ler_id <> p_per_in_ler_id -- 5365585 . result ended in the same life event will not be picked up .
204: and epe.per_in_ler_id = p_per_in_ler_id

Line 201: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

197: from ben_prtt_enrt_rslt_f pen,
198: ben_elig_per_elctbl_chc epe
199: where pen.prtt_enrt_rslt_stat_cd is null
200: and pen.effective_end_date = hr_api.g_eot
201: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
202: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
203: and pen.per_in_ler_id <> p_per_in_ler_id -- 5365585 . result ended in the same life event will not be picked up .
204: and epe.per_in_ler_id = p_per_in_ler_id
205: and epe.CRNTLY_ENRD_FLAG = 'Y'

Line 212: and susp.effective_end_date <> hr_api.g_eot

208: --Bug 5102337. we need to exclude interim enrollments being selected here.
209: and not exists ( select 'x'
210: from ben_prtt_enrt_rslt_f susp
211: where susp.RPLCS_SSPNDD_RSLT_ID = pen.prtt_enrt_rslt_id
212: and susp.effective_end_date <> hr_api.g_eot
213: and susp.prtt_enrt_rslt_stat_cd is null
214: and susp.enrt_cvg_thru_dt = hr_api.g_eot ) ;
215: -- bug#5345189
216: cursor c_future_results (p_person_id in number,

Line 214: and susp.enrt_cvg_thru_dt = hr_api.g_eot ) ;

210: from ben_prtt_enrt_rslt_f susp
211: where susp.RPLCS_SSPNDD_RSLT_ID = pen.prtt_enrt_rslt_id
212: and susp.effective_end_date <> hr_api.g_eot
213: and susp.prtt_enrt_rslt_stat_cd is null
214: and susp.enrt_cvg_thru_dt = hr_api.g_eot ) ;
215: -- bug#5345189
216: cursor c_future_results (p_person_id in number,
217: p_enrt_cvg_thru_dt in date,
218: p_pgm_id in number,

Line 228: and pen.effective_end_date = hr_api.g_eot

224: select pen.*
225: from ben_prtt_enrt_rslt_f pen,
226: ben_per_in_ler pil
227: where pen.person_id = p_person_id
228: and pen.effective_end_date = hr_api.g_eot
229: and pen.business_group_id = p_business_group_id
230: and pil.business_group_id = p_business_group_id
231: and pen.enrt_cvg_strt_dt > p_enrt_cvg_thru_dt
232: and pen.per_in_ler_id = pil.per_in_ler_id

Line 250: and pen.effective_end_date = hr_api.g_eot

246: select pen.*
247: from ben_prtt_enrt_rslt_f pen,
248: ben_per_in_ler pil
249: where pen.person_id = p_person_id
250: and pen.effective_end_date = hr_api.g_eot
251: and pen.business_group_id = p_business_group_id
252: and pil.business_group_id = p_business_group_id
253: and pen.enrt_cvg_strt_dt > p_enrt_cvg_thru_dt
254: and pen.per_in_ler_id = pil.per_in_ler_id

Line 282: where pen.effective_end_date = hr_api.g_eot

278: from ben_prtt_rt_val prv
279: where prv.prtt_enrt_rslt_id in
280: (select pen.prtt_enrt_rslt_id
281: from ben_prtt_enrt_rslt_f pen
282: where pen.effective_end_date = hr_api.g_eot
283: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
284: and pen.person_id = p_person_id
285: and pen.pgm_id <> p_pgm_id
286: and pen.enrt_cvg_thru_dt < p_lf_evt_ocrd_dt

Line 283: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

279: where prv.prtt_enrt_rslt_id in
280: (select pen.prtt_enrt_rslt_id
281: from ben_prtt_enrt_rslt_f pen
282: where pen.effective_end_date = hr_api.g_eot
283: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
284: and pen.person_id = p_person_id
285: and pen.pgm_id <> p_pgm_id
286: and pen.enrt_cvg_thru_dt < p_lf_evt_ocrd_dt
287: and pen.prtt_enrt_rslt_stat_cd is null

Line 302: where pen.effective_end_date = hr_api.g_eot

298: p_business_group_id number,
299: p_pgm_id number) is
300: select pen.*
301: from ben_prtt_enrt_rslt_f pen
302: where pen.effective_end_date = hr_api.g_eot
303: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
304: and pen.person_id = p_person_id
305: and pen.pgm_id <> p_pgm_id
306: and pen.pl_typ_id = p_pl_typ_id

Line 303: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

299: p_pgm_id number) is
300: select pen.*
301: from ben_prtt_enrt_rslt_f pen
302: where pen.effective_end_date = hr_api.g_eot
303: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
304: and pen.person_id = p_person_id
305: and pen.pgm_id <> p_pgm_id
306: and pen.pl_typ_id = p_pl_typ_id
307: and p_lf_evt_ocrd_dt between pen.enrt_cvg_strt_dt and

Line 320: where pen.effective_end_date = hr_api.g_eot

316: cursor c_pen (p_prtt_enrt_rslt_id number) is
317: select pen.effective_start_date,
318: pen.object_version_number
319: from ben_prtt_enrt_rslt_f pen
320: where pen.effective_end_date = hr_api.g_eot
321: and pen.prtt_enrt_rslt_stat_cd is null
322: and pen.business_group_id = p_business_group_id
323: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
324: --

Line 342: and prv.rt_end_dt <> hr_api.g_eot

338: p_per_in_ler_id number) is
339: select prv.*
340: from ben_prtt_rt_val prv
341: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
342: and prv.rt_end_dt <> hr_api.g_eot
343: and prv.ended_per_in_ler_id = p_per_in_ler_id
344: and prv.prtt_rt_val_stat_cd is null;
345: --
346: -- end 8896851

Line 377: where pen.effective_end_date = hr_api.g_eot

373: ,pen.person_id
374: from ben_prtt_enrt_rslt_f pen
375: ,ben_prtt_rt_val prv
376: ,ben_acty_base_rt_f abr
377: where pen.effective_end_date = hr_api.g_eot
378: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
379: and pen.prtt_enrt_rslt_stat_cd is null
380: and pen.person_id = p_person_id
381: and pen.business_group_id = p_business_group_id

Line 378: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

374: from ben_prtt_enrt_rslt_f pen
375: ,ben_prtt_rt_val prv
376: ,ben_acty_base_rt_f abr
377: where pen.effective_end_date = hr_api.g_eot
378: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
379: and pen.prtt_enrt_rslt_stat_cd is null
380: and pen.person_id = p_person_id
381: and pen.business_group_id = p_business_group_id
382: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 398: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'

394: ) is
395: select pen.*
396: from ben_prtt_enrt_rslt_f pen
397: ,ben_ptip_f ptip
398: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
399: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
400: and pen.prtt_enrt_rslt_stat_cd is null
401: and pen.person_id = p_person_id -- 318321
402: and pen.business_group_id = p_business_group_id -- 81545

Line 399: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'

395: select pen.*
396: from ben_prtt_enrt_rslt_f pen
397: ,ben_ptip_f ptip
398: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
399: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
400: and pen.prtt_enrt_rslt_stat_cd is null
401: and pen.person_id = p_person_id -- 318321
402: and pen.business_group_id = p_business_group_id -- 81545
403: and pen.ptip_id = p_ptip_id -- 54444

Line 1521: p_datetrack_mode => hr_api.g_correction,

1517: p_effective_end_date => l_effective_end_date,
1518: p_business_group_id => p_business_group_id,
1519: p_object_version_number => l_get_enrt_rslts_for_pen.object_version_number,
1520: p_effective_date => p_effective_date,
1521: p_datetrack_mode => hr_api.g_correction,
1522: p_multi_row_validate => FALSE,
1523: p_enrt_cvg_thru_dt => l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt - 1
1524: );
1525: end loop; -- c_get_enrt_rslts_for_pen