DBA Data[Home] [Help]

APPS.OKC_QA_CHECK_PVT dependencies on OKC_SUBCLASSES_B

Line 120: FROM OKC_SUBCLASSES_B scs,

116:
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;

Line 124: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE;

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;
126:
127: -- cursor for the list of processes to be executed
128: CURSOR l_qlp_csr IS

Line 198: OKC_SUBCLASSES_B scs,

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
202: where pdf.id = cop.qa_pdf_id