DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on HR_API

Line 714: AND pen.effective_end_date = hr_api.g_eot

710: FROM ben_prtt_enrt_rslt_f pen
711: WHERE pen.person_id = p_person_id
712: AND pen.business_group_id = p_business_group_id
713: AND pen.prtt_enrt_rslt_stat_cd IS NULL
714: AND pen.effective_end_date = hr_api.g_eot
715: AND cv_effective_date <= pen.enrt_cvg_thru_dt
716: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
717: AND NVL(l_epe.oipl_id,-1) = NVL(pen.oipl_id,-1)
718: AND l_epe.pl_id = pen.pl_id

Line 2052: g_old_val := hr_api.g_number; /*0;changed for 3497676 */

2048: close c_epe_in_pndg ;
2049: --
2050: -- put a row in fnd_sessions
2051: --
2052: g_old_val := hr_api.g_number; /*0;changed for 3497676 */
2053:
2054: /* when the 1st coverage is calculated as 0, the enrt bnft row was not
2055: being created because g_old_val is initialised to 0 */
2056: --