APPS.OKC_K_SIGN_ASMBLR_PVT SQL Statements

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

Line: 18

  SELECT enabled_yn
  FROM okc_actions_b
  WHERE correlation = p_correlation;

Line: 55

    SELECT k.contract_number contract_number
	  ,k.contract_number_modifier contract_number_modifier
	  ,k.date_signed date_signed
	  ,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: 69

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