wf_user_role_assignments_v View

Hello All,

The view wf_user_role_assignments_v is defined as 

create or replace view wf_user_role_assignments_v as

select

 WURA.USER_NAME,

 WURA.ROLE_NAME,

 WURA.ASSIGNING_ROLE,

 WURA.START_DATE,

 WURA.END_DATE,

 WURA.ROLE_ORIG_SYSTEM_ID,

 decode(WURA.RELATIONSHIP_ID, -1, 'DIRECT', 'INHERITED') RELATIONSHIP_ID,

 WURA.ASSIGNMENT_REASON,

 WURA.CREATION_DATE,

 WURA.CREATED_BY,

 WURA.LAST_UPDATE_DATE,

 WURA.LAST_UPDATED_BY,

 WURA.LAST_UPDATE_LOGIN,

 WURA.PARTITION_ID,

 WURA.ROLE_ORIG_SYSTEM

 from WF_USER_ROLE_ASSIGNMENTS wura

 where wura.effective_start_date <= ( TRUNC(SYSDATE + 1) - .000011574 ) --This is a not-null column

   and (wura.effective_end_date is NULL or