DBA Data[Home] [Help]

APPS.OKC_WF_K_APPROVE dependencies on OKC_K_PROCESSES

Line 1933: FROM okc_k_processes

1929: IS
1930: CURSOR csr_process_id(p_contract_id IN NUMBER)
1931: IS
1932: SELECT id
1933: FROM okc_k_processes
1934: WHERE chr_id = p_contract_id
1935: /*Bug 3255018 AND pdf_id = (SELECT id */
1936: AND pdf_id in (SELECT id
1937: FROM OKC_PROCESS_DEFS_V

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

2020:
2021: -- Start of comments
2022: --
2023: -- Procedure Name : update_invalid_approver
2024: -- Description : update_invalid_approver error code in IN_PROCESS_YN field of OKC_K_PROCESSES
2025: -- Business Rules :
2026: -- Parameters :
2027: -- Version : 1.0
2028: -- End of comments

Line 2039: FROM okc_k_processes

2035: IS
2036: CURSOR csr_process_id(p_contract_id IN NUMBER)
2037: IS
2038: SELECT id, in_process_yn
2039: FROM okc_k_processes
2040: WHERE chr_id = p_contract_id
2041: /*Bug 3255018 AND pdf_id = (SELECT id */
2042: AND pdf_id in (SELECT id
2043: FROM OKC_PROCESS_DEFS_V