330:
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