DBA Data[Home] [Help]

APPS.OKS_WF_K_APPROVE dependencies on OKC_K_PROCESSES

Line 2178: FROM okc_k_processes

2174: IS
2175: CURSOR csr_process_id(p_contract_id IN NUMBER)
2176: IS
2177: SELECT id
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

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

2265:
2266: -- Start of comments
2267: --
2268: -- Procedure Name : update_invalid_approver
2269: -- Description : update_invalid_approver error code in IN_PROCESS_YN field of OKC_K_PROCESSES
2270: -- Business Rules :
2271: -- Parameters :
2272: -- Version : 1.0
2273: -- End of comments

Line 2284: FROM okc_k_processes

2280: IS
2281: CURSOR csr_process_id(p_contract_id IN NUMBER)
2282: IS
2283: SELECT id, in_process_yn
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