APPS.IRC_IID_BUS dependencies on IRC_INTERVIEW_DETAILS

Line 661: from irc_interview_details

657: l_proc varchar2(72) := g_package||'update_validate';
658: l_old_status varchar2(30);
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