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.HRI_OPL_BEN_ELIG_ENRL dependencies on HR_API

Line 329: ORDER BY compobj_sk_pk, ee.change_date), hr_api.g_eot) effective_end_date,

325: (SELECT ee.change_date change_date,
326: ee.change_date effective_start_date,
327: NVL(LEAD(ee.change_date - 1)
328: OVER (PARTITION BY compobj_sk_pk
329: ORDER BY compobj_sk_pk, ee.change_date), hr_api.g_eot) effective_end_date,
330: ee.compobj_sk_pk,
331: p_pil_rec.lf_evt_ocrd_dt asnd_lf_evt_dt ,
332: p_pil_rec.person_id person_id,
333: p_pil_rec.per_in_ler_id per_in_ler_id,

Line 398: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

394: FROM ben_prtt_enrt_rslt_f pen
395: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
396: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
397: AND pen.prtt_enrt_rslt_stat_cd IS NULL
398: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
399: AND pen.effective_end_date = hr_api.g_eot
400: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
401: UNION ALL
402: -- Second Part of UNION brings all OIPLs

Line 399: AND pen.effective_end_date = hr_api.g_eot

395: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
396: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
397: AND pen.prtt_enrt_rslt_stat_cd IS NULL
398: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
399: AND pen.effective_end_date = hr_api.g_eot
400: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
401: UNION ALL
402: -- Second Part of UNION brings all OIPLs
403: SELECT pel.enrt_perd_strt_dt change_date,

Line 456: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

452: FROM ben_prtt_enrt_rslt_f pen
453: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
454: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
455: AND pen.prtt_enrt_rslt_stat_cd IS NULL
456: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
457: AND pen.effective_end_date = hr_api.g_eot
458: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
459: ) ee
460: );

Line 457: AND pen.effective_end_date = hr_api.g_eot

453: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
454: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
455: AND pen.prtt_enrt_rslt_stat_cd IS NULL
456: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
457: AND pen.effective_end_date = hr_api.g_eot
458: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
459: ) ee
460: );
461:

Line 543: ,hr_api.g_eot effective_end_date

539: ,DECODE(pil.per_in_ler_stat_cd,'PROCD',1,0) procd_ind
540: ,DECODE(pil.per_in_ler_stat_cd,'STRTD',1,0) strtd_ind
541: ,pil.lf_evt_ocrd_dt change_date
542: ,pil.lf_evt_ocrd_dt effective_start_date
543: ,hr_api.g_eot effective_end_date
544: ,pil.person_id person_id
545: ,pil.lf_evt_ocrd_dt asnd_lf_evt_dt
546: ,pel.enrt_perd_id enrt_perd_id
547: ,pil.per_in_ler_id per_in_ler_id

Line 641: ,hr_api.g_eot effective_end_date

637: ,DECODE(pelq.pil_elctbl_popl_stat_cd,'PROCD',1,0) procd_ind
638: ,DECODE(pelq.pil_elctbl_popl_stat_cd,'STRTD',1,NULL,1,0) strtd_ind
639: ,pelq.lf_evt_ocrd_dt change_date
640: ,pelq.lf_evt_ocrd_dt effective_start_date
641: ,hr_api.g_eot effective_end_date
642: ,pelq.person_id person_id
643: ,pelq.lf_evt_ocrd_dt asnd_lf_evt_dt
644: ,enpd.enrt_perd_id enrt_perd_id
645: ,pelq.per_in_ler_id per_in_ler_id

Line 702: ,pelc.effective_end_date = hr_api.g_eot

698: ,pelc.bckdt_ind = 0
699: ,pelc.procd_ind = 0
700: ,pelc.strtd_ind = 0
701: ,pelc.effective_start_date = l_pil_rec.lf_evt_ocrd_dt
702: ,pelc.effective_end_date = hr_api.g_eot
703: ,pelc.pil_elctbl_chc_popl_id = NULL
704: WHERE pelc.person_id = p_person_id
705: AND pelc.asnd_lf_evt_dt = l_pil_rec.lf_evt_ocrd_dt
706: AND pelc.per_in_ler_id = l_pil_rec.per_in_ler_id;

Line 811: FROM (SELECT NVL(MIN(penq.event_date-1),hr_api.g_eot) eee_end_dt,

807: ,p_lf_evt_ocrd_dt DATE) IS
808:
809: CURSOR c_eee_end_date IS
810: SELECT PRTTQ.eee_end_dt, penc.rowid row_id
811: FROM (SELECT NVL(MIN(penq.event_date-1),hr_api.g_eot) eee_end_dt,
812: copd.compobj_sk_pk,
813: penq.lf_evt_ocrd_dt
814: FROM hri_eq_ben_eligenrl_evts penq,
815: hri_cs_compobj_ct copd

Line 826: AND penc.effective_end_date = hr_api.g_eot

822: WHERE penc.asnd_lf_evt_dt = PRTTQ.lf_evt_ocrd_dt
823: AND penc.person_id = p_person_id
824: AND penc.per_in_ler_id = p_per_in_ler_id
825: AND (PRTTQ.eee_end_dt + 1) > penc.effective_start_date
826: AND penc.effective_end_date = hr_api.g_eot
827: AND PRTTQ.compobj_sk_pk = penc.compobj_sk_pk;
828:
829: l_eee_end_dt_tbl g_date_tab_type;
830: l_row_id_tbl g_rowid_tab_type;

Line 885: , hr_api.g_eot) effective_end_date

881: ,penq.event_date effective_start_date
882: ,NVL(LAG(penq.event_date-1)
883: OVER (PARTITION BY penq.lf_evt_ocrd_dt, copd.compobj_sk_pk
884: ORDER BY penq.lf_evt_ocrd_dt, copd.compobj_sk_pk, penq.event_date, penq.creation_date)
885: , hr_api.g_eot) effective_end_date
886: ,penq.person_id
887: ,penq.prtt_enrt_rslt_id
888: ,penq.per_in_ler_id
889: ,1 elig_ind

Line 1037: ORDER BY compobj_sk_pk, ee.change_date), hr_api.g_eot) effective_end_date,

1033: (SELECT ee.change_date change_date,
1034: ee.change_date effective_start_date,
1035: NVL(LEAD(ee.change_date - 1)
1036: OVER (PARTITION BY compobj_sk_pk
1037: ORDER BY compobj_sk_pk, ee.change_date), hr_api.g_eot) effective_end_date,
1038: ee.compobj_sk_pk,
1039: p_pil_rec.lf_evt_ocrd_dt asnd_lf_evt_dt ,
1040: p_pil_rec.person_id person_id,
1041: p_pil_rec.per_in_ler_id per_in_ler_id,

Line 1107: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

1103: FROM ben_prtt_enrt_rslt_f pen
1104: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1105: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1106: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1107: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1108: AND pen.effective_end_date = hr_api.g_eot
1109: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
1110: UNION ALL
1111: -- Second UNION gets OIPLs

Line 1108: AND pen.effective_end_date = hr_api.g_eot

1104: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1105: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1106: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1107: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1108: AND pen.effective_end_date = hr_api.g_eot
1109: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
1110: UNION ALL
1111: -- Second UNION gets OIPLs
1112: SELECT pel.enrt_perd_strt_dt change_date,

Line 1166: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

1162: FROM ben_prtt_enrt_rslt_f pen
1163: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1164: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1165: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1166: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1167: AND pen.effective_end_date = hr_api.g_eot
1168: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
1169: UNION ALL
1170: -- The 3rd and 4th UNIONs.. returns all Enrollment Results.

Line 1167: AND pen.effective_end_date = hr_api.g_eot

1163: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1164: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1165: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1166: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1167: AND pen.effective_end_date = hr_api.g_eot
1168: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
1169: UNION ALL
1170: -- The 3rd and 4th UNIONs.. returns all Enrollment Results.
1171: -- 3rd Union gets all PLIPs and OIPL IS NULL

Line 1208: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

1204: AND copd.oipl_id = -1
1205: AND pen.oipl_id IS NULL
1206: AND copd.pl_id = pen.pl_id
1207: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1208: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1209: AND pen.effective_end_date = hr_api.g_eot
1210: AND epe.prtt_enrt_rslt_id(+) = pen.prtt_enrt_rslt_id
1211: AND epe.per_in_ler_id(+) = pen.per_in_ler_id
1212: AND pln.pl_id = copd.pl_id

Line 1209: AND pen.effective_end_date = hr_api.g_eot

1205: AND pen.oipl_id IS NULL
1206: AND copd.pl_id = pen.pl_id
1207: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1208: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1209: AND pen.effective_end_date = hr_api.g_eot
1210: AND epe.prtt_enrt_rslt_id(+) = pen.prtt_enrt_rslt_id
1211: AND epe.per_in_ler_id(+) = pen.per_in_ler_id
1212: AND pln.pl_id = copd.pl_id
1213: AND p_pil_rec.lf_evt_ocrd_dt BETWEEN pln.effective_start_date

Line 1253: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

1249: AND pen.pgm_id = pel.pgm_id
1250: AND copd.oipl_id = pen.oipl_id
1251: AND copd.pl_id = pen.pl_id
1252: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1253: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1254: AND pen.effective_end_date = hr_api.g_eot
1255: AND epe.prtt_enrt_rslt_id(+) = pen.prtt_enrt_rslt_id
1256: AND epe.per_in_ler_id(+) = pen.per_in_ler_id
1257: AND opt.opt_id = copd.opt_id

Line 1254: AND pen.effective_end_date = hr_api.g_eot

1250: AND copd.oipl_id = pen.oipl_id
1251: AND copd.pl_id = pen.pl_id
1252: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1253: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
1254: AND pen.effective_end_date = hr_api.g_eot
1255: AND epe.prtt_enrt_rslt_id(+) = pen.prtt_enrt_rslt_id
1256: AND epe.per_in_ler_id(+) = pen.per_in_ler_id
1257: AND opt.opt_id = copd.opt_id
1258: AND p_pil_rec.lf_evt_ocrd_dt BETWEEN opt.effective_start_date