ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4283869E053B46B63588994Y select pe.name pe, peo.name peo, peo.grade_step grd_stp, p.position_id POSITION_ID3, pa.element_value ws_val2, pa.effective_start_date pa_sdate2, pa.effective_end_date pa_edate2 from psb_position_assignments pa, psb_positions p, psb_pay_elements pe, psb_pay_element_options peo, psb_pay_element_rates per where ((pa.worksheet_id = :P_WORKSHEET_ID and nvl(p.new_position_flag,'N') = 'N' ) or (pa.worksheet_id is null and nvl(p.new_position_flag,'N') = 'Y' )) and pa.position_id = p.position_id and pa.assignment_type = 'ELEMENT' and pa.pay_element_id = pe.pay_element_id and pa.data_extract_id = pe.data_extract_id and pe.salary_flag = 'Y' and pa.pay_element_option_id = peo.pay_element_option_id(+) and peo.pay_element_option_id = per.pay_element_option_id(+) and p.position_id=:position_id PSB PSBRPPSA_XML US PSB Position Adjustment Application: Public Sector Budgeting (Obsolete) Source: Position Adjustment Report (XML) Short Name: PSBRPPSA_XML DB package: PSB_PSBRPPSA_XMLP_PKG BI Publisher :p_worksheet_id :position_id 1 10 :p_worksheet_id LOV Oracle PSB_SRS_GLOBAL_WS Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where global_worksheet_flag='Y' and nvl(federal_ws_flag,'N')='N' order by worksheet_id desc,name Y US Global Worksheet Id