APPS.IRC_CMC_SHD SQL Statements

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

Line: 53

    select
       communication_id
      ,communication_property_id
      ,object_type
      ,object_id
      ,status
      ,start_date
      ,end_date
      ,object_version_number
    from        irc_communications
    where       communication_id = p_communication_id;

Line: 126

    select
       communication_id
      ,communication_property_id
      ,object_type
      ,object_id
      ,status
      ,start_date
      ,end_date
      ,object_version_number
    from        irc_communications
    where       communication_id = p_communication_id
    for update nowait;