207: select item_type
208: from WF_ITEMS
209: where item_type in
210: ( select wf_name
211: from OKC_PROCESS_DEFS_B
212: where USAGE='CHG_REQ_APPROVE' and PDF_TYPE='WPS')
213: and item_key = l_key
214: and end_date is NULL;
215: --
391: select item_type
392: from WF_ITEMS
393: where item_type in
394: ( select wf_name
395: from OKC_PROCESS_DEFS_B
396: where USAGE='CHG_REQ_APPROVE' and PDF_TYPE='WPS')
397: and item_key = l_key
398: and end_date is NULL;
399: --