DBA Data[Home] [Help]

APPS.GHR_CIN_SHD SQL Statements

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

Line: 53

    select
       compl_incident_id
      ,compl_claim_id
      ,incident_date
      ,description
      ,date_amended
      ,date_acknowledged
      ,object_version_number
    from        ghr_compl_incidents
    where       compl_incident_id = p_compl_incident_id;
Line: 125

    select
       compl_incident_id
      ,compl_claim_id
      ,incident_date
      ,description
      ,date_amended
      ,date_acknowledged
      ,object_version_number
    from        ghr_compl_incidents
    where       compl_incident_id = p_compl_incident_id
    for update nowait;