DBA Data[Home] [Help]

APPS.WF_PURGE dependencies on WF_ROLE_HIERARCHIES

Line 1481: from WF_ROLE_HIERARCHIES

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

Line 1501: from WF_ROLE_HIERARCHIES

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