APPS.CSM_ACCESS_PURGE_PKG dependencies on ASG_USER

Line 20: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.USER_ID=ACC.USER_ID

16: IS
17: SELECT DISTINCT USER_ID
18: FROM CSM_USER_INVENTORY_ORG ACC
19: WHERE USER_ID IS NOT NULL
20: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.USER_ID=ACC.USER_ID
21: AND AU.ENABLED= 'Y');
22:
23: CURSOR c_csl_inv_org
24: IS

Line 28: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.RESOURCE_ID=ACC.RESOURCE_ID

24: IS
25: SELECT DISTINCT RESOURCE_ID
26: FROM CSL_RESOURCE_INVENTORY_ORG ACC
27: WHERE RESOURCE_ID IS NOT NULL
28: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.RESOURCE_ID=ACC.RESOURCE_ID
29: AND AU.ENABLED= 'Y');
30:
31: TYPE USERID_TABLE_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
32: l_user_list USERID_TABLE_TYPE;

Line 141: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.USER_ID=ACC.USER_ID AND AU.ENABLED= ''Y'')';

137: FOR I IN 1..acc_tab_list.COUNT
138: LOOP
139: l_sql_stmt:= 'SELECT DISTINCT USER_ID FROM '||acc_tab_list(I).ACCESS_NAME ||
140: ' ACC WHERE USER_ID IS NOT NULL
141: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.USER_ID=ACC.USER_ID AND AU.ENABLED= ''Y'')';
142: BEGIN
143: EXECUTE IMMEDIATE l_sql_stmt BULK COLLECT INTO l_user_list;
144: EXCEPTION
145: WHEN OTHERS THEN

Line 175: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.RESOURCE_ID=ACC.RESOURCE_ID AND AU.ENABLED= ''Y'')';

171: FOR I IN 1..acc_tab_list.COUNT
172: LOOP
173: l_sql_stmt:= 'SELECT DISTINCT RESOURCE_ID FROM '||acc_tab_list(I).ACCESS_NAME ||
174: ' ACC WHERE RESOURCE_ID IS NOT NULL
175: AND NOT EXISTS (SELECT 1 FROM ASG_USER AU WHERE AU.RESOURCE_ID=ACC.RESOURCE_ID AND AU.ENABLED= ''Y'')';
176: BEGIN
177: EXECUTE IMMEDIATE l_sql_stmt BULK COLLECT INTO l_user_list;
178: EXCEPTION
179: WHEN OTHERS THEN