APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on IRC_INTERVIEW_DETAILS

Line 552: from irc_interview_details

548: and trunc(sysdate) between effective_start_date and effective_end_Date)
549: and end_Date is null;
550: cursor getInterViewStatus(c_interviewId in number) is
551: select status
552: from irc_interview_details
553: where event_id = c_interviewId
554: and sysdate between start_date and nvl(end_Date,sysdate);
555:
556: begin