Hi,
I have deleted one permission list from Main Menu > PeopleTools > Security > Delete Permission list navigation . But still while i run the below mentioned query it is showing the permission list.

SELECT B.DEPTID, A.DESCR, B.SETID, B.ROWSECCLASS,A.SETID,A.DEPTID,A.EFFDT
FROM PS_SCRTY_TBL_DEPT B, .PS_DEPT_TBL A
WHERE B.DEPTID = '0000014296'
AND A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_DEPT_TBL A_ED
WHERE A.SETID = A_ED.SETID
AND A.DEPTID = A_ED.DEPTID
AND A_ED.EFFDT <= CURRENT DATE)
AND A.SETID = B.SETID
AND B.DEPTID = A.DEPTID
AND A.SETID = 'USALL '
ORDER BY 4, 1

Please suggest me why the permission lists are showing after deletion also?