PAY List Payroll Actions and Results By Person

Description
Categories: BI Publisher
Columns: Assignment Action Id1, Element Name, Input Name, Entry Type, Status, Result Value ...
Application: Payroll
Source: List Payroll Actions and Results By Person (XML)
Short Name: PAYRPACT_XML
DB package: PAY_PAYRPACT_XMLP_PKG
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)
 
Start Date
 
Date
Business Group Id
 
Number
PER_DATES_STANDARD
 
Date