DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_PVT dependencies on OKC_CLASS_OPERATIONS

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

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

Line 196: OKC_CLASS_OPERATIONS cop,

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