APPS.GHR_TSP_PLAN_DESIGN dependencies on HR_API

Line 277: and enrt_cvg_thru_dt = hr_api.g_eot

273: from ben_prtt_enrt_rslt_f
274: where person_id = p_person_id
275: and business_group_id = p_business_group_id
276: and pgm_id = p_pgm_id
277: and enrt_cvg_thru_dt = hr_api.g_eot
278: and trunc(p_effective_date) between effective_start_date and effective_end_date
279: and prtt_enrt_rslt_stat_cd is null;
280:
281: -- Cursor to get last TSP benefit record for the person

Line 453: ,p_enrt_cvg_thru_dt => hr_api.g_eot

449: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
450: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
451: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
452: ,p_enrt_cvg_strt_dt => p_effective_date
453: ,p_enrt_cvg_thru_dt => hr_api.g_eot
454: ,p_datetrack_mode => 'INSERT'
455: ,p_suspend_flag => l_suspend_flag
456: ,p_effective_start_date => l_esd
457: ,p_effective_end_date => l_eed

Line 493: ghr_api.retrieve_element_entry_value

489: for get_prev_asg_id in c_get_prev_asg_id loop
490: l_old_asg_id := get_prev_asg_id.assignment_id;
491: exit;
492: End Loop;
493: ghr_api.retrieve_element_entry_value
494: (p_element_name => l_element_name
495: ,p_input_value_name => l_input_value_name
496: ,p_assignment_id => l_old_asg_id
497: ,p_effective_date => p_effective_date

Line 656: and e.effective_end_date = hr_api.g_eot

652: and e.element_link_id = c.element_link_id
653: and f.element_entry_id = e.element_entry_id
654: and f.input_value_id = b.input_value_id
655: and g.business_group_id = c_business_group_id
656: and e.effective_end_date = hr_api.g_eot
657: --and trunc(sysdate) between e.effective_start_date and e.effective_End_date
658: and trunc(e.effective_start_date) between f.effective_start_date and f.effective_End_date
659: and g.assignment_id = e.assignment_id
660: and trunc(e.effective_start_date) between g.effective_start_date and g.effective_end_date