APPS.OKC_RENEW_PVT dependencies on OKC_K_PROCESSES

Line 2461: is select pdf_id from okc_k_processes kp, okc_process_defs_b pd where

2457: from OKC_K_HEADERS_b
2458: where id=p_chr_id;
2459:
2460: CURSOR cur_wf(p_chr_id number)
2461: is select pdf_id from okc_k_processes kp, okc_process_defs_b pd where
2462: kp.chr_id=p_chr_id and kp.pdf_id=pd.id and pd.usage='APPROVE';
2463:
2464: CURSOR cur_user(p_user_id number)
2465: is select fnd.user_name from okx_resources_v res, fnd_user fnd where