APPS.IRC_NOTIFICATION_WORKFLOW_PKG SQL Statements

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

Line: 300

          select function_id from fnd_form_functions
                  where function_name = p_function_name;

Line: 504

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

Line: 531

      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: 541

      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: 551

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

Line: 657

       select NLS_LANGUAGE
         from fnd_languages_vl
        where language_code = p_dft_lang;

Line: 661

        select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
          from fnd_user usr
          where user_name = p_user_name;

Line: 665

        select message_name
        from fnd_new_messages
        where message_name = c_messageName
        and language_code = ( select language_code
                              from fnd_languages_vl
                              where nls_language = c_language );

Line: 876

      select count(*)
        from wf_roles
       where c_orig_system = orig_system
         and c_orig_system_id = orig_system_id
         and status = 'ACTIVE';

Line: 909

      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;

Line: 972

      select timezone_code
        from fnd_timezones_vl
       where name = c_timezoneNameIn
        and rownum < 2;