APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on IRC_INTERVIEW_DETAILS
Line 367: from irc_interview_details
363: and trunc(sysdate) between effective_start_date and effective_end_Date)
364: and end_Date is null;
365: cursor getInterViewStatus(c_interviewId in number) is
366: select status 367: from irc_interview_details 368: where event_id = c_interviewId
369: and sysdate between start_date and nvl(end_Date,sysdate);
370:
371: begin