[Home] [Help]
693: AND okck.id = p_chr_id
694: AND NOT EXISTS
695: (SELECT 1
696: FROM WF_ITEMS WF,
697: OKC_PROCESS_DEFS_B KPDF
698: WHERE WF.item_key = okck.contract_number || okck.contract_number_modifier
699: AND WF.end_date IS NULL
700: AND WF.item_type = KPDF.wf_name
701: AND KPDF.pdf_type = 'WPS');