APPS.GHR_CDT_SHD SQL Statements

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

Line: 53

    select
       compl_ca_detail_id
      ,compl_ca_header_id
      --,action
      ,amount
      ,order_date
      ,due_date
      ,request_date
      ,complete_date
      ,category
      --,type
      ,phase
      ,action_type
      ,payment_type
      ,object_version_number
      ,description
    from        ghr_compl_ca_details
    where       compl_ca_detail_id = p_compl_ca_detail_id;

Line: 133

    select
       compl_ca_detail_id
      ,compl_ca_header_id
      --,action
      ,amount
      ,order_date
      ,due_date
      ,request_date
      ,complete_date
      ,category
      --,type
      ,phase
      ,action_type
      ,payment_type
      ,object_version_number
      ,description
    from        ghr_compl_ca_details
    where       compl_ca_detail_id = p_compl_ca_detail_id
    for update nowait;