List tiers for an application

Returns all tiers associated with the specified application including tier names, IDs, and related metadata.