PSB Parameter Listing

SELECT sob.name sob_name, bgp.short_name bgp_name, ps.name  ps_name, ps.description set_desc, ps.parameter_set_id
FROM gl_sets_of_books sob, psb_budget_groups bgp, psb_parameter_sets_v ps 
WHERE sob.set_of_books_id = ps.set_of_books_id 
AND  bgp.budget_group_id = ps.budget_group_id 
AND  sob.set_of_books_id = NVL( :P_SOB_ID, sob.set_of_books_id)
AND  bgp.budget_group_id = NVL( :P_BGP_ID, bgp.budget_group_id)
AND  ps.parameter_set_id = NVL(:P_SET_ID, ps.parameter_set_id)
ORDER BY sob_name, bgp_name, ps_name