PSB Position Adjustment

➜ Back to Library
Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Position Adjustment Report (XML)
Short Name: PSBRPPSA_XML
DB package: PSB_PSBRPPSA_XMLP_PKG
Run PSB Position Adjustment and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
PSB Pooled Position Report for Worksheet PSB Pooled Position Report for Worksheet by Responsibility PSB Worksheet Position Costing Report XML PSB Worksheet Position Costing Report by Responsibility PSB Worksheet Position Costing PSB Detailed FTE and Headcount by Position Report by Responsibility PSB Vacant Position PSB Detailed FTE and Headcount by Position PSB Vacant Position Report by Responsibility
Blitz Report™

Blitz Report™ provides multiple benefits: