APPS.IRC_NOTIFICATION_HELPER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

  SELECT usr.user_name
  FROM fnd_user usr
  WHERE usr.employee_id = p_person_id
  and (usr.end_date is null or usr.end_date >=sysdate);

Line: 225

select user_name
from fnd_user
where upper(email_address)=upper(p_email_address)
and (end_date is null or end_date >=sysdate);

Line: 413

                      'select document_id from (
                      select document_id, person_id, rank () over
                      (partition by person_id order by last_update_date desc) rank
                      from irc_documents doc
                      where type in (:p_resume,:p_auto_resume)
                        and (doc.end_Date is null or doc.end_Date > sysdate)
                        and person_id in ('||p_person_ids||'))
                      where rank = :p_rank';

Line: 471

  cursor csr_doc is select binary_doc,
                                         mime_type,
                                         file_name
                                from irc_documents
                              where document_id = p_document_id;

Line: 548

        select IRC_NOTIFICATION_EVENT_KEY_S.nextval into l_eventKey from dual;