APPS.OKC_QA_CHECK_PVT dependencies on OKC_PROCESS_DEFS_V

Line 132: from OKC_PROCESS_DEFS_V pdf,

128: CURSOR l_qlp_csr IS
129: select 1, pdf.name, pdf.description,
130: pdf.package_name, pdf.procedure_name, qlp.pdf_id,
131: qlp.run_sequence, qlp.severity
132: from OKC_PROCESS_DEFS_V pdf,
133: OKC_QA_LIST_PROCESSES qlp
134: -- OKC_QA_CHECK_LISTS_TL qcl
135: where pdf.id = qlp.pdf_id
136: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)

Line 151: from OKC_PROCESS_DEFS_V pdf

147: union all
148: select 2, pdf.name, pdf.description,
149: pdf.package_name, pdf.procedure_name,
150: -1, rownum, 'S'
151: from OKC_PROCESS_DEFS_V pdf
152: where pdf.package_name = 'OKS_QA_DATA_INTEGRITY'
153: and l_cls_code = 'SERVICE'
154: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)
155: and p_override_flag = 'N'

Line 162: from OKC_PROCESS_DEFS_V pdf,

158: union all
159: select 3, pdf.name, pdf.description,
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

Line 179: from OKC_PROCESS_DEFS_V pdf,

175: union all
176: select 4, pdf.name, pdf.description,
177: pdf.package_name, pdf.procedure_name, qlp.pdf_id,
178: qlp.run_sequence, qlp.severity
179: from OKC_PROCESS_DEFS_V pdf,
180: OKC_QA_LIST_PROCESSES qlp
181: -- OKC_QA_CHECK_LISTS_TL qcl
182: where pdf.id = qlp.pdf_id
183: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)

Line 196: from OKC_PROCESS_DEFS_V pdf,

192: -- contract category has any operation of purpose 'INTEGRATION' defined in it.
193: union all
194: select 5, pdf.name, pdf.description, pdf.package_name, pdf.procedure_name,
195: cop.qa_pdf_id, OKC_API.G_MISS_NUM, 'S'
196: from OKC_PROCESS_DEFS_V pdf,
197: OKC_K_HEADERS_B khr,
198: OKC_SUBCLASSES_B scs,
199: OKC_CLASS_OPERATIONS cop,
200: OKC_OPERATIONS_B op,