DBA Data[Home] [Help]

APPS.OKC_CHANGE_CONTRACT_PVT dependencies on WF_ITEMS

Line 140: from WF_ITEMS

136: l_q varchar2(1);
137: --
138: cursor for_purge_csr is
139: select '!'
140: from WF_ITEMS
141: where item_type = l_wf_name
142: and item_key = l_key;
143: --
144: -- because of bug in lock API

Line 755: from WF_ITEMS

751: l_q varchar2(1);
752: --
753: cursor wf_exist_csr is
754: select '!'
755: from WF_ITEMS
756: where item_type = l_wf_name
757: and item_key = l_key;
758: --
759: --

Line 827: from WF_ITEMS

823: l_wf_name_active varchar2(150);
824: --
825: cursor approval_active_csr is
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')