APPS.OKC_RENEW_PVT dependencies on OKX_RESOURCES_V

Line 2465: is select fnd.user_name from okx_resources_v res, fnd_user fnd where

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
2466: fnd.user_id=res.user_id and res.id1=p_user_id;
2467:
2468: CURSOR cur_header_aa IS
2469: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code