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 986: and pen.enrt_cvg_thru_dt = hr_api.g_eot

982: /* Added the below condition and commented the code for Bug 7426609 */
983: and pen.per_in_ler_id=p_per_in_ler_id
984: /*and pen.prtt_enrt_rslt_id = NVL(enb.prtt_enrt_rslt_id,
985: epe.prtt_enrt_rslt_id)*/
986: and pen.enrt_cvg_thru_dt = hr_api.g_eot
987: and pen.effective_end_date = hr_api.g_eot)
988: and exists (select null
989: from ben_prtt_enrt_rslt_f pen
990: where pen.pl_id = epe.pl_id

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

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

Line 996: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

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

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

Line 1022: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

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

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

Line 1029: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

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

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

Line 1232: l_datetrack_mode := hr_api.g_update;

1228: --
1229: close c_prtt_result;
1230: --
1231: l_new_election := false;
1232: l_datetrack_mode := hr_api.g_update;
1233: l_choice_info.stage := 'N';
1234: --
1235: else
1236: --

Line 1240: l_datetrack_mode := hr_api.g_insert;

1236: --
1237: --Never goes here
1238: --
1239: l_new_election := true;
1240: l_datetrack_mode := hr_api.g_insert;
1241: l_choice_info.stage := 'Y';
1242: --
1243: end if;
1244: --

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

1550:
1551: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1552: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1553:
1554: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1555:
1556: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1557: -- p_effective_date is now changed to l_effective_dt , when ever LE reprocessed
1558: -- result created as on effective date and automeatic enrollment called with

Line 1795: and effective_end_date < hr_api.g_eot

1791: select prtt_enrt_actn_id, effective_start_date, object_version_number
1792: from ben_prtt_enrt_actn_f
1793: where per_in_ler_id = p_per_in_ler_id
1794: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1795: and effective_end_date < hr_api.g_eot
1796: and business_group_id = p_business_group_id
1797: order by prtt_enrt_actn_id, effective_start_date; -- 5394656
1798: l_actn_item c_actn_item_for_past_pil%rowtype;
1799: --

Line 1805: and effective_end_date < hr_api.g_eot

1801: select prtt_enrt_ctfn_prvdd_id, effective_start_date, object_version_number
1802: from ben_prtt_enrt_ctfn_prvdd_f
1803: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1804: and prtt_enrt_actn_id = p_prtt_enrt_actn_id
1805: and effective_end_date < hr_api.g_eot
1806: and business_group_id = p_business_group_id
1807: order by prtt_enrt_ctfn_prvdd_id, effective_start_date; -- 5394656
1808: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
1809: --

Line 1814: and effective_end_date = hr_api.g_eot;

1810: cursor c_check_prem_active is
1811: select 1
1812: from ben_prtt_prem_f
1813: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1814: and effective_end_date = hr_api.g_eot;
1815: l_check_prem_active c_check_prem_active%rowtype;
1816: --
1817: cursor c_ended_prem_details is
1818: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number

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

1817: cursor c_ended_prem_details is
1818: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
1819: from ben_prtt_prem_f ppm
1820: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1821: and ppm.effective_end_date <> hr_api.g_eot
1822: and not exists (select 1
1823: from ben_prtt_prem_f ppm2
1824: where ppm2.prtt_prem_id = ppm.prtt_prem_id
1825: and ppm2.effective_end_date > ppm.effective_end_date)

Line 1867: p_datetrack_mode => hr_api.g_future_change);

1863: p_effective_start_date => l_effective_start_date,
1864: p_effective_end_date => l_effective_end_date,
1865: p_object_version_number => l_object_version_number,
1866: p_effective_date => l_actn_item.effective_start_date,
1867: p_datetrack_mode => hr_api.g_future_change);
1868: --
1869: l_prev_prtt_enrt_ctfn_prvdd_id := -1;
1870: --
1871: -- Un-enddate enrollment certification record(s)

Line 1890: p_datetrack_mode => hr_api.g_future_change);

1886: p_effective_start_date => l_effective_start_date,
1887: p_effective_end_date => l_effective_end_date,
1888: p_object_version_number => l_object_version_number,
1889: p_effective_date => l_enrt_ctfn.effective_start_date,
1890: p_datetrack_mode => hr_api.g_future_change);
1891: end if;
1892: --
1893: end loop;
1894: end if;

Line 1914: p_datetrack_mode => hr_api.g_future_change);

1910: p_effective_start_date => l_effective_start_date,
1911: p_effective_end_date => l_effective_end_date,
1912: p_object_version_number => l_ppe_object_version_number,
1913: p_effective_date => l_ended_prem_details.effective_start_date,
1914: p_datetrack_mode => hr_api.g_future_change);
1915: end loop;
1916: --
1917: end if;
1918: close c_check_prem_active;

Line 1942: and pen.effective_end_date = hr_api.g_eot

1938: where pen.sspndd_flag = 'Y'
1939: and pen.per_in_ler_id <> pil.per_in_ler_id
1940: and pil.per_in_ler_id = p_per_in_ler_id
1941: and pen.person_id = pil.person_id
1942: and pen.effective_end_date = hr_api.g_eot
1943: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1944: l_pen_sus c_pen_sus%rowtype;
1945: --
1946: begin

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

1939: and pen.per_in_ler_id <> pil.per_in_ler_id
1940: and pil.per_in_ler_id = p_per_in_ler_id
1941: and pen.person_id = pil.person_id
1942: and pen.effective_end_date = hr_api.g_eot
1943: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
1944: l_pen_sus c_pen_sus%rowtype;
1945: --
1946: begin
1947: --