APPS.OKC_K_STS_CHG_ASMBLR_PVT SQL Statements

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

Line: 37

 SELECT aae.element_name
	   ,aae.format_mask format_mask
   FROM okc_actions_b acn,okc_action_attributes_b aae
  WHERE acn.id = aae.acn_id
    AND acn.correlation = 'K_STS_CHANGE' ;

Line: 45

    SELECT to_char (major_version)||'.'||to_char(minor_version)
    FROM okc_k_vers_numbers
    WHERE chr_id=p_chr_id;

Line: 214

 SELECT aae.element_name
	   ,aae.format_mask format_mask
   FROM okc_actions_b acn,okc_action_attributes_b aae
  WHERE acn.id = aae.acn_id
    AND acn.correlation = 'K_STS_CHANGE' ;

Line: 222

    SELECT to_char (major_version)||'.'||to_char(minor_version)
    FROM okc_k_vers_numbers
    WHERE chr_id=p_chr_id;