How To Check Application wise Responsiblity

SELECT
(
SELECT application_short_name

FROM fnd_application fa

WHERE fa.application_id = frv.application_id
) application,

frv.responsibility_name,
frv.description

FROM fnd_responsibility_vl frv

WHERE
(
SELECT application_short_name

FROM fnd_application fa

WHERE fa.application_id = frv.application_id
) = 'SQLAP'

--> Used For Specific Module