DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_PVT dependencies on OKC_QA_LIST_PROCESSES

Line 133: OKC_QA_LIST_PROCESSES qlp

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)
137: and qlp.active_yn = 'Y'

Line 160: OKC_QA_LIST_PROCESSES qlp,

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
164: and sysdate between pdf.begin_date and nvl(pdf.end_date,sysdate)

Line 177: OKC_QA_LIST_PROCESSES qlp

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)
181: and qlp.active_yn = 'Y'