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 164: OKC_QA_CHECK_LISTS_B qcl

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