DBA Data[Home] [Help]

APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on WF_ITEMS

Line 104: from WF_ITEMS

100: and (end_date is NULL or end_date>=sysdate) and PDF_TYPE='WPS';
101: --
102: cursor approval_active_csr is
103: select item_type
104: from WF_ITEMS
105: where item_type in
106: ( select wf_name
107: from OKC_PROCESS_DEFS_B
108: where USAGE='APPROVE' and PDF_TYPE='WPS')

Line 115: from WF_ITEMS

111:
112: --
113: cursor for_purge_csr is
114: select '!'
115: from WF_ITEMS
116: where item_type = l_wf_name
117: and item_key = l_key;
118: --
119: cursor defined_parameters_csr is

Line 593: from WF_ITEMS

589: where ID = p_contract_id;
590: --
591: cursor wf_exist_csr is
592: select '!'
593: from WF_ITEMS
594: where item_type = l_wf_name
595: and item_key = l_key;
596: --
597: begin

Line 662: from WF_ITEMS

658: where ID = p_contract_id;
659: --
660: cursor approval_active_csr is
661: select item_type
662: from WF_ITEMS
663: where item_type in
664: ( select wf_name
665: from OKC_PROCESS_DEFS_B
666: where USAGE='APPROVE' and PDF_TYPE='WPS')