DBA Data[Home] [Help]

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 197: OKC_K_HEADERS_B khr,

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'
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