PAY List Payroll Actions and Results By Person

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: List Payroll Actions and Results for a Person
Application: Payroll
Source: List Payroll Actions and Results By Person (XML)
Short Name: PAYRPACT_XML
DB package: PAY_PAYRPACT_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT 
--  prr.assignment_action_id 
  prr.assignment_action_id assignment_action_id1,
  pettl.element_name element_name,
  pivtl.name input_name,
  prr.ENTRY_TYPE,
  prr.status,
  prv.result_value
FROM 
  pay_element_types_f_tl pettl,
  pay_element_types_f pet,
  pay_element_classifications pec,
  pay_input_values_f_tl pivtl,
  pay_input_values_f piv,
  pay_run_result_values prv,
  pay_run_results prr
WHERE 
  pet.element_type_id   = pettl.element_type_id and
  pettl.language        = userenv('LANG') and
  piv.input_value_id    = pivtl.input_value_id and
  pivtl.language        = userenv('LANG') and
  prr.element_type_id   = pet.element_type_id  and
  pet.classification_id = pec.classification_id  and
  piv.element_type_id   = pet.element_type_id  and
  prv.input_value_id    = piv.input_value_id  and
  prv.run_result_id     = prr.run_result_id  and
  :p_session_date between piv.effective_start_date and  piv.effective_end_date  and
  :p_session_date between pet.effective_start_date and  pet.effective_end_date  and
  prr.element_type_id   = pet.element_type_id  and
  pet.classification_id = pec.classification_id  and
  piv.element_type_id   = pet.element_type_id  and
  prv.input_value_id    = piv.input_value_id  and
  prv.run_result_id     = prr.run_result_id  and
  :p_session_date between piv.effective_start_date and  piv.effective_end_date  and
  :p_session_date between pet.effective_start_date and  pet.effective_end_date  and
  prv.result_value is not null  and
  pettl.element_name like  :p_element_name 
 and prr.assignment_action_id=:assignment_action_id
--order by 1,2,3
ORDER BY 2 ASC , 1 , 2 , 3
Parameter Name SQL text Validation
Person 
 
 LOV Oracle
Element Name(with wildcard) 
 
 Char
Start Date 
 
 Date
Download
 
Related Blitz Reports
PAY Employee Run Results Report (CA) PAY Gross To Net Summary Report (GB) PAY Payroll Actions By Person PAY Payroll Reconciliation Detail RKD Employee Element History PAY Employee Payroll History SSP ShPP Adoption Element Results SSP ShPP Birth Element Results PAY Employee Run Results
Blitz Report™

Blitz Report™ provides multiple benefits: