APPS.IRC_NOTIFICATION_WORKFLOW_PKG SQL Statements

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

Line: 320

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

Line: 346

      select count(*)
       from irc_documents
      where type = 'RESUME'
        and party_id =
           (select party_id
              from per_all_people_f
            where person_id = c_person_id
              and trunc(sysdate) between effective_start_date and effective_end_Date)
        and end_date is null;

Line: 356

      select document_id
        from irc_documents
       where type  = c_doc_type
         and party_id =
           (select party_id
              from per_all_people_f
            where person_id = c_personIdIn
              and trunc(sysdate) between effective_start_date and effective_end_Date)
         and end_Date is null;

Line: 366

    select status
     from irc_interview_details
    where event_id = c_interviewId
      and sysdate between start_date and nvl(end_Date,sysdate);

Line: 601

      select count(*)
        from wf_roles
       where c_recipient = orig_system || ':' || orig_system_id
         and status = 'ACTIVE';

Line: 627

      select 'true'
      from dual
      where instr(c_modifiedItemsString,',LOCATIONID,')>0
            OR instr(c_modifiedItemsString,',DATESTART,')>0
            OR instr(c_modifiedItemsString,',DATEEND,')>0
            OR instr(c_modifiedItemsString,',TIMEEND,')>0
            OR instr(c_modifiedItemsString,',TIMESTART,')>0
            OR instr(c_modifiedItemsString,',CONTACTTELEPHONENUMBER,')>0
            OR instr(c_modifiedItemsString,',INTERNALCONTACTPERSONID,')>0
            OR instr(c_modifiedItemsString,',EXTERNALCONTACT,')>0
            OR instr(c_modifiedItemsString,',NOTESTOCANDIDATE,')>0
            OR instr(c_modifiedItemsString,',CATEGORY,')>0
            OR instr(c_modifiedItemsString,',STATUS,')>0;