APPS.BEN_DETERMINE_DPNT_ELIGIBILITY dependencies on HR_API

Line 457: pen.effective_end_date = hr_api.g_eot and

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

Line 473: pen.effective_end_date = hr_api.g_eot and

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

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

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

Line 623: and pdp.effective_end_date = hr_api.g_eot

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

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

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

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

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

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

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

Line 1247: if not l_pdp_rec_found and nvl(l_contact.date_of_death,hr_api.g_eot) <= l_lf_evt_ocrd_dt then

1243: hr_utility.set_location ('l_lf_evt_ocrd_dt '||l_lf_evt_ocrd_dt,110);
1244:
1245: -- Bug 7481099
1246: -- if dependent is not already enrolled and if he is dead, set elig flag to N
1247: if not l_pdp_rec_found and nvl(l_contact.date_of_death,hr_api.g_eot) <= l_lf_evt_ocrd_dt then
1248: l_elig_flag := 'N';
1249: hr_utility.set_location ('setting elig_flag to N ',110);
1250: end if;
1251:

Line 1383: ,p_elig_thru_dt => hr_api.g_eot

1379: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
1380: ,p_elig_strt_dt => nvl(l_egd_rec.elig_strt_dt,
1381: nvl(p_lf_evt_ocrd_dt,
1382: p_effective_date))
1383: ,p_elig_thru_dt => hr_api.g_eot
1384: ,p_elig_per_id => l_elig_per_id
1385: ,p_elig_per_opt_id => l_elig_per_opt_id,
1386: p_ovrdn_flag => nvl(l_egd_rec.ovrdn_flag,'N')
1387: ,p_ovrdn_thru_dt => l_egd_rec.ovrdn_thru_dt

Line 1408: ,p_elig_thru_dt => hr_api.g_eot

1404: ,p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
1405: ,p_elig_strt_dt => nvl(l_egd_rec.elig_strt_dt,
1406: nvl(p_lf_evt_ocrd_dt,
1407: p_effective_date))
1408: ,p_elig_thru_dt => hr_api.g_eot
1409: ,p_elig_per_id => l_elig_per_id
1410: ,p_elig_per_opt_id => l_elig_per_opt_id,
1411: p_ovrdn_flag => nvl(l_egd_rec.ovrdn_flag,'N')
1412: ,p_ovrdn_thru_dt => l_egd_rec.ovrdn_thru_dt

Line 1526: l_datetrack_mode := hr_api.g_update_override;

1522: p_update_change_insert => l_update_change_insert);
1523: --
1524: if l_update_override then
1525: --
1526: l_datetrack_mode := hr_api.g_update_override;
1527: --
1528: elsif l_update then
1529: --
1530: l_datetrack_mode := hr_api.g_update;

Line 1530: l_datetrack_mode := hr_api.g_update;

1526: l_datetrack_mode := hr_api.g_update_override;
1527: --
1528: elsif l_update then
1529: --
1530: l_datetrack_mode := hr_api.g_update;
1531: --
1532: else
1533: --
1534: l_datetrack_mode := hr_api.g_correction;

Line 1534: l_datetrack_mode := hr_api.g_correction;

1530: l_datetrack_mode := hr_api.g_update;
1531: --
1532: else
1533: --
1534: l_datetrack_mode := hr_api.g_correction;
1535: --
1536: end if;
1537: hr_utility.set_location ('datetrack_mode '||l_datetrack_mode,10);
1538: --