APPS.OKC_CRQUOTE_ASMBLR_PVT SQL Statements

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

Line: 24

    SELECT k.contract_number contract_number
	  ,k.contract_number_modifier contract_number_modifier
	  ,k.estimated_amount estimated_amount
	  ,k.sts_code sts_code
	  ,c.cls_code cls_code
	  ,c.code subcls_code
    FROM  okc_k_headers_b k,
          okc_subclasses_v c
    WHERE k.scs_code = c.code
    AND   k.id = p_contract_id;

Line: 37

    SELECT aae.element_name 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 = 'KCRQUOTE';