APPS.WF_PURGE dependencies on WF_USER_ROLE_ASSIGNMENTS

Line 1561: from WF_USER_ROLE_ASSIGNMENTS

1557: and (p_endDate is NULL or EXPIRATION_DATE <= p_endDate)
1558: and local.USER_FLAG='Y'
1559: and not exists
1560: (select NULL
1561: from WF_USER_ROLE_ASSIGNMENTS
1562: where USER_NAME = local.NAME
1563: and RELATIONSHIP_ID <> -1)
1564: and not exists
1565: (select NULL

Line 1641: delete from WF_USER_ROLE_ASSIGNMENTS local

1637: where local.ROLE_NAME = roleTab(idx).name
1638: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1639: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1640:
1641: delete from WF_USER_ROLE_ASSIGNMENTS local
1642: where local.ROLE_NAME = roleTab(idx).name
1643: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1644: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1645: --Remove the role

Line 1666: delete from WF_USER_ROLE_ASSIGNMENTS local

1662: where local.USER_NAME = roleTab(idx).name
1663: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1664: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1665:
1666: delete from WF_USER_ROLE_ASSIGNMENTS local
1667: where local.USER_NAME = roleTab(idx).name
1668: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1669: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1670: --Remove the role

Line 1696: delete from WF_USER_ROLE_ASSIGNMENTS local

1692: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME
1693: and local.ROLE_ORIG_SYSTEM = expRoleTab(idx).ROLE_ORIG_SYSTEM
1694: and local.ROLE_ORIG_SYSTEM_ID = expRoleTab(idx).ROLE_ORIG_SYSTEM_ID;
1695:
1696: delete from WF_USER_ROLE_ASSIGNMENTS local
1697: where local.USER_NAME = expRoleTab(idx).USER_NAME
1698: and local.USER_ORIG_SYSTEM = expRoleTab(idx).USER_ORIG_SYSTEM
1699: and local.USER_ORIG_SYSTEM_ID = expRoleTab(idx).USER_ORIG_SYSTEM_ID
1700: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME

Line 1724: delete from WF_USER_ROLE_ASSIGNMENTS local

1720: where local.ROLE_NAME = roleTab(idx).name
1721: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1722: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1723:
1724: delete from WF_USER_ROLE_ASSIGNMENTS local
1725: where local.ROLE_NAME = roleTab(idx).name
1726: and local.ROLE_ORIG_SYSTEM = roleTab(idx).orig_system
1727: and local.ROLE_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1728: delete from WF_LOCAL_ROLES PARTITION(WF_LOCAL_ROLES) local

Line 1748: delete from WF_USER_ROLE_ASSIGNMENTS local

1744: where local.USER_NAME = roleTab(idx).name
1745: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1746: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1747:
1748: delete from WF_USER_ROLE_ASSIGNMENTS local
1749: where local.USER_NAME = roleTab(idx).name
1750: and local.USER_ORIG_SYSTEM = roleTab(idx).orig_system
1751: and local.USER_ORIG_SYSTEM_ID = roleTab(idx).orig_system_id;
1752:

Line 1777: delete from WF_USER_ROLE_ASSIGNMENTS local

1773: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME
1774: and local.ROLE_ORIG_SYSTEM = expRoleTab(idx).ROLE_ORIG_SYSTEM
1775: and local.ROLE_ORIG_SYSTEM_ID = expRoleTab(idx).ROLE_ORIG_SYSTEM_ID;
1776:
1777: delete from WF_USER_ROLE_ASSIGNMENTS local
1778: where local.USER_NAME = expRoleTab(idx).USER_NAME
1779: and local.USER_ORIG_SYSTEM = expRoleTab(idx).USER_ORIG_SYSTEM
1780: and local.USER_ORIG_SYSTEM_ID = expRoleTab(idx).USER_ORIG_SYSTEM_ID
1781: and local.ROLE_NAME = expRoleTab(idx).ROLE_NAME