331: CURSOR c_get_permission(l_user_name VARCHAR2,l_permission VARCHAR2) IS
332: SELECT 'Y' FROM JTF_AUTH_PERMISSIONS_B A,
333: JTF_AUTH_PRINCIPAL_MAPS B,
334: JTF_AUTH_ROLE_PERMS C,
335: JTF_AUTH_PRINCIPALS_B D,
336: JTF_AUTH_PRINCIPALS_B E,
337: JTF_AUTH_DOMAINS_B F
338: WHERE D.PRINCIPAL_NAME = l_user_name AND D.IS_USER_FLAG = 1 AND
339: D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND
332: SELECT 'Y' FROM JTF_AUTH_PERMISSIONS_B A,
333: JTF_AUTH_PRINCIPAL_MAPS B,
334: JTF_AUTH_ROLE_PERMS C,
335: JTF_AUTH_PRINCIPALS_B D,
336: JTF_AUTH_PRINCIPALS_B E,
337: JTF_AUTH_DOMAINS_B F
338: WHERE D.PRINCIPAL_NAME = l_user_name AND D.IS_USER_FLAG = 1 AND
339: D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND
340: B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND