PAY Payroll Actions By Person

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: List Payroll Actions and Results for a Person (UK)
Application: Payroll
Source: Payroll Actions By Person (XML)
Short Name: PAYGBACT_XML
DB package: PAY_PAYGBACT_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 assignment_action_id1,
  pettl.element_name,
  pivtl.name input_name,
  prr.ENTRY_TYPE,
  prr.status,
  prv.result_value,
	PAY_PAYGBACT_XMLP_PKG.get_ni_ptd(:ASSIGNMENT_ACTION_ID, pettl.element_name, pivtl.name) C_ptd,
	PAY_PAYGBACT_XMLP_PKG.get_ni_ytd(:ASSIGNMENT_ACTION_ID, pettl.element_name, pivtl.name) C_ytd
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
union
SELECT
  to_number(:assignment_action_id) assignment_action_id1,
  'Taxable Pay',
  null,
  null,
  null,
  null,
	PAY_PAYGBACT_XMLP_PKG.get_ni_ptd(:ASSIGNMENT_ACTION_ID, 'Taxable Pay', null) C_ptd,
	PAY_PAYGBACT_XMLP_PKG.get_ni_ytd(:ASSIGNMENT_ACTION_ID, 'Taxable Pay', null) C_ytd
FROM
  dual
 where :assignment_action_id = :assignment_action_id
order by 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 List Payroll Actions and Results 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: