APPS.WF_PURGE dependencies on WF_ROLE_HIERARCHIES

Line 1523: from WF_ROLE_HIERARCHIES

1519: and EXPIRATION_DATE <= end_date
1520: and local.USER_FLAG='N'
1521: and not exists
1522: (select NULL
1523: from WF_ROLE_HIERARCHIES
1524: where SUPER_NAME = local.NAME
1525: or SUB_NAME = local.NAME)
1526: and not exists
1527: (select NULL

Line 1542: from WF_ROLE_HIERARCHIES

1538: and (p_endDate is NULL or EXPIRATION_DATE <= p_endDate)
1539: and local.USER_FLAG='N'
1540: and not exists
1541: (select NULL
1542: from WF_ROLE_HIERARCHIES
1543: where SUPER_NAME = local.NAME
1544: or SUB_NAME = local.NAME)
1545: and not exists
1546: (select NULL