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 148: from OKC_PROCESS_DEFS_V pdf

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

Line 159: from OKC_PROCESS_DEFS_V pdf,

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

Line 176: from OKC_PROCESS_DEFS_V pdf,

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

Line 193: from OKC_PROCESS_DEFS_V pdf,

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