APPS.OKC_QA_CHECK_PVT dependencies on OKC_K_HEADERS_B

Line 121: OKC_K_HEADERS_B chr

117: CURSOR l_scs_csr IS
118: SELECT scs.cls_code,
119: chr.application_id
120: FROM OKC_SUBCLASSES_B scs,
121: OKC_K_HEADERS_B chr
122: WHERE scs.code = chr.scs_code
123: AND chr.id = p_chr_id;
124: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE;
125: l_appl_id OKC_K_HEADERS_B.APPLICATION_ID%TYPE;

Line 125: l_appl_id OKC_K_HEADERS_B.APPLICATION_ID%TYPE;

121: OKC_K_HEADERS_B chr
122: WHERE scs.code = chr.scs_code
123: AND chr.id = p_chr_id;
124: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE;
125: l_appl_id OKC_K_HEADERS_B.APPLICATION_ID%TYPE;
126:
127: -- cursor for the list of processes to be executed
128: CURSOR l_qlp_csr IS
129: select 1, pdf.name, pdf.description,

Line 194: OKC_K_HEADERS_B khr,

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,
198: okc_assents_v ass