DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on OKC_K_PROCESSES

Line 3312: FROM okc_k_processes

3308: l_error_text VARCHAR2(512);
3309:
3310: CURSOR c_pdf(cp_chr_id NUMBER) IS
3311: SELECT id, pdf_id
3312: FROM okc_k_processes
3313: WHERE chr_id = cp_chr_id
3314: AND pdf_id IN (SELECT id FROM okc_process_defs_b WHERE pdf_type = 'WPS' AND usage = 'APPROVE');
3315:
3316: l_id NUMBER;