APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKC_PROCESS_DEFS_V

Line 6133: SELECT NAME FROM okc_process_defs_v dv, okc_k_processes ps

6129: l_wf_name VARCHAR2(200);
6130:
6131:
6132: CURSOR l_wf IS
6133: SELECT NAME FROM okc_process_defs_v dv, okc_k_processes ps
6134: WHERE ps.pdf_id = dv.id
6135: AND ps.chr_id= p_chr_id
6136: AND ps.last_update_date =
6137: (SELECT max(last_update_date) FROM okc_k_processes