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

Line 43: and pen.enrt_cvg_thru_dt = hr_api.g_eot

39: ler.effective_start_date and ler.effective_end_date
40: and ((p_effective_date between
41: pen.effective_start_date and pen.effective_end_date)
42: or (p_lf_evt_ocrd_dt <= pen.effective_start_date)) -- 5741760: PEN recs on a Future date shud also be carried fwd.
43: and pen.enrt_cvg_thru_dt = hr_api.g_eot
44: and pen.effective_end_date = hr_api.g_eot;
45: l_pen_rec c_pen%rowtype;
46: --
47: cursor c_get_actn_items_sus(p_prtt_enrt_rslt_id number,

Line 44: and pen.effective_end_date = hr_api.g_eot;

40: and ((p_effective_date between
41: pen.effective_start_date and pen.effective_end_date)
42: or (p_lf_evt_ocrd_dt <= pen.effective_start_date)) -- 5741760: PEN recs on a Future date shud also be carried fwd.
43: and pen.enrt_cvg_thru_dt = hr_api.g_eot
44: and pen.effective_end_date = hr_api.g_eot;
45: l_pen_rec c_pen%rowtype;
46: --
47: cursor c_get_actn_items_sus(p_prtt_enrt_rslt_id number,
48: p_eff_dt date) is

Line 88: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot

84: and p_eff_dt between
85: pea.effective_start_date and pea.effective_end_date
86: and p_eff_dt between
87: pen.effective_start_date and pen.effective_end_date
88: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
89: and pen.effective_end_date = hr_api.g_eot;
90: l_opt_unsus c_get_opt_actn_items_unsus%rowtype;
91: --
92: cursor c_epe(p_per_in_ler_id number) is

Line 89: and pen.effective_end_date = hr_api.g_eot;

85: pea.effective_start_date and pea.effective_end_date
86: and p_eff_dt between
87: pen.effective_start_date and pen.effective_end_date
88: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
89: and pen.effective_end_date = hr_api.g_eot;
90: l_opt_unsus c_get_opt_actn_items_unsus%rowtype;
91: --
92: cursor c_epe(p_per_in_ler_id number) is
93: select 'Y' epe_found_flag

Line 193: nvl(l_act_sus.due_dt,hr_api.g_eot) < l_effective_date and

189: exit;
190: end if;
191:
192: if l_act_sus.rqd_flag = 'Y' and
193: nvl(l_act_sus.due_dt,hr_api.g_eot) < l_effective_date and
194: c_get_actn_items_sus%rowcount = 1 then
195: l_act_item_expired := true;
196: end if;
197:

Line 199: l_datetrack_mode := hr_api.g_delete;

195: l_act_item_expired := true;
196: end if;
197:
198: if l_act_sus.effective_start_date < l_effective_date then
199: l_datetrack_mode := hr_api.g_delete;
200: else
201: l_datetrack_mode := hr_api.g_zap;
202: end if;
203:

Line 201: l_datetrack_mode := hr_api.g_zap;

197:
198: if l_act_sus.effective_start_date < l_effective_date then
199: l_datetrack_mode := hr_api.g_delete;
200: else
201: l_datetrack_mode := hr_api.g_zap;
202: end if;
203:
204: l_pea_effective_date := greatest(l_effective_date-1,l_act_sus.effective_start_date);
205: hr_utility.set_location('Delete A1'||l_pen_rec.prtt_enrt_rslt_id ,10);

Line 247: ,p_datetrack_mode => hr_api.g_delete

243: ,p_effective_start_date => l_effective_start_date
244: ,p_effective_end_date => l_effective_end_date
245: ,p_object_version_number => l_pen_rec.object_version_number
246: ,p_effective_date => l_effective_date
247: ,p_datetrack_mode => hr_api.g_delete
248: ,p_multi_row_validate => false --BUG 4718599 to be in sync with inelig
249: ,p_source => 'beninelg');
250: else
251: hr_utility.set_location('delete_enrollment 2'

Line 261: ,p_datetrack_mode => hr_api.g_delete

257: ,p_effective_start_date => l_effective_start_date
258: ,p_effective_end_date => l_effective_end_date
259: ,p_object_version_number => l_pen_rec.object_version_number
260: ,p_effective_date => l_effective_date
261: ,p_datetrack_mode => hr_api.g_delete
262: ,p_multi_row_validate => false --BUG 4718599 true
263: ,p_source => 'benmngle');
264: end if;
265: end if;

Line 284: l_datetrack_mode := hr_api.g_zap;

280: --
281: -- l_pea_effective_date := l_effective_date - 1;
282: --
283: if l_pea_effective_date = l_pea_rec.effective_start_date then
284: l_datetrack_mode := hr_api.g_zap;
285: else
286: l_datetrack_mode := hr_api.g_delete;
287: end if;
288: --

Line 286: l_datetrack_mode := hr_api.g_delete;

282: --
283: if l_pea_effective_date = l_pea_rec.effective_start_date then
284: l_datetrack_mode := hr_api.g_zap;
285: else
286: l_datetrack_mode := hr_api.g_delete;
287: end if;
288: --
289: l_object_version_number := l_pea_rec.object_version_number;
290: --

Line 369: and pen.effective_end_date = hr_api.g_eot

365: and pen.pl_typ_id = l_pl_typ_id
366: and oipl.opt_id = l_opt_id
367: and pen.person_id = p_person_id
368: and pen.per_in_ler_id = p_per_in_ler_id
369: and pen.effective_end_date = hr_api.g_eot
370: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
371: and pen.effective_start_date between oipl.effective_start_date
372: and oipl.effective_end_date
373: AND pen.prtt_enrt_rslt_stat_cd IS NULL

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

366: and oipl.opt_id = l_opt_id
367: and pen.person_id = p_person_id
368: and pen.per_in_ler_id = p_per_in_ler_id
369: and pen.effective_end_date = hr_api.g_eot
370: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
371: and pen.effective_start_date between oipl.effective_start_date
372: and oipl.effective_end_date
373: AND pen.prtt_enrt_rslt_stat_cd IS NULL
374: ;

Line 382: and pen.effective_end_date = hr_api.g_eot

378: from ben_prtt_enrt_rslt_f pen
379: where pen.pl_typ_id = l_pl_typ_id
380: and pen.person_id = p_person_id
381: and pen.per_in_ler_id = p_per_in_ler_id
382: and pen.effective_end_date = hr_api.g_eot
383: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
384: AND pen.prtt_enrt_rslt_stat_cd IS NULL
385: ;
386:

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

379: where pen.pl_typ_id = l_pl_typ_id
380: and pen.person_id = p_person_id
381: and pen.per_in_ler_id = p_per_in_ler_id
382: and pen.effective_end_date = hr_api.g_eot
383: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
384: AND pen.prtt_enrt_rslt_stat_cd IS NULL
385: ;
386:
387: cursor c_previous_pl_oipl_result is

Line 396: and pen.effective_end_date = hr_api.g_eot

392: and pen.pl_typ_id = l_pl_typ_id
393: and oipl.opt_id = l_opt_id
394: and pen.person_id = p_person_id
395: and pen.per_in_ler_id = p_per_in_ler_id
396: and pen.effective_end_date = hr_api.g_eot
397: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
398: and pen.effective_start_date between oipl.effective_start_date
399: and oipl.effective_end_date
400: AND pen.prtt_enrt_rslt_stat_cd IS NULL

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

393: and oipl.opt_id = l_opt_id
394: and pen.person_id = p_person_id
395: and pen.per_in_ler_id = p_per_in_ler_id
396: and pen.effective_end_date = hr_api.g_eot
397: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
398: and pen.effective_start_date between oipl.effective_start_date
399: and oipl.effective_end_date
400: AND pen.prtt_enrt_rslt_stat_cd IS NULL
401: ;

Line 411: and pen.effective_end_date = hr_api.g_eot

407: pen.prtt_enrt_rslt_id = p_prev_prtt_enrt_rslt_id
408: and pen.person_id = p_person_id
409: -- this condition removed to CFD from any result
410: --and pen.per_in_ler_id = p_per_in_ler_id
411: and pen.effective_end_date = hr_api.g_eot
412: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
413: AND pen.prtt_enrt_rslt_stat_cd is null
414: ;
415:

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

408: and pen.person_id = p_person_id
409: -- this condition removed to CFD from any result
410: --and pen.per_in_ler_id = p_per_in_ler_id
411: and pen.effective_end_date = hr_api.g_eot
412: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
413: AND pen.prtt_enrt_rslt_stat_cd is null
414: ;
415:
416:

Line 423: and pen.effective_end_date = hr_api.g_eot

419: from ben_prtt_enrt_rslt_f pen
420: where pen.pl_typ_id = l_pl_typ_id
421: and pen.person_id = p_person_id
422: and pen.per_in_ler_id = p_per_in_ler_id
423: and pen.effective_end_date = hr_api.g_eot
424: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
425: AND pen.prtt_enrt_rslt_stat_cd IS NULL
426: ;
427:

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

420: where pen.pl_typ_id = l_pl_typ_id
421: and pen.person_id = p_person_id
422: and pen.per_in_ler_id = p_per_in_ler_id
423: and pen.effective_end_date = hr_api.g_eot
424: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
425: AND pen.prtt_enrt_rslt_stat_cd IS NULL
426: ;
427:
428: cursor c_prev_pen_dpnts(v_enrt_rslt_id number,v_per_in_ler_id number) is

Line 735: p_cvg_thru_dt => hr_api.g_eot,

731: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
732: p_business_group_id => p_business_group_id,
733: p_effective_date => p_effective_date,
734: p_cvg_strt_dt => l_cvg_strt_dt,
735: p_cvg_thru_dt => hr_api.g_eot,
736: p_datetrack_mode => hr_api.g_insert,
737: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
738: p_effective_start_date => l_eff_start_date,
739: p_effective_end_date => l_eff_end_date,

Line 736: p_datetrack_mode => hr_api.g_insert,

732: p_business_group_id => p_business_group_id,
733: p_effective_date => p_effective_date,
734: p_cvg_strt_dt => l_cvg_strt_dt,
735: p_cvg_thru_dt => hr_api.g_eot,
736: p_datetrack_mode => hr_api.g_insert,
737: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
738: p_effective_start_date => l_eff_start_date,
739: p_effective_end_date => l_eff_end_date,
740: p_object_version_number => l_object_version_number,

Line 787: and pcs.effective_end_date = hr_api.g_eot

783: ,ben_prtt_enrt_ctfn_prvdd_f pcs
784: where lcr.per_in_ler_ended_id = p_per_in_ler_id
785: and lcr.bkup_tbl_typ_cd = 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'
786: and pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
787: and pcs.effective_end_date = hr_api.g_eot
788: and pcs.enrt_ctfn_recd_dt is null
789: and pcs.enrt_ctfn_typ_cd = lcr.comp_lvl_cd
790: and exists (select 'x' -- To confirm if both PENs are for the same comp.object
791: from ben_prtt_enrt_rslt_f pen_lcr

Line 828: l_datetrack_mode := hr_api.g_update;

824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);
825: end if;
826: --
827: if (l_effective_date > l_prvdd_ctfns.effective_start_date) then
828: l_datetrack_mode := hr_api.g_update;
829: else
830: l_effective_date := GREATEST(l_effective_date, l_prvdd_ctfns.effective_start_date);
831: l_datetrack_mode := hr_api.g_correction;
832: end if;

Line 831: l_datetrack_mode := hr_api.g_correction;

827: if (l_effective_date > l_prvdd_ctfns.effective_start_date) then
828: l_datetrack_mode := hr_api.g_update;
829: else
830: l_effective_date := GREATEST(l_effective_date, l_prvdd_ctfns.effective_start_date);
831: l_datetrack_mode := hr_api.g_correction;
832: end if;
833: --
834: ben_prtt_enrt_ctfn_prvdd_api.update_prtt_enrt_ctfn_prvdd
835: (p_prtt_enrt_ctfn_prvdd_id => l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id

Line 984: and pen.enrt_cvg_thru_dt = hr_api.g_eot

980: and pen.prtt_enrt_rslt_stat_cd IS NULL
981: and pen.per_in_ler_id = epe.per_in_ler_id
982: and pen.prtt_enrt_rslt_id = NVL(enb.prtt_enrt_rslt_id,
983: epe.prtt_enrt_rslt_id)
984: and pen.enrt_cvg_thru_dt = hr_api.g_eot
985: and pen.effective_end_date = hr_api.g_eot)
986: and exists (select null
987: from ben_prtt_enrt_rslt_f pen
988: where pen.pl_id = epe.pl_id

Line 985: and pen.effective_end_date = hr_api.g_eot)

981: and pen.per_in_ler_id = epe.per_in_ler_id
982: and pen.prtt_enrt_rslt_id = NVL(enb.prtt_enrt_rslt_id,
983: epe.prtt_enrt_rslt_id)
984: and pen.enrt_cvg_thru_dt = hr_api.g_eot
985: and pen.effective_end_date = hr_api.g_eot)
986: and exists (select null
987: from ben_prtt_enrt_rslt_f pen
988: where pen.pl_id = epe.pl_id
989: and pen.prtt_enrt_rslt_stat_cd IS NULL

Line 994: and pen.enrt_cvg_thru_dt = hr_api.g_eot

990: and pen.per_in_ler_id <> epe.per_in_ler_id
991: and pen.prtt_enrt_rslt_id = NVL(enb.prtt_enrt_rslt_id,
992: epe.prtt_enrt_rslt_id)
993: and pen.sspndd_flag = 'Y'
994: and pen.enrt_cvg_thru_dt = hr_api.g_eot
995: -- and pen.effective_end_date = hr_api.g_eot -- 6156874
996: and pen.effective_end_date >= l_lf_evt_ocrd_dt )
997: order by epe.pgm_id, epe.pl_id;
998: --

Line 995: -- and pen.effective_end_date = hr_api.g_eot -- 6156874

991: and pen.prtt_enrt_rslt_id = NVL(enb.prtt_enrt_rslt_id,
992: epe.prtt_enrt_rslt_id)
993: and pen.sspndd_flag = 'Y'
994: and pen.enrt_cvg_thru_dt = hr_api.g_eot
995: -- and pen.effective_end_date = hr_api.g_eot -- 6156874
996: and pen.effective_end_date >= l_lf_evt_ocrd_dt )
997: order by epe.pgm_id, epe.pl_id;
998: --
999: l_choice_info c_choice_info%rowtype;

Line 1020: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1016: and not exists(select null
1017: from ben_prtt_enrt_rslt_f pen
1018: where pen.pgm_id = epe.pgm_id
1019: and pen.per_in_ler_id = epe.per_in_ler_id
1020: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1021: and pen.effective_end_date = hr_api.g_eot)
1022: or epe.pl_id is not null
1023: and not exists(select null
1024: from ben_prtt_enrt_rslt_f pen

Line 1021: and pen.effective_end_date = hr_api.g_eot)

1017: from ben_prtt_enrt_rslt_f pen
1018: where pen.pgm_id = epe.pgm_id
1019: and pen.per_in_ler_id = epe.per_in_ler_id
1020: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1021: and pen.effective_end_date = hr_api.g_eot)
1022: or epe.pl_id is not null
1023: and not exists(select null
1024: from ben_prtt_enrt_rslt_f pen
1025: where pen.pl_id = epe.pl_id

Line 1027: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1023: and not exists(select null
1024: from ben_prtt_enrt_rslt_f pen
1025: where pen.pl_id = epe.pl_id
1026: and pen.per_in_ler_id = epe.per_in_ler_id
1027: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1028: and pen.effective_end_date = hr_api.g_eot));
1029: --
1030: cursor c_pgm_enrt_dt(v_elig_per_elctbl_chc_id number,v_pgm_id number) is
1031: select pel.enrt_perd_strt_dt

Line 1028: and pen.effective_end_date = hr_api.g_eot));

1024: from ben_prtt_enrt_rslt_f pen
1025: where pen.pl_id = epe.pl_id
1026: and pen.per_in_ler_id = epe.per_in_ler_id
1027: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1028: and pen.effective_end_date = hr_api.g_eot));
1029: --
1030: cursor c_pgm_enrt_dt(v_elig_per_elctbl_chc_id number,v_pgm_id number) is
1031: select pel.enrt_perd_strt_dt
1032: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

Line 1228: l_datetrack_mode := hr_api.g_update;

1224: --
1225: close c_prtt_result;
1226: --
1227: l_new_election := false;
1228: l_datetrack_mode := hr_api.g_update;
1229: l_choice_info.stage := 'N';
1230: --
1231: else
1232: --

Line 1236: l_datetrack_mode := hr_api.g_insert;

1232: --
1233: --Never goes here
1234: --
1235: l_new_election := true;
1236: l_datetrack_mode := hr_api.g_insert;
1237: l_choice_info.stage := 'Y';
1238: --
1239: end if;
1240: --

Line 1539: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then

1535:
1536: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1537: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1538:
1539: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1540:
1541: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1542: -- p_effective_date is now changed to l_effective_dt , when ever LE reprocessed
1543: -- result created as on effective date and automeatic enrollment called with

Line 1741: and effective_end_date < hr_api.g_eot

1737: select prtt_enrt_actn_id, effective_start_date, object_version_number
1738: from ben_prtt_enrt_actn_f
1739: where per_in_ler_id = p_per_in_ler_id
1740: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1741: and effective_end_date < hr_api.g_eot
1742: and business_group_id = p_business_group_id
1743: order by prtt_enrt_actn_id, effective_start_date; -- 5394656
1744: l_actn_item c_actn_item_for_past_pil%rowtype;
1745: --

Line 1751: and effective_end_date < hr_api.g_eot

1747: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
1748: from ben_prtt_enrt_ctfn_prvdd_f
1749: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1750: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
1751: and effective_end_date < hr_api.g_eot
1752: and business_group_id = p_business_group_id
1753: order by prtt_enrt_ctfn_prvdd_id, effective_start_date; -- 5394656
1754: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
1755: --

Line 1760: and effective_end_date = hr_api.g_eot;

1756: cursor c_check_prem_active is
1757: select 1
1758: from ben_prtt_prem_f
1759: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1760: and effective_end_date = hr_api.g_eot;
1761: l_check_prem_active c_check_prem_active%rowtype;
1762: --
1763: cursor c_ended_prem_details is
1764: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number

Line 1767: and ppm.effective_end_date <> hr_api.g_eot

1763: cursor c_ended_prem_details is
1764: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
1765: from ben_prtt_prem_f ppm
1766: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1767: and ppm.effective_end_date <> hr_api.g_eot
1768: and not exists (select 1
1769: from ben_prtt_prem_f ppm2
1770: where ppm2.prtt_prem_id = ppm.prtt_prem_id
1771: and ppm2.effective_end_date > ppm.effective_end_date)

Line 1813: p_datetrack_mode => hr_api.g_future_change);

1809: p_effective_start_date => l_effective_start_date,
1810: p_effective_end_date => l_effective_end_date,
1811: p_object_version_number => l_object_version_number,
1812: p_effective_date => l_actn_item.effective_start_date,
1813: p_datetrack_mode => hr_api.g_future_change);
1814: --
1815: l_prev_prtt_enrt_ctfn_prvdd_id := -1;
1816: --
1817: -- Un-enddate enrollment certification record(s)

Line 1836: p_datetrack_mode => hr_api.g_future_change);

1832: p_effective_start_date => l_effective_start_date,
1833: p_effective_end_date => l_effective_end_date,
1834: p_object_version_number => l_object_version_number,
1835: p_effective_date => l_enrt_ctfn.effective_start_date,
1836: p_datetrack_mode => hr_api.g_future_change);
1837: end if;
1838: --
1839: end loop;
1840: end if;

Line 1860: p_datetrack_mode => hr_api.g_future_change);

1856: p_effective_start_date => l_effective_start_date,
1857: p_effective_end_date => l_effective_end_date,
1858: p_object_version_number => l_ppe_object_version_number,
1859: p_effective_date => l_ended_prem_details.effective_start_date,
1860: p_datetrack_mode => hr_api.g_future_change);
1861: end loop;
1862: --
1863: end if;
1864: close c_check_prem_active;

Line 1888: and pen.effective_end_date = hr_api.g_eot

1884: where pen.sspndd_flag = 'Y'
1885: and pen.per_in_ler_id <> pil.per_in_ler_id
1886: and pil.per_in_ler_id = p_per_in_ler_id
1887: and pen.person_id = pil.person_id
1888: and pen.effective_end_date = hr_api.g_eot
1889: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1890: l_pen_sus c_pen_sus%rowtype;
1891: --
1892: begin

Line 1889: and pen.enrt_cvg_thru_dt = hr_api.g_eot;

1885: and pen.per_in_ler_id <> pil.per_in_ler_id
1886: and pil.per_in_ler_id = p_per_in_ler_id
1887: and pen.person_id = pil.person_id
1888: and pen.effective_end_date = hr_api.g_eot
1889: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1890: l_pen_sus c_pen_sus%rowtype;
1891: --
1892: begin
1893: --