DBA Data[Home] [Help]

APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on WF_ITEMS

Line 387: from WF_ITEMS

383: and (end_date is NULL or end_date>=sysdate) and PDF_TYPE='WPS';
384: --
385: cursor approval_active_csr is
386: select item_type
387: from WF_ITEMS
388: where item_type in
389: ( select wf_name
390: from OKC_PROCESS_DEFS_B
391: where USAGE='APPROVE' and PDF_TYPE='WPS')

Line 398: from WF_ITEMS

394:
395: --
396: cursor for_purge_csr is
397: select '!'
398: from WF_ITEMS
399: where item_type = l_wf_name
400: and item_key = l_key;
401: --
402: cursor defined_parameters_csr is

Line 937: from WF_ITEMS

933: where ID = p_contract_id;
934: --
935: cursor wf_exist_csr is
936: select '!'
937: from WF_ITEMS
938: where item_type = l_wf_name
939: and item_key = l_key;
940: --
941: begin

Line 1007: from WF_ITEMS

1003: where ID = p_contract_id;
1004: --
1005: cursor approval_active_csr is
1006: select item_type
1007: from WF_ITEMS
1008: where item_type in
1009: ( select wf_name
1010: from OKC_PROCESS_DEFS_B
1011: where USAGE='APPROVE' and PDF_TYPE='WPS')