6462: l_rul_id NUMBER := NULL;
6463:
6464: CURSOR l_qcl_csr IS
6465: SELECT qcl.id
6466: FROM OKC_QA_CHECK_LISTS_TL qcl,
6467: OKC_QA_CHECK_LISTS_B qclv
6468: WHERE qclv.Id = qcl.id
6469: AND UPPER(qcl.name) = 'OKL LA QA CHECK LIST'
6470: AND qcl.LANGUAGE = USERENV('LANG');
6627: AND chrb.id = p_chr_id;
6628:
6629: CURSOR l_pqcl_csr IS
6630: SELECT qcl.id
6631: FROM OKC_QA_CHECK_LISTS_TL qcl,
6632: OKC_QA_CHECK_LISTS_B qclv
6633: WHERE qclv.Id = qcl.id
6634: AND UPPER(qcl.name) = 'OKL KT for PA QA Checklist'
6635: AND qcl.LANGUAGE = 'US';
6635: AND qcl.LANGUAGE = 'US';
6636:
6637: CURSOR l_laqcl_csr IS
6638: SELECT qcl.id
6639: FROM OKC_QA_CHECK_LISTS_TL qcl,
6640: OKC_QA_CHECK_LISTS_B qclv
6641: WHERE qclv.Id = qcl.id
6642: AND UPPER(qcl.name) = 'OKL KT FOR LA QA CHECKLIST'
6643: AND qcl.LANGUAGE = 'US';