DBA Data[Home] [Help]

APPS.OKS_WF_K_APPROVE dependencies on OKC_K_PROCESSES

Line 2229: FROM okc_k_processes

2225: IS
2226: CURSOR csr_process_id(p_contract_id IN NUMBER)
2227: IS
2228: SELECT id
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

Line 2320: -- Description : update_invalid_approver error code in IN_PROCESS_YN field of OKC_K_PROCESSES

2316:
2317: -- Start of comments
2318: --
2319: -- Procedure Name : update_invalid_approver
2320: -- Description : update_invalid_approver error code in IN_PROCESS_YN field of OKC_K_PROCESSES
2321: -- Business Rules :
2322: -- Parameters :
2323: -- Version : 1.0
2324: -- End of comments

Line 2335: FROM okc_k_processes

2331: IS
2332: CURSOR csr_process_id(p_contract_id IN NUMBER)
2333: IS
2334: SELECT id, in_process_yn
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