APPS.OKC_CPS_PVT dependencies on OKC_PROCESS_DEFS_B

Line 31: from OKC_PROCESS_DEFS_B

27:
28: l_dummy_var VARCHAR2(1) := '?';
29: Cursor l_pdfv_csr Is
30: select 'x'
31: from OKC_PROCESS_DEFS_B
32: where ID = p_cpsv_rec.pdf_id;
33: Begin
34: -- initialize return status
35: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 798: from okc_k_processes cps, okc_process_defs_b pdfb

794: -- l_unq_tbl OKC_UTIL.unq_tbl_type;
795:
796: Cursor l_cps_csr Is
797: select count(1)
798: from okc_k_processes cps, okc_process_defs_b pdfb
799: where cps.pdf_id = pdfb.id
800: and cps.chr_id = p_cpsv_rec.chr_id
801: and pdfb.usage='APPROVE' and pdfb.pdf_type='WPS'
802: and cps.id <> p_cpsv_rec.id;