DBA Data[Home] [Help]

APPS.OKS_WF_K_APPROVE dependencies on OKC_PROCESS_DEFS_V

Line 2233: FROM OKC_PROCESS_DEFS_V

2229: FROM okc_k_processes
2230: WHERE chr_id = p_contract_id
2231: /*Bug 3255018 AND pdf_id = (SELECT id */
2232: AND pdf_id in (SELECT id
2233: FROM OKC_PROCESS_DEFS_V
2234: WHERE usage = 'APPROVE'
2235: AND PDF_TYPE = 'WPS'
2236: AND WF_NAME = 'OKCAUKAP');
2237:

Line 2339: FROM OKC_PROCESS_DEFS_V

2335: FROM okc_k_processes
2336: WHERE chr_id = p_contract_id
2337: /*Bug 3255018 AND pdf_id = (SELECT id */
2338: AND pdf_id in (SELECT id
2339: FROM OKC_PROCESS_DEFS_V
2340: WHERE usage = 'APPROVE'
2341: AND PDF_TYPE = 'WPS'
2342: AND WF_NAME = 'OKCAUKAP');
2343: