APPS.IRC_CMR_SHD SQL Statements

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

Line: 48

    select
       communication_recipient_id
      ,communication_object_type
      ,communication_object_id
      ,recipient_type
      ,recipient_id
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        irc_comm_recipients
    where       communication_recipient_id = p_communication_recipient_id;

Line: 122

    select
       communication_recipient_id
      ,communication_object_type
      ,communication_object_id
      ,recipient_type
      ,recipient_id
      ,start_date_active
      ,end_date_active
      ,primary_flag
      ,object_version_number
    from        irc_comm_recipients
    where       communication_recipient_id = p_communication_recipient_id
    for update nowait;