APPS.GHR_CST_SHD SQL Statements

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

Line: 48

    select
       compl_agency_cost_id
      ,complaint_id
      ,phase
      ,stage
      ,category
      ,amount
      ,cost_date
      ,description
      ,object_version_number
    from        ghr_compl_agency_costs
    where       compl_agency_cost_id = p_compl_agency_cost_id;

Line: 122

    select
       compl_agency_cost_id
      ,complaint_id
      ,phase
      ,stage
      ,category
      ,amount
      ,cost_date
      ,description
      ,object_version_number
    from        ghr_compl_agency_costs
    where       compl_agency_cost_id = p_compl_agency_cost_id
    for update nowait;