GL Other - Data Access Set Listing

select  an.ledger_id LEDGER_ID, l.name LEDGER_NAME, lp.meaning LEDGER_TYPE , 
        an.all_segment_value_flag ALL_SEGMENT_VALUE_FLAG,
        an.access_privilege_code ACCESS_PRIVILEGE_CODE, an.segment_value SESGMENT_VALUE
from gl_access_set_norm_assign an, gl_ledgers l, gl_lookups lp
where an.access_set_id = :P_ACCESS_SET_ID
and l.ledger_id = an.ledger_id
and lp.lookup_type = 'LEDGERS'
and lp.lookup_code = l.object_type_code
order by l.name, an.segment_value