DBA Data[Home] [Help]

APPS.OKC_WF_CHK_APPROVE dependencies on WF_ROLES

Line 180: from wf_roles

176: L_INITIATOR_NAME varchar2(240);
177: L_INITIATOR_DISPLAY_NAME varchar2(240);
178: cursor C_INITIATOR_DISPLAY_NAME(P_USER_ID in number) is
179: select name,display_name
180: from wf_roles
181: where orig_system = 'FND_USR'
182: and orig_system_id=P_USER_ID
183: union all
184: select

Line 195: from wf_roles

191: and PER.EFFECTIVE_END_DATE
192: and PER.PERSON_ID = USR.EMPLOYEE_ID
193: and USR.USER_ID = P_USER_ID
194: and not exists (select '1'
195: from wf_roles
196: where orig_system = 'FND_USR'
197: and orig_system_id=P_USER_ID)
198: ;
199: