APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_QA_CHECK_LISTS_TL

Line 6628: FROM OKC_QA_CHECK_LISTS_TL qcl,

6624: l_rul_id NUMBER := NULL;
6625:
6626: CURSOR l_qcl_csr IS
6627: SELECT qcl.id
6628: FROM OKC_QA_CHECK_LISTS_TL qcl,
6629: OKC_QA_CHECK_LISTS_B qclv
6630: WHERE qclv.Id = qcl.id
6631: AND UPPER(qcl.name) = 'OKL LA QA CHECK LIST'
6632: AND qcl.LANGUAGE = USERENV('LANG');

Line 6792: FROM OKC_QA_CHECK_LISTS_TL qcl,

6788: AND chrb.id = p_chr_id;
6789:
6790: CURSOR l_pqcl_csr IS
6791: SELECT qcl.id
6792: FROM OKC_QA_CHECK_LISTS_TL qcl,
6793: OKC_QA_CHECK_LISTS_B qclv
6794: WHERE qclv.Id = qcl.id
6795: AND UPPER(qcl.name) = 'OKL KT for PA QA Checklist'
6796: AND qcl.LANGUAGE = 'US';

Line 6800: FROM OKC_QA_CHECK_LISTS_TL qcl,

6796: AND qcl.LANGUAGE = 'US';
6797:
6798: CURSOR l_laqcl_csr IS
6799: SELECT qcl.id
6800: FROM OKC_QA_CHECK_LISTS_TL qcl,
6801: OKC_QA_CHECK_LISTS_B qclv
6802: WHERE qclv.Id = qcl.id
6803: AND UPPER(qcl.name) = 'OKL KT FOR LA QA CHECKLIST'
6804: AND qcl.LANGUAGE = 'US';