APPS.OKC_QA_PROCS SQL Statements

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

Line: 22

      SELECT count(*)
        FROM OKC_K_PARTY_ROLES_B cpl
       WHERE cpl.dnz_chr_id = p_chr_id
       and cpl.cle_id is NULL;

Line: 88

      SELECT count(*)
        FROM OKC_K_LINES_B cle
       WHERE cle.chr_id = p_chr_id;