Line 663: and sysdate between start_date and nvl(end_date,hr_general.end_of_time);
659: cursor csr_old_status is
660: select status
661: from irc_interview_details
662: where interview_details_id = p_rec.interview_details_id 663: and sysdate between start_date and nvl(end_date,hr_general.end_of_time); 664: --
665: Begin
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --