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.OKE_CONTRACT_APPROVAL_PVT dependencies on OKC_PROCESS_DEFS_B

Line 97: from OKC_PROCESS_DEFS_B

93: l_status_type varchar2(100);
94: --
95: cursor process_def_csr is
96: select WF_NAME, WF_PROCESS_NAME, USAGE
97: from OKC_PROCESS_DEFS_B
98: where ID = p_process_id
99: and begin_date<=sysdate
100: and (end_date is NULL or end_date>=sysdate) and PDF_TYPE='WPS';
101: --

Line 107: from OKC_PROCESS_DEFS_B

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')
109: and item_key = l_key
110: and end_date is NULL;
111:

Line 583: from OKC_PROCESS_DEFS_B

579: l_admin varchar2(3);
580: --
581: cursor wf_name_csr is
582: select WF_NAME
583: from OKC_PROCESS_DEFS_B
584: where ID = p_process_id and PDF_TYPE='WPS';
585: --
586: cursor wf_key_csr is
587: select CONTRACT_NUMBER||CONTRACT_NUMBER_MODIFIER wf_key

Line 665: from OKC_PROCESS_DEFS_B

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')
667: and item_key = l_key
668: and end_date is NULL;
669: --