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

Line 455: pen.effective_end_date = hr_api.g_eot and

451: where pen.person_id=p_person_id and
452: pen.business_group_id =p_business_group_id and
453: --pen.sspndd_flag='N' and --5127698
454: pen.prtt_enrt_rslt_stat_cd is null and
455: pen.effective_end_date = hr_api.g_eot and
456: nvl(l_lf_evt_ocrd_dt,p_effective_date)-1 <=
457: pen.enrt_cvg_thru_dt and
458: pen.enrt_cvg_strt_dt < pen.effective_end_date
459: and pen.pl_id = p_pl_id

Line 471: pen.effective_end_date = hr_api.g_eot and

467: where pen.person_id=p_person_id and
468: pen.business_group_id =p_business_group_id and
469: --pen.sspndd_flag='N' and --5127698
470: pen.prtt_enrt_rslt_stat_cd is null and
471: pen.effective_end_date = hr_api.g_eot and
472: nvl(l_lf_evt_ocrd_dt,p_effective_date)-1 <=
473: pen.enrt_cvg_thru_dt and
474: pen.enrt_cvg_strt_dt < pen.effective_end_date and
475: pen.oipl_id=p_oipl_id

Line 532: and l_lf_evt_ocrd_dt between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)

528: and pdp.business_group_id = p_business_group_id
529: and pdp.dpnt_person_id = ctr.contact_person_id
530: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
531: pdp.effective_start_date and pdp.effective_end_date
532: and l_lf_evt_ocrd_dt between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
533: and pil.per_in_ler_id=pdp.per_in_ler_id
534: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
535: and not exists (
536: select null

Line 619: and pdp.effective_end_date = hr_api.g_eot

615: and pdp.dpnt_person_id = l_contact.contact_person_id
616: -- bug 3784375
617: --and nvl(p_lf_evt_ocrd_dt,p_effective_date)
618: -- between pdp.effective_start_date and pdp.effective_end_date
619: and pdp.effective_end_date = hr_api.g_eot
620: --
621: -- Bug 5127698 : Due to following date check, dependents do not get carry forwarded
622: -- when PDP.cvg_strt_dt is later than l_lf_evt_ocrd_dt.
623: -- Above date check(EOT) should be sufficient.

Line 625: -- between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)

621: -- Bug 5127698 : Due to following date check, dependents do not get carry forwarded
622: -- when PDP.cvg_strt_dt is later than l_lf_evt_ocrd_dt.
623: -- Above date check(EOT) should be sufficient.
624: --and l_lf_evt_ocrd_dt
625: -- between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
626: -- Instead of above check, added following check which will make sure that
627: -- end dated dependents will not get carry forwarded
628: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= l_lf_evt_ocrd_dt
629: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= pdp.cvg_strt_dt

Line 628: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= l_lf_evt_ocrd_dt

624: --and l_lf_evt_ocrd_dt
625: -- between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
626: -- Instead of above check, added following check which will make sure that
627: -- end dated dependents will not get carry forwarded
628: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= l_lf_evt_ocrd_dt
629: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= pdp.cvg_strt_dt
630: and pil.per_in_ler_id=pdp.per_in_ler_id
631: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
632: --

Line 629: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= pdp.cvg_strt_dt

625: -- between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
626: -- Instead of above check, added following check which will make sure that
627: -- end dated dependents will not get carry forwarded
628: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= l_lf_evt_ocrd_dt
629: and nvl(pdp.cvg_thru_dt,hr_api.g_eot) >= pdp.cvg_strt_dt
630: and pil.per_in_ler_id=pdp.per_in_ler_id
631: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
632: --
633: cursor c_dcln_pl_opt is

Line 1367: ,p_elig_thru_dt => hr_api.g_eot

1363: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
1364: ,p_elig_strt_dt => nvl(l_egd_rec.elig_strt_dt,
1365: nvl(p_lf_evt_ocrd_dt,
1366: p_effective_date))
1367: ,p_elig_thru_dt => hr_api.g_eot
1368: ,p_elig_per_id => l_elig_per_id
1369: ,p_elig_per_opt_id => l_elig_per_opt_id,
1370: p_ovrdn_flag => nvl(l_egd_rec.ovrdn_flag,'N')
1371: ,p_ovrdn_thru_dt => l_egd_rec.ovrdn_thru_dt

Line 1392: ,p_elig_thru_dt => hr_api.g_eot

1388: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
1389: ,p_elig_strt_dt => nvl(l_egd_rec.elig_strt_dt,
1390: nvl(p_lf_evt_ocrd_dt,
1391: p_effective_date))
1392: ,p_elig_thru_dt => hr_api.g_eot
1393: ,p_elig_per_id => l_elig_per_id
1394: ,p_elig_per_opt_id => l_elig_per_opt_id,
1395: p_ovrdn_flag => nvl(l_egd_rec.ovrdn_flag,'N')
1396: ,p_ovrdn_thru_dt => l_egd_rec.ovrdn_thru_dt

Line 1510: l_datetrack_mode := hr_api.g_update_override;

1506: p_update_change_insert => l_update_change_insert);
1507: --
1508: if l_update_override then
1509: --
1510: l_datetrack_mode := hr_api.g_update_override;
1511: --
1512: elsif l_update then
1513: --
1514: l_datetrack_mode := hr_api.g_update;

Line 1514: l_datetrack_mode := hr_api.g_update;

1510: l_datetrack_mode := hr_api.g_update_override;
1511: --
1512: elsif l_update then
1513: --
1514: l_datetrack_mode := hr_api.g_update;
1515: --
1516: else
1517: --
1518: l_datetrack_mode := hr_api.g_correction;

Line 1518: l_datetrack_mode := hr_api.g_correction;

1514: l_datetrack_mode := hr_api.g_update;
1515: --
1516: else
1517: --
1518: l_datetrack_mode := hr_api.g_correction;
1519: --
1520: end if;
1521: hr_utility.set_location ('datetrack_mode '||l_datetrack_mode,10);
1522: --