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

Line 221: and pen.effective_end_date = hr_api.g_eot

217: and pen.pl_id = pep.pl_id
218: and pep.elig_flag = 'N'
219: and pep.per_in_ler_id = p_per_in_ler_id
220: and pen.prtt_enrt_rslt_stat_cd is null
221: and pen.effective_end_date = hr_api.g_eot
222: and pen.enrt_cvg_thru_dt = hr_api.g_eot
223: and pen.oipl_id is null
224: and pen.person_id = p_person_id;
225: --

Line 222: and pen.enrt_cvg_thru_dt = hr_api.g_eot

218: and pep.elig_flag = 'N'
219: and pep.per_in_ler_id = p_per_in_ler_id
220: and pen.prtt_enrt_rslt_stat_cd is null
221: and pen.effective_end_date = hr_api.g_eot
222: and pen.enrt_cvg_thru_dt = hr_api.g_eot
223: and pen.oipl_id is null
224: and pen.person_id = p_person_id;
225: --
226: l_pep_pgm_defer c_pep_pgm_defer%ROWTYPE;

Line 240: and pen.effective_end_date = hr_api.g_eot

236: and pen.pgm_id is null
237: and pen.oipl_id is null
238: and pep.per_in_ler_id = p_per_in_ler_id
239: and pen.prtt_enrt_rslt_stat_cd is null
240: and pen.effective_end_date = hr_api.g_eot
241: and pen.enrt_cvg_thru_dt = hr_api.g_eot
242: and pen.person_id = p_person_id;
243: --
244: l_pep_pl_defer c_pep_pl_defer%ROWTYPE;

Line 241: and pen.enrt_cvg_thru_dt = hr_api.g_eot

237: and pen.oipl_id is null
238: and pep.per_in_ler_id = p_per_in_ler_id
239: and pen.prtt_enrt_rslt_stat_cd is null
240: and pen.effective_end_date = hr_api.g_eot
241: and pen.enrt_cvg_thru_dt = hr_api.g_eot
242: and pen.person_id = p_person_id;
243: --
244: l_pep_pl_defer c_pep_pl_defer%ROWTYPE;
245: --

Line 267: and epo.effective_end_date = hr_api.g_eot

263: --Bug : 6881745
264: /* AND p_effective_date
265: BETWEEN epo.effective_start_date AND epo.effective_end_date */
266: --Bug : 7181958
267: and epo.effective_end_date = hr_api.g_eot
268: --Bug : 6881745
269: and pen.effective_end_date = hr_api.g_eot
270: and pen.enrt_cvg_thru_dt = hr_api.g_eot
271: and pen.prtt_enrt_rslt_stat_cd is null

Line 269: and pen.effective_end_date = hr_api.g_eot

265: BETWEEN epo.effective_start_date AND epo.effective_end_date */
266: --Bug : 7181958
267: and epo.effective_end_date = hr_api.g_eot
268: --Bug : 6881745
269: and pen.effective_end_date = hr_api.g_eot
270: and pen.enrt_cvg_thru_dt = hr_api.g_eot
271: and pen.prtt_enrt_rslt_stat_cd is null
272: and pen.person_id = p_person_id;
273: --

Line 270: and pen.enrt_cvg_thru_dt = hr_api.g_eot

266: --Bug : 7181958
267: and epo.effective_end_date = hr_api.g_eot
268: --Bug : 6881745
269: and pen.effective_end_date = hr_api.g_eot
270: and pen.enrt_cvg_thru_dt = hr_api.g_eot
271: and pen.prtt_enrt_rslt_stat_cd is null
272: and pen.person_id = p_person_id;
273: --
274: l_epo_plip_defer c_epo_plip_defer%ROWTYPE;

Line 291: and pen.effective_end_date = hr_api.g_eot

287: and epo.elig_per_id = pep.elig_per_id
288: and pep.per_in_ler_id = p_per_in_ler_id
289: and oipl.opt_id = epo.opt_id
290: and epo.elig_flag = 'N'
291: and pen.effective_end_date = hr_api.g_eot
292: and pen.enrt_cvg_thru_dt = hr_api.g_eot
293: and pen.prtt_enrt_rslt_stat_cd is null
294: and pen.person_id = p_person_id;
295: --

Line 292: and pen.enrt_cvg_thru_dt = hr_api.g_eot

288: and pep.per_in_ler_id = p_per_in_ler_id
289: and oipl.opt_id = epo.opt_id
290: and epo.elig_flag = 'N'
291: and pen.effective_end_date = hr_api.g_eot
292: and pen.enrt_cvg_thru_dt = hr_api.g_eot
293: and pen.prtt_enrt_rslt_stat_cd is null
294: and pen.person_id = p_person_id;
295: --
296: l_epo_plnip_defer c_epo_plnip_defer%ROWTYPE;

Line 512: and pen.effective_end_date = hr_api.g_eot

508: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
509: and pen.person_id = p_person_id
510: and pen.business_group_id+0 = p_business_group_id
511: and pen.prtt_enrt_rslt_stat_cd is null
512: and pen.effective_end_date = hr_api.g_eot
513: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
514: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
515: and pen.enrt_cvg_strt_dt < pen.effective_end_date
516: order by effective_start_date desc;

Line 513: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999

509: and pen.person_id = p_person_id
510: and pen.business_group_id+0 = p_business_group_id
511: and pen.prtt_enrt_rslt_stat_cd is null
512: and pen.effective_end_date = hr_api.g_eot
513: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
514: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
515: and pen.enrt_cvg_strt_dt < pen.effective_end_date
516: order by effective_start_date desc;
517: /*

Line 533: and pen.effective_end_date = hr_api.g_eot

529: where p_pgm_id = pen.pgm_id
530: and pen.person_id = p_person_id
531: and pen.business_group_id+0 = p_business_group_id
532: and pen.prtt_enrt_rslt_stat_cd is null
533: and pen.effective_end_date = hr_api.g_eot
534: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
535: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
536: and pen.enrt_cvg_strt_dt < pen.effective_end_date
537: order by effective_start_date desc;

Line 534: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999

530: and pen.person_id = p_person_id
531: and pen.business_group_id+0 = p_business_group_id
532: and pen.prtt_enrt_rslt_stat_cd is null
533: and pen.effective_end_date = hr_api.g_eot
534: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
535: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
536: and pen.enrt_cvg_strt_dt < pen.effective_end_date
537: order by effective_start_date desc;
538: /*

Line 555: and pen.effective_end_date = hr_api.g_eot

551: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
552: and pen.person_id = p_person_id
553: and pen.business_group_id+0 = p_business_group_id
554: and pen.prtt_enrt_rslt_stat_cd is null
555: and pen.effective_end_date = hr_api.g_eot
556: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
557: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
558: and pen.enrt_cvg_strt_dt < pen.effective_end_date
559: order by effective_start_date desc;

Line 556: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999

552: and pen.person_id = p_person_id
553: and pen.business_group_id+0 = p_business_group_id
554: and pen.prtt_enrt_rslt_stat_cd is null
555: and pen.effective_end_date = hr_api.g_eot
556: and pen.enrt_cvg_thru_dt = hr_api.g_eot -- 9999
557: and l_effective_date_1 <= pen.enrt_cvg_thru_dt
558: and pen.enrt_cvg_strt_dt < pen.effective_end_date
559: order by effective_start_date desc;
560: /*

Line 709: and pen.effective_end_date = hr_api.g_eot

705: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
706: and pen.person_id = p_person_id
707: and pen.business_group_id = p_business_group_id
708: and pen.prtt_enrt_rslt_stat_cd is null
709: and pen.effective_end_date = hr_api.g_eot
710: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
711: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
712: --
713: cursor c_pen_pgm_2 is

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

706: and pen.person_id = p_person_id
707: and pen.business_group_id = p_business_group_id
708: and pen.prtt_enrt_rslt_stat_cd is null
709: and pen.effective_end_date = hr_api.g_eot
710: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
711: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
712: --
713: cursor c_pen_pgm_2 is
714: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,ptip_id,

Line 722: and pen.effective_end_date = hr_api.g_eot

718: where p_pgm_id = pen.pgm_id
719: and pen.person_id = p_person_id
720: and pen.business_group_id = p_business_group_id
721: and pen.prtt_enrt_rslt_stat_cd is null
722: and pen.effective_end_date = hr_api.g_eot
723: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
724: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
725: --
726: cursor c_pen_oipl_2 is

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

719: and pen.person_id = p_person_id
720: and pen.business_group_id = p_business_group_id
721: and pen.prtt_enrt_rslt_stat_cd is null
722: and pen.effective_end_date = hr_api.g_eot
723: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
724: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
725: --
726: cursor c_pen_oipl_2 is
727: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,

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

732: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
733: and pen.person_id = p_person_id
734: and pen.business_group_id = p_business_group_id
735: and pen.prtt_enrt_rslt_stat_cd is null
736: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
737: and pen.effective_end_date = hr_api.g_eot
738: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
739: --
740: cursor c_pen_max_esd (v_prtt_enrt_rslt_id in number) is

Line 737: and pen.effective_end_date = hr_api.g_eot

733: and pen.person_id = p_person_id
734: and pen.business_group_id = p_business_group_id
735: and pen.prtt_enrt_rslt_stat_cd is null
736: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
737: and pen.effective_end_date = hr_api.g_eot
738: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
739: --
740: cursor c_pen_max_esd (v_prtt_enrt_rslt_id in number) is
741: select pen.effective_end_date,pen.object_version_number

Line 748: and pen.effective_end_date <> hr_api.g_eot

744: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
745: and pen.business_group_id = p_business_group_id
746: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
747: and pen.per_in_ler_id = pil.per_in_ler_id
748: and pen.effective_end_date <> hr_api.g_eot
749: order by pen.effective_end_date desc;
750: --
751: l_correction boolean;
752: l_update boolean;

Line 823: p_datetrack_mode => hr_api.g_future_change,

819: p_effective_start_date => l_effective_start_date,
820: p_effective_end_date => l_effective_end_date,
821: p_object_version_number => l_pen_max_esd.object_version_number,
822: p_effective_date => l_pen_max_esd.effective_end_date,
823: p_datetrack_mode => hr_api.g_future_change,
824: p_multi_row_validate => FALSE);
825: end if;
826: close c_pen_max_esd;
827:

Line 842: p_datetrack_mode => hr_api.g_future_change,

838: p_effective_start_date => l_effective_start_date,
839: p_effective_end_date => l_effective_end_date,
840: p_object_version_number => l_pen_max_esd.object_version_number,
841: p_effective_date => l_pen_max_esd.effective_end_date,
842: p_datetrack_mode => hr_api.g_future_change,
843: p_multi_row_validate => FALSE);
844: end if;
845: close c_pen_max_esd;
846: --

Line 861: p_datetrack_mode => hr_api.g_future_change,

857: p_effective_start_date => l_effective_start_date,
858: p_effective_end_date => l_effective_end_date,
859: p_object_version_number => l_pen_max_esd.object_version_number,
860: p_effective_date => l_pen_max_esd.effective_end_date,
861: p_datetrack_mode => hr_api.g_future_change,
862: p_multi_row_validate => FALSE);
863: end if;
864: close c_pen_max_esd;
865: --

Line 1066: l_datetrack_mode := hr_api.g_update_override;

1062: p_update_change_insert => l_update_change_insert);
1063: --
1064: if l_update_override then
1065: --
1066: l_datetrack_mode := hr_api.g_update_override;
1067: --
1068: elsif l_update then
1069: --
1070: l_datetrack_mode := hr_api.g_update;

Line 1070: l_datetrack_mode := hr_api.g_update;

1066: l_datetrack_mode := hr_api.g_update_override;
1067: --
1068: elsif l_update then
1069: --
1070: l_datetrack_mode := hr_api.g_update;
1071: --
1072: else
1073: --
1074: l_datetrack_mode := hr_api.g_correction;

Line 1074: l_datetrack_mode := hr_api.g_correction;

1070: l_datetrack_mode := hr_api.g_update;
1071: --
1072: else
1073: --
1074: l_datetrack_mode := hr_api.g_correction;
1075: --
1076: end if;
1077: --
1078: ben_prtt_enrt_result_api.update_PRTT_ENRT_RESULT

Line 1320: l_datetrack_mode := hr_api.g_update_override;

1316: p_update_change_insert => l_update_change_insert);
1317: --
1318: if l_update_override then
1319: --
1320: l_datetrack_mode := hr_api.g_update_override;
1321: --
1322: elsif l_update then
1323: --
1324: l_datetrack_mode := hr_api.g_update;

Line 1324: l_datetrack_mode := hr_api.g_update;

1320: l_datetrack_mode := hr_api.g_update_override;
1321: --
1322: elsif l_update then
1323: --
1324: l_datetrack_mode := hr_api.g_update;
1325: --
1326: else
1327: --
1328: l_datetrack_mode := hr_api.g_correction;

Line 1328: l_datetrack_mode := hr_api.g_correction;

1324: l_datetrack_mode := hr_api.g_update;
1325: --
1326: else
1327: --
1328: l_datetrack_mode := hr_api.g_correction;
1329: --
1330: end if;
1331: --
1332: ben_prtt_enrt_result_api.update_PRTT_ENRT_RESULT

Line 1625: l_datetrack_mode := hr_api.g_update_override;

1621: p_update_change_insert => l_update_change_insert);
1622: --
1623: if l_update_override then
1624: --
1625: l_datetrack_mode := hr_api.g_update_override;
1626: --
1627: elsif l_update then
1628: --
1629: l_datetrack_mode := hr_api.g_update;

Line 1629: l_datetrack_mode := hr_api.g_update;

1625: l_datetrack_mode := hr_api.g_update_override;
1626: --
1627: elsif l_update then
1628: --
1629: l_datetrack_mode := hr_api.g_update;
1630: --
1631: else
1632: --
1633: l_datetrack_mode := hr_api.g_correction;

Line 1633: l_datetrack_mode := hr_api.g_correction;

1629: l_datetrack_mode := hr_api.g_update;
1630: --
1631: else
1632: --
1633: l_datetrack_mode := hr_api.g_correction;
1634: --
1635: end if;
1636: --
1637: hr_utility.set_location('pen_id='||l_pen.prtt_enrt_rslt_id,1963);