PAY Payroll Actions By Person

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Payroll Actions By Person (XML)
Short Name: PAYGBACT_XML
DB package: PAY_PAYGBACT_XMLP_PKG
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
PER_DATES_STANDARD
 
Date
Business Group Id
 
Number
Start Date
 
Date
Element Name(with wildcard)
 
Person
 
LOV Oracle