APPS.IRC_ASG_STATUS_API dependencies on PER_EVENTS

Line 164: ,per_events pe

160: L_NOTIFY_PARAMS VARCHAR2(4000);
161: cursor cur_iid is
162: select iid.*
163: from irc_interview_details iid
164: ,per_events pe
165: where iid.event_id = pe.event_id
166: and iid.status not in ('COMPLETED','CANCELLED')
167: and sysdate between iid.start_date and iid.end_date
168: and pe.assignment_id = p_assignment_id;