eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on OKC_PROCESS_DEFS_B

Line 380: from OKC_PROCESS_DEFS_B

376: l_status_type varchar2(100);
377: --
378: cursor process_def_csr is
379: select WF_NAME, WF_PROCESS_NAME, USAGE
380: from OKC_PROCESS_DEFS_B
381: where ID = p_process_id
382: and begin_date<=sysdate
383: and (end_date is NULL or end_date>=sysdate) and PDF_TYPE='WPS';
384: --

Line 390: from OKC_PROCESS_DEFS_B

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')
392: and item_key = l_key
393: and end_date is NULL;
394:

Line 927: from OKC_PROCESS_DEFS_B

923: l_admin varchar2(3);
924: --
925: cursor wf_name_csr is
926: select WF_NAME
927: from OKC_PROCESS_DEFS_B
928: where ID = p_process_id and PDF_TYPE='WPS';
929: --
930: cursor wf_key_csr is
931: select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key

Line 1010: from OKC_PROCESS_DEFS_B

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')
1012: and item_key = l_key
1013: and end_date is NULL;
1014: --