DBA Data[Home] [Help]

APPS.IRC_IID_BUS dependencies on HR_GENERAL

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: --