APPS.GHR_CAA_SHD SQL Statements

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

Line: 53

    select
       compl_agency_appeal_id
      ,complaint_id
      ,appeal_date
      ,reason_for_appeal
      ,source_decision_date
      ,docket_num
      ,agency_recvd_req_for_files
      ,files_due
      ,files_forwd
      ,agency_brief_due
      ,agency_brief_forwd
      ,agency_recvd_appellant_brief
      ,decision_date
      ,dec_recvd_by_agency
      ,decision
      ,dec_forwd_to_org
      ,agency_rfr_suspense
      ,request_for_rfr
      ,rfr_docket_num
      ,rfr_requested_by
      ,agency_rfr_due
      ,rfr_forwd_to_org
      ,org_forwd_rfr_to_agency
      ,agency_forwd_rfr_ofo
      ,rfr_decision_date
      ,agency_recvd_rfr_dec
      ,rfr_decision_forwd_to_org
      ,rfr_decision
      ,object_version_number
    from        ghr_compl_agency_appeals
    where       compl_agency_appeal_id = p_compl_agency_appeal_id;

Line: 147

    select
       compl_agency_appeal_id
      ,complaint_id
      ,appeal_date
      ,reason_for_appeal
      ,source_decision_date
      ,docket_num
      ,agency_recvd_req_for_files
      ,files_due
      ,files_forwd
      ,agency_brief_due
      ,agency_brief_forwd
      ,agency_recvd_appellant_brief
      ,decision_date
      ,dec_recvd_by_agency
      ,decision
      ,dec_forwd_to_org
      ,agency_rfr_suspense
      ,request_for_rfr
      ,rfr_docket_num
      ,rfr_requested_by
      ,agency_rfr_due
      ,rfr_forwd_to_org
      ,org_forwd_rfr_to_agency
      ,agency_forwd_rfr_ofo
      ,rfr_decision_date
      ,agency_recvd_rfr_dec
      ,rfr_decision_forwd_to_org
      ,rfr_decision
      ,object_version_number
    from        ghr_compl_agency_appeals
    where       compl_agency_appeal_id = p_compl_agency_appeal_id
    for update nowait;