ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4273869E053B46B63588994 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 Y PSB PSBRPPRM_XML US PSB Parameter Listing Application: Public Sector Budgeting (Obsolete) Source: Parameter Listing (XML) Short Name: PSBRPPRM_XML DB package: PSB_PSBRPPRM_XMLP_PKG BI Publisher :p_bgp_id :p_set_id :p_sob_id 1 10 :p_sob_id LOV Oracle PSB_SET_OF_BOOKS Y select set_of_books_id id, name value, null description from gl_sets_of_books order by name US Ledger 2 20 :p_bgp_id LOV Oracle PSB_SRS_BUDGET_GROUP_NAME Y select budget_group_id id, name value, null description from psb_budget_groups where budget_group_type='R' order by name US Budget Groups 3 30 :p_set_id LOV Oracle PSB_SRS_PARAMETER_SETS Y select entity_set_id id, name value, null description from psb_entity_set where entity_type='PARAMETER' order by name US Parameter Sets