DBA Data[Home] [Help]

APPS.PER_VGR_BUS dependencies on HR_GENERAL

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

616: cursor csr_chk_pos_dates is
617: select null
618: from hr_positions_f pos
619: where pos.position_id = p_position_id
620: and nvl(p_date_to, hr_api.g_eot) <= nvl(hr_general.get_position_date_end(p_position_id), hr_api.g_eot)
621: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 1);