DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_PVT dependencies on OKC_CLASS_OPERATIONS

Line 191: -- Bug 2170973 ,This following query added to execute qa_pdf_id of okc_class_operations if

187: -- and qlp.qcl_id = qcl.id
188: -- and qcl.id = p_qcl_id
189: -- and qcl.name <> G_DEFAULT_QA_CHECK_LIST
190: -- and qcl.language = userenv('LANG')
191: -- Bug 2170973 ,This following query added to execute qa_pdf_id of okc_class_operations if
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'

Line 199: OKC_CLASS_OPERATIONS cop,

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,
201: okc_assents_v ass
202: where pdf.id = cop.qa_pdf_id
203: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)