ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4363869E053B46B63588994Y SELECT WAL.CURRENCY_CODE "Currency Code" ,POS.NAME "Position" ,DECODE(WAL.POSITION_LINE_ID, NULL, NULL, DECODE(WEL.PAY_ELEMENT_NAME, NULL, DECODE( substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1), 'AMERICAN','Follow Salary Element', NULL), WEL.PAY_ELEMENT_NAME ) ) "Element Name" ,SP.SHORT_NAME "Service Package" ,GCC.CONCATENATED_SEGMENTS "GLAccount" ,SUM(WAL.YTD_AMOUNT)"Amount" ,BYTV.SEQUENCE_NUMBER ,BP.NAME "Year" FROM PSB_WS_ACCOUNT_LINES WAL , PSB_BUDGET_PERIODS BP, PSB_SERVICE_PACKAGES SP, GL_CODE_COMBINATIONS_KFV GCC, PSB_WS_ELEMENT_LINE_NAMES_V WEL, PSB_POSITIONS POS, PSB_BUDGET_YEAR_TYPES_VL BYTV, PSB_WS_POSITION_LINES WPL, PSB_WS_LINES_POSITIONS WLP, PSB_WORKSHEETS WS WHERE BP.BUDGET_YEAR_TYPE_ID = BYTV.BUDGET_YEAR_TYPE_ID AND WAL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID AND ((:P_BUDGET_YEAR_ID IS NOT NULL AND BP.BUDGET_PERIOD_ID = :P_BUDGET_YEAR_ID) OR (:P_BUDGET_YEAR_ID IS NULL)) AND WAL.BUDGET_YEAR_ID = BP.BUDGET_PERIOD_ID AND WAL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID AND POS.HR_POSITION_ID IN (SELECT HR_POSITION_ID FROM PSB_POSITIONS WHERE DATA_EXTRACT_ID = WS.DATA_EXTRACT_ID GROUP BY HR_POSITION_ID HAVING COUNT(HR_POSITION_ID) > 1) AND WAL.POSITION_LINE_ID = WEL.POSITION_LINE_ID(+) AND WAL.ELEMENT_SET_ID = WEL.ELEMENT_SET_ID(+) AND WAL.BUDGET_YEAR_ID = WEL.BUDGET_YEAR_ID(+) AND WAL.END_STAGE_SEQ IS NULL AND WAL.TEMPLATE_ID IS NULL AND WAL.POSITION_LINE_ID = WLP.Position_Line_ID AND POS.Position_ID = WPL.Position_ID AND WPL.Position_Line_ID = WLP.Position_Line_ID AND WLP.WORKSHEET_ID = :P_WORKSHEET_ID AND WS.WORKSHEET_ID = :P_WORKSHEET_ID GROUP BY BYTV.SEQUENCE_NUMBER , BP.NAME , WAL.CURRENCY_CODE , POS.NAME , DECODE(WAL.POSITION_LINE_ID, NULL, NULL, DECODE(WEL.PAY_ELEMENT_NAME, NULL, DECODE( substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1), 'AMERICAN','Follow Salary Element', NULL), WEL.PAY_ELEMENT_NAME ) ) ,SP.SHORT_NAME ,GCC.CONCATENATED_SEGMENTS ORDER BY BYTV.SEQUENCE_NUMBER, "Position","GLAccount","Service Package","Element Name" PSB PSBRRPPS_XML US PSB Pooled Position Report for Worksheet by Responsibility Application: Public Sector Budgeting (Obsolete) Source: Pooled Position Report for Worksheet by Responsibility (XML) Short Name: PSBRRPPS_XML DB package: PSB_PSBRPPPS_XMLP_PKG BI Publisher :p_budget_year_id :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 US Budget Year