APPS.OKE_VERSION_PUB SQL Statements

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

Line: 27

  select id
  from   okc_k_headers_b
  where  contract_number = p_Contract_Number
  and    (  ( (  p_Contract_Num_Modifier IS NULL
              or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )
            and  contract_number_modifier IS NULL )
         or ( contract_number_modifier = p_Contract_Num_Modifier )
         );

Line: 162

  select id
  from   okc_k_headers_b
  where  contract_number = p_Contract_Number
  and    (  ( (  p_Contract_Num_Modifier IS NULL
              or p_Contract_Num_Modifier = FND_API.G_MISS_CHAR )
            and  contract_number_modifier IS NULL )
         or ( contract_number_modifier = p_Contract_Num_Modifier )
         );