APPS.CSM_ACCESS_PURGE_PKG dependencies on CSM_USER_INVENTORY_ORG

Line 18: FROM CSM_USER_INVENTORY_ORG ACC

14: IS
15: CURSOR c_csm_inv_org
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:

Line 43: DELETE FROM CSM_USER_INVENTORY_ORG WHERE USER_ID = l_user_list(i);

39: IF l_user_list.COUNT >0 THEN
40: FOR i IN 1..l_user_list.COUNT
41: LOOP
42: BEGIN
43: DELETE FROM CSM_USER_INVENTORY_ORG WHERE USER_ID = l_user_list(i);
44: EXCEPTION
45: WHEN OTHERS THEN
46: NULL;
47: END;