APPS.OKS_WF_K_APPROVE dependencies on DUAL

Line 222: (select 1 num, l_approver role, '' name from dual

218:
219: cursor Next_Informed_csr is
220: select role, name from -- here should be your view
221: ------------------------------------------------------
222: (select 1 num, l_approver role, '' name from dual
223: where l_approver is not NULL
224: union all
225: select 2 num, l_initiator role, '' name from dual
226: where not exists

Line 225: select 2 num, l_initiator role, '' name from dual

221: ------------------------------------------------------
222: (select 1 num, l_approver role, '' name from dual
223: where l_approver is not NULL
224: union all
225: select 2 num, l_initiator role, '' name from dual
226: where not exists
227: (select 1 from wf_user_roles
228: where user_name=l_initiator
229: and USER_ORIG_SYSTEM IN ('PER','FND_USR')

Line 237: (select 1 num, l_approver role, '' name from dual

233: ------------------------------------------------------
234: where (p_current is NULL
235: or num > (select num from -- same view
236: ------------------------------------------------------
237: (select 1 num, l_approver role, '' name from dual
238: where l_approver is not NULL
239: union all
240: select 2 num, l_initiator role, '' name from dual
241: where not exists

Line 240: select 2 num, l_initiator role, '' name from dual

236: ------------------------------------------------------
237: (select 1 num, l_approver role, '' name from dual
238: where l_approver is not NULL
239: union all
240: select 2 num, l_initiator role, '' name from dual
241: where not exists
242: (select 1 from wf_user_roles
243: where user_name=l_initiator
244: and USER_ORIG_SYSTEM IN ('PER','FND_USR')

Line 2076: FROM dual;

2072: l_api_version NUMBER :=1.0 ;
2073: l_session_id number;
2074: CURSOR csr_session_id IS
2075: SELECT userenv('sessionid')
2076: FROM dual;
2077: --
2078: begin
2079: mo_global.init('OKC');
2080: --