APPS.OKC_QA_CHECK_PVT dependencies on OKC_QA_CHECK_LISTS_B

Line 22: FROM OKC_QA_CHECK_LISTS_B qclv

18: ) IS
19: l_dummy_var VARCHAR2(1) := '?';
20: CURSOR l_qclv_csr IS
21: SELECT 'x'
22: FROM OKC_QA_CHECK_LISTS_B qclv
23: WHERE qclv.ID = p_qcl_id;
24: BEGIN
25: -- initialize return status
26: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 161: OKC_QA_CHECK_LISTS_B qcl

157: pdf.package_name, pdf.procedure_name, qlp.pdf_id,
158: qlp.run_sequence, qlp.severity
159: from OKC_PROCESS_DEFS_V pdf,
160: OKC_QA_LIST_PROCESSES qlp,
161: OKC_QA_CHECK_LISTS_B qcl
162: -- OKC_QA_CHECK_LISTS_v qcl
163: where pdf.id = qlp.pdf_id
164: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)
165: and qlp.active_yn = 'Y'