ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4383869E053B46B63588994Y select pos.position_id, pavb.employee_id, pos.name pos_name, emp.full_name, bg.budget_group_id, bg.short_name bg_name, pkfv.CONCATENATED_SEGMENTS, wlp.position_line_id pos_line_id, PSB_PSBRPVPR_XMLP_PKG.CF_1FORMULA0090(bg.budget_group_id) CF_CURRENCY_CODE, PSB_PSBRPVPR_XMLP_PKG.CP_CURRENCY_CODE_p CP_CURRENCY_CODE, PSB_PSBRPVPR_XMLP_PKG.CP_ELEM_TOTAL_p CP_ELEM_TOTAL from PSB_WORKSHEETS WS, PSB_WS_LINES_POSITIONS WLP, PSB_WS_POSITION_LINES WPL, PSB_POSITIONS POS, PSB_POSITION_DEFINITIONS_KFV PKFV, PSB_POSITION_ASSIGNMENTS_V PAVB, psb_employees emp , psb_budget_groups bg where ws.worksheet_id = :p_worksheet_id and nvl(pos.vacant_position_flag,'Y') = 'Y' and WLP.Worksheet_ID = WS.Worksheet_ID and WLP.Position_Line_ID = WPL.Position_Line_ID and POS.Position_ID = WPL.Position_ID and POS.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID and pavb.position_id(+) = wpl.position_id and PAVB.Assignment_Type(+) = 'EMPLOYEE' and PAVB.Primary_Employee_Flag(+) = 'Y' and emp.employee_id(+) = pavb.employee_id and bg.budget_group_id = wpl.budget_group_id ORDER BY 5 ASC,6 ASC ,7 asc,4 asc, 1 asc,2 asc, 3 asc,8 asc,bg.name , pkfv.concatenated_segments PSB PSBRRVPR_XML US PSB Vacant Position Report by Responsibility Application: Public Sector Budgeting (Obsolete) Source: Vacant Position Report by Responsibility (XML) Short Name: PSBRRVPR_XML DB package: PSB_PSBRPVPR_XMLP_PKG BI Publisher :p_worksheet_id 1 10 :p_worksheet_id LOV Oracle PSB_SRS_WS_BY_RESP Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where ws_creation_complete='Y' and worksheet_id in (select a.worksheet_id from psb_worksheets a where a.budget_group_id in (select b.budget_group_id from psb_budget_groups b where b.budget_group_type='R' and sysdate between effective_start_date and nvl(effective_end_date,sysdate) start with budget_group_id in (select c.budget_group_id from psb_budget_group_resp c where c.responsibility_id=fnd_global.resp_id) connect by prior b.budget_group_id= b.parent_budget_group_id)) order by worksheet_id Y US Worksheet 2 20 :p_budget_year_id LOV Oracle PSB_SRS_BJE_YEAR_BY_RESP Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_type='Y' and budget_calendar_id in (select budget_calendar_id from psb_worksheets where worksheet_id=:$flex$.psb_srs_ws_by_resp) and budget_year_type_id in (select budget_year_type_id from psb_budget_year_types where year_category_type='PP') order by value,description Y US Budget Year