APPS.IRC_IOS_SHD SQL Statements

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

Line: 58

    select
       offer_status_history_id
      ,offer_id
      ,status_change_date
      ,offer_status
      ,change_reason
      ,decline_reason
      ,object_version_number
    from        irc_offer_status_history
    where       offer_status_history_id = p_offer_status_history_id;

Line: 130

    select
       offer_status_history_id
      ,offer_id
      ,status_change_date
      ,offer_status
      ,change_reason
      ,decline_reason
      ,object_version_number
    from        irc_offer_status_history
    where       offer_status_history_id = p_offer_status_history_id
    for update nowait;