APPS.OKC_QA_GENERAL_CHECKLISTS SQL Statements

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

Line: 20

  select currency_code, sts_code
  from okc_k_headers_b
  where id = p_chr_id;

Line: 94

		SELECT FROM_TABLE, WHERE_CLAUSE
		FROM JTF_OBJECTS_B
		WHERE OBJECT_CODE = p_object_code;

Line: 111

       	      l_sql_stmt := 'SELECT email_address FROM ' || l_from_table ||
			    ' WHERE ID1 = :id_1 AND ID2 = :id2';

Line: 160

  select c.jtot_object1_code, c.object1_id1, c.object1_id2
    from okc_contacts c, okc_k_party_roles_b p
   where c.cpl_id = p.id
     and p.dnz_chr_id = p_chr_id
     and p.cle_id is null;

Line: 272

  select c.jtot_object1_code, c.object1_id1, c.object1_id2
    from okc_contacts c
   where c.cpl_id = p_cpl_id
     and c.dnz_chr_id = p_chr_id;

Line: 278

  select id
    from okc_k_party_roles_b
   where rle_code = p_rle_code
     and dnz_chr_id = p_chr_id
     and cle_id is null;

Line: 285

  select 'X'
  from okc_contacts c, okc_k_party_roles_b p
  where p.id = c.cpl_id
    and p.dnz_chr_id = p_chr_id
    and p.rle_code   = p_rle_code; */