APPS.CSM_ACCESS_PURGE_PKG dependencies on CSL_RESOURCE_INVENTORY_ORG

Line 26: FROM CSL_RESOURCE_INVENTORY_ORG ACC

22:
23: CURSOR c_csl_inv_org
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:

Line 61: DELETE FROM CSL_RESOURCE_INVENTORY_ORG WHERE RESOURCE_ID = l_user_list(i);

57: IF l_user_list.COUNT >0 THEN
58: FOR i IN 1..l_user_list.COUNT
59: LOOP
60: BEGIN
61: DELETE FROM CSL_RESOURCE_INVENTORY_ORG WHERE RESOURCE_ID = l_user_list(i);
62: EXCEPTION
63: WHEN OTHERS THEN
64: NULL;
65: END;