APPS.GHR_CCL_SHD SQL Statements

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

Line: 53

    select
       compl_claim_id
      ,complaint_id
      ,claim
      ,incident_date
      ,phase
      ,mixed_flag
      ,claim_source
      ,agency_acceptance
      ,aj_acceptance
      ,agency_appeal
      ,object_version_number
    from        ghr_compl_claims
    where       compl_claim_id = p_compl_claim_id;

Line: 129

    select
       compl_claim_id
      ,complaint_id
      ,claim
      ,incident_date
      ,phase
      ,mixed_flag
      ,claim_source
      ,agency_acceptance
      ,aj_acceptance
      ,agency_appeal
      ,object_version_number
    from        ghr_compl_claims
    where       compl_claim_id = p_compl_claim_id
    for update nowait;