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 163: OKC_QA_LIST_PROCESSES qlp,

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

Line 180: OKC_QA_LIST_PROCESSES qlp

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