APPS.OKC_CEVT_ASMBLR_PVT SQL Statements

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

Line: 30

 SELECT aae.element_name, aae.format_mask
 FROM okc_actions_v acn,okc_action_attributes_v aae
 WHERE acn.id = aae.acn_id
 AND acn.correlation = 'CONT_EVT_REC';

Line: 37

 SELECT khr.id k_id,
	khr.contract_number k_number,
	khr.contract_number_modifier k_nbr_mod,
	cls.cls_code k_class,
	khr.scs_code k_subclass,
	khr.estimated_amount k_estimated_amount,
	khr.sts_code
  FROM   okc_k_headers_v khr,okc_subclasses_v cls
  WHERE khr.id = p_chr_id
  AND khr.scs_code = cls.code;