[dba-SQLServer] indexes on cursors

I built a crosstab as follows:

SELECT St as USState, [C] as 'Canoe', [D] as 'Deck', [E] as 'Cat', [H] as
'House', [I] as 'Inflate', [J] as 'JetSki', [M] as 'Muscle', [P] as
'Pontoon',[T] as 'Waterski', [W] as 'Waterski2', [X] as 'Jet'
FROM(
SELECT     dbo.vAZHSIDFamilyHash.St, dbo.vBaseBoatType.Boat_Type
FROM         dbo.vAZHSIDFamilyHash INNER JOIN dbo.vBaseBoatType 
ON dbo.vAZHSIDFamilyHash.PK = dbo.vBaseBoatType.PKID) BoatType
PIVOT 
(
COUNT(BoatType.Boat_Type)
FOR BoatType.Boat_Type IN([C],[D],[E],[H],[I],[J],[M],[P],[T],[W],[X]))
AS BT
ORDER BY USState

Notice the inner select tab is defined as a named cursor BoatType.  The
fields making up the cursor, ST and Boat_Type both have indexes on them.
Will the indexes be used for the outer select in order to perform the actual
count and orderby?

John W. Colby
Colby Consulting
www.ColbyConsulting.com