DBA Data[Home] [Help]

APPS.BEN_DET_WAIT_PERD_CMPLTN dependencies on HR_API

Line 485: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));

481: p_date_code => 'OSD');
482: --
483: end if;
484: if l_wait_st_date is null then
485: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));
486: end if;
487: --
488: elsif p_wait_perd_dt_to_use_cd = 'EASDNASD' then
489: --

Line 570: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));

566: end if;
567: --
568: if l_wait_st_date is null then
569: --
570: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));
571: end if;
572: --
573: elsif p_wait_perd_dt_to_use_cd = 'EDOHNDOH' then
574: --

Line 627: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));

623: p_date_code => 'DOH');
624: end if;
625: --
626: if l_wait_st_date is null then
627: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));
628: end if;
629:
630: elsif p_wait_perd_dt_to_use_cd = 'EOHDNOHD' then
631: --

Line 686: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));

682: p_date_code => 'DOH');
683: end if;
684: --
685: if l_wait_st_date is null then
686: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));
687: end if;
688:
689: -- Bug 1838055 : Added code AED.
690: elsif p_wait_perd_dt_to_use_cd in ('LED', 'AED') then

Line 699: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));

695: elsif p_wait_perd_dt_to_use_cd = 'LRD' then
696: --
697: -- Use the Later or Life Event Date or Notified Date
698: --
699: l_wait_st_date := greatest(p_lf_evt_ocrd_dt,nvl(p_ntfn_dt,hr_api.g_sot));
700: else
701: --
702: -- Defensive coding in case code is not known.
703: --