1477: and ORIG_SYSTEM in ('WF_LOCAL_ROLES', 'WF_LOCAL_USERS')
1478: and EXPIRATION_DATE <= end_date
1479: and not exists
1480: (select NULL
1481: from WF_ROLE_HIERARCHIES
1482: where SUPER_NAME = local.NAME
1483: or SUB_NAME = local.NAME)
1484: and not exists
1485: (select NULL
1497: and ORIG_SYSTEM = p_origSystem
1498: and (p_endDate is NULL or EXPIRATION_DATE <= p_endDate)
1499: and not exists
1500: (select NULL
1501: from WF_ROLE_HIERARCHIES
1502: where SUPER_NAME = local.NAME
1503: or SUB_NAME = local.NAME)
1504: and not exists
1505: (select NULL