DBA Data[Home] [Help]

APPS.GHR_CBA_SHD SQL Statements

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

Line: 53

    select
       compl_basis_id
      ,compl_claim_id
      ,basis
      ,value
      ,statute
      ,agency_finding
      ,aj_finding
      ,object_version_number
    from        ghr_compl_bases
    where       compl_basis_id = p_compl_basis_id;
Line: 126

    select
       compl_basis_id
      ,compl_claim_id
      ,basis
      ,value
      ,statute
      ,agency_finding
      ,aj_finding
      ,object_version_number
    from        ghr_compl_bases
    where       compl_basis_id = p_compl_basis_id
    for update nowait;