PSB Position Adjustment

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Position Adjustment Report (XML)
Short Name: PSBRPPSA_XML
DB package: PSB_PSBRPPSA_XMLP_PKG
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
Parameter Name SQL text Validation
Global Worksheet Id
 
LOV Oracle