APPS.IRC_ASG_STATUS_API dependencies on PER_EVENTS

Line 191: ,per_events pe

187: L_NOTIFY_PARAMS VARCHAR2(4000);
188: cursor cur_iid is
189: select iid.*
190: from irc_interview_details iid
191: ,per_events pe
192: where iid.event_id = pe.event_id
193: and iid.status not in ('COMPLETED','CANCELLED')
194: and sysdate between iid.start_date and iid.end_date
195: and pe.assignment_id = p_assignment_id;