APPS.OKS_WF_K_APPROVE dependencies on OKC_PROCESS_DEFS_V

Line 2182: FROM OKC_PROCESS_DEFS_V

2178: FROM okc_k_processes
2179: WHERE chr_id = p_contract_id
2180: /*Bug 3255018 AND pdf_id = (SELECT id */
2181: AND pdf_id in (SELECT id
2182: FROM OKC_PROCESS_DEFS_V
2183: WHERE usage = 'APPROVE'
2184: AND PDF_TYPE = 'WPS'
2185: AND WF_NAME = 'OKCAUKAP');
2186:

Line 2288: FROM OKC_PROCESS_DEFS_V

2284: FROM okc_k_processes
2285: WHERE chr_id = p_contract_id
2286: /*Bug 3255018 AND pdf_id = (SELECT id */
2287: AND pdf_id in (SELECT id
2288: FROM OKC_PROCESS_DEFS_V
2289: WHERE usage = 'APPROVE'
2290: AND PDF_TYPE = 'WPS'
2291: AND WF_NAME = 'OKCAUKAP');
2292: