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 219: and pen.effective_end_date = hr_api.g_eot

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

Line 220: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 238: and pen.effective_end_date = hr_api.g_eot

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

Line 239: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 265: and epo.effective_end_date = hr_api.g_eot

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

Line 267: and pen.effective_end_date = hr_api.g_eot

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

Line 268: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 289: and pen.effective_end_date = hr_api.g_eot

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

Line 290: and pen.enrt_cvg_thru_dt = hr_api.g_eot

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

Line 510: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 531: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 553: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 707: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 720: and pen.effective_end_date = hr_api.g_eot

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

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

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

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

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

Line 735: and pen.effective_end_date = hr_api.g_eot

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

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

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

Line 821: p_datetrack_mode => hr_api.g_future_change,

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

Line 840: p_datetrack_mode => hr_api.g_future_change,

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

Line 859: p_datetrack_mode => hr_api.g_future_change,

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

Line 1064: l_datetrack_mode := hr_api.g_update_override;

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

Line 1068: l_datetrack_mode := hr_api.g_update;

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

Line 1072: l_datetrack_mode := hr_api.g_correction;

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

Line 1318: l_datetrack_mode := hr_api.g_update_override;

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

Line 1322: l_datetrack_mode := hr_api.g_update;

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

Line 1326: l_datetrack_mode := hr_api.g_correction;

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

Line 1623: l_datetrack_mode := hr_api.g_update_override;

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

Line 1627: l_datetrack_mode := hr_api.g_update;

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

Line 1631: l_datetrack_mode := hr_api.g_correction;

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