APPS.OKC_SCHR_AD_ASMBLR_PVT SQL Statements

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

Line: 27

 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 = 'SHR_ADATE_REC' ;

Line: 35

 select rul.id rule_id,
        rul.dnz_chr_id,
        rul.rule_information1 rule_name
 from okc_resolved_timevalues res, okc_rules_b rul
 where res.id = p_rtve_id
 and to_char(res.tve_id) = rul.rule_information2
 and rul.rule_information_category = 'NTN';

Line: 45

 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_b khr,okc_subclasses_b cls
  WHERE khr.id = p_chr_id
  AND khr.scs_code = cls.code;