2398: IS
2399: SELECT 'X'
2400: FROM JTF_RS_DEFRESROLES_VL A,
2401: JTF_RS_ALL_RESOURCES_VL B, 2402: JTF_RS_ROLES_B D 2403: WHERE A.ROLE_RESOURCE_ID =l_resource_id
2404: AND B.RESOURCE_ID = A.ROLE_RESOURCE_ID
2405: AND B.RESOURCE_TYPE =l_resource_type_code
2406: AND D.ROLE_ID = A.ROLE_ID