DBA Data[Home] [Help]

APPS.PER_VGR_BUS dependencies on HR_GENERAL

Line 606: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)

602: cursor csr_chk_pos_dates is
603: select null
604: from hr_positions_f pos
605: where pos.position_id = p_position_id
606: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
607: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
608: --
609: begin
610: hr_utility.set_location('Entering:'|| l_proc, 1);