DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on OKC_PROCESS_DEFS_B

Line 128: OKC_PROCESS_DEFS_B PDF

124: --
125: cursor process_def_csr is
126: select PDF.ID, PDF.WF_NAME, PDF.WF_PROCESS_NAME, PDF.USAGE
127: from okc_k_processes KP,
128: OKC_PROCESS_DEFS_B PDF
129: where KP.crt_id = p_change_request_id
130: and PDF.ID = KP.PDF_ID
131: and PDF.begin_date<=sysdate
132: and (PDF.end_date is NULL or PDF.end_date>=sysdate)

Line 830: from OKC_PROCESS_DEFS_B

826: select item_type
827: from WF_ITEMS
828: where item_type in
829: ( select wf_name
830: from OKC_PROCESS_DEFS_B
831: where USAGE='CHG_REQ_APPROVE' and PDF_TYPE = 'WPS')
832: and item_key = l_key
833: and end_date is NULL;
834: begin