[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
complaint_id
,complainant_person_id
,business_group_id
,docket_number
,stage
,class_flag
,mixed_flag
,consolidated_flag
,remand_flag
,active_flag
,information_inquiry
,pcom_init
,alleg_incident
,alleg_discrim_org_id
,rr_ltr_date
,rr_ltr_recvd
,pre_com_elec
--,adr_offered
,class_agent_flag
,pre_com_desc
,counselor_asg
,init_counselor_interview
,anonymity_requested
,counsel_ext_ltr
,traditional_counsel_outcome
,final_interview
,notice_rtf_recvd
,precom_closed
,precom_closure_nature
,counselor_rpt_sub
,hr_office_org_id
,eeo_office_org_id
,serviced_org_id
,formal_com_filed
,ack_ltr
,clarification_ltr_date
,clarification_response_recvd
,forwarded_legal_review
,returned_from_legal
,letter_type
,letter_date
,letter_recvd
,investigation_source
,investigator_recvd_req
,agency_investigator_req
,investigator_asg
,investigation_start
,investigation_end
,investigation_extended
,invest_extension_desc
,agency_recvd_roi
,comrep_recvd_roi
,options_ltr_date
,comrep_recvd_opt_ltr
,comrep_opt_ltr_response
,resolution_offer
,comrep_resol_offer_recvd
,comrep_resol_offer_response
,comrep_resol_offer_desc
,resol_offer_signed
,resol_offer_desc
,hearing_source
,agency_notified_hearing
,eeoc_hearing_docket_num
,hearing_complete
,aj_merit_decision_date
,agency_recvd_aj_merit_dec
,aj_merit_decision
,aj_ca_decision_date
,agency_recvd_aj_ca_dec
,aj_ca_decision
,fad_requested
,merit_fad
,attorney_fees_fad
,comp_damages_fad
,non_compliance_fad
,fad_req_recvd_eeo_office
,fad_req_forwd_to_agency
,agency_recvd_request
,fad_due
,fad_date
,fad_decision
--,fad_final_action_closure
,fad_forwd_to_comrep
,fad_recvd_by_comrep
,fad_imp_ltr_forwd_to_org
,fad_decision_forwd_legal
,fad_decision_recvd_legal
,fa_source
,final_action_due
--,final_action_nature_of_closure
,final_act_forwd_comrep
,final_act_recvd_comrep
,final_action_decision_date
,final_action_decision
,fa_imp_ltr_forwd_to_org
,fa_decision_forwd_legal
,fa_decision_recvd_legal
,civil_action_filed
,agency_closure_confirmed
,consolidated_complaint_id
,consolidated
,stage_of_consolidation
,comrep_notif_consolidation
,consolidation_desc
,complaint_closed
,nature_of_closure
,complaint_closed_desc
,filed_formal_class
,forwd_eeoc
,aj_cert_decision_date
,aj_cert_decision_recvd
,aj_cert_decision
,class_members_notified
,number_of_complaintants
,class_hearing
,aj_dec
,agency_recvd_aj_dec
,aj_decision
,object_version_number
,agency_brief_eeoc
,agency_notif_of_civil_action
,fad_source
,agency_files_forwarded_eeoc
,hearing_req
,agency_code
,audited_by
,record_received
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
from ghr_complaints2
where complaint_id = p_complaint_id;
select
complaint_id
,complainant_person_id
,business_group_id
,docket_number
,stage
,class_flag
,mixed_flag
,consolidated_flag
,remand_flag
,active_flag
,information_inquiry
,pcom_init
,alleg_incident
,alleg_discrim_org_id
,rr_ltr_date
,rr_ltr_recvd
,pre_com_elec
--,adr_offered
,class_agent_flag
,pre_com_desc
,counselor_asg
,init_counselor_interview
,anonymity_requested
,counsel_ext_ltr
,traditional_counsel_outcome
,final_interview
,notice_rtf_recvd
,precom_closed
,precom_closure_nature
,counselor_rpt_sub
,hr_office_org_id
,eeo_office_org_id
,serviced_org_id
,formal_com_filed
,ack_ltr
,clarification_ltr_date
,clarification_response_recvd
,forwarded_legal_review
,returned_from_legal
,letter_type
,letter_date
,letter_recvd
,investigation_source
,investigator_recvd_req
,agency_investigator_req
,investigator_asg
,investigation_start
,investigation_end
,investigation_extended
,invest_extension_desc
,agency_recvd_roi
,comrep_recvd_roi
,options_ltr_date
,comrep_recvd_opt_ltr
,comrep_opt_ltr_response
,resolution_offer
,comrep_resol_offer_recvd
,comrep_resol_offer_response
,comrep_resol_offer_desc
,resol_offer_signed
,resol_offer_desc
,hearing_source
,agency_notified_hearing
,eeoc_hearing_docket_num
,hearing_complete
,aj_merit_decision_date
,agency_recvd_aj_merit_dec
,aj_merit_decision
,aj_ca_decision_date
,agency_recvd_aj_ca_dec
,aj_ca_decision
,fad_requested
,merit_fad
,attorney_fees_fad
,comp_damages_fad
,non_compliance_fad
,fad_req_recvd_eeo_office
,fad_req_forwd_to_agency
,agency_recvd_request
,fad_due
,fad_date
,fad_decision
--,fad_final_action_closure
,fad_forwd_to_comrep
,fad_recvd_by_comrep
,fad_imp_ltr_forwd_to_org
,fad_decision_forwd_legal
,fad_decision_recvd_legal
,fa_source
,final_action_due
--,final_action_nature_of_closure
,final_act_forwd_comrep
,final_act_recvd_comrep
,final_action_decision_date
,final_action_decision
,fa_imp_ltr_forwd_to_org
,fa_decision_forwd_legal
,fa_decision_recvd_legal
,civil_action_filed
,agency_closure_confirmed
,consolidated_complaint_id
,consolidated
,stage_of_consolidation
,comrep_notif_consolidation
,consolidation_desc
,complaint_closed
,nature_of_closure
,complaint_closed_desc
,filed_formal_class
,forwd_eeoc
,aj_cert_decision_date
,aj_cert_decision_recvd
,aj_cert_decision
,class_members_notified
,number_of_complaintants
,class_hearing
,aj_dec
,agency_recvd_aj_dec
,aj_decision
,object_version_number
,agency_brief_eeoc
,agency_notif_of_civil_action
,fad_source
,agency_files_forwarded_eeoc
,hearing_req
,agency_code
,audited_by
,record_received
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
from ghr_complaints2
where complaint_id = p_complaint_id
for update nowait;