PER Pay Element Details

➜ Back to Library
Description
Categories: Draft
Master data report showing HR payroll element details.
Elements are the units used to build all the earnings, deductions and benefits that companies can give to employees.
Run PER Pay Element Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select
petf.element_name,
petf.reporting_name,
petf.description,
pec.classification_name,
pec.legislation_code,
petf.input_currency_code,
petf.output_currency_code,
xxen_util.meaning(petf.additional_entry_allowed_flag,'YES_NO',0) additional_entry_allowed,
xxen_util.meaning(petf.adjustment_only_flag,'YES_NO',0) adjustment_only,
xxen_util.meaning(petf.closed_for_entry_flag,'YES_NO',0) closed_for_entry,
xxen_util.meaning(petf.multiple_entries_allowed_flag,'YES_NO',0) multiple_entries_allowed,
xxen_util.meaning(petf.process_in_run_flag,'YES_NO',0) process_in_run,
xxen_util.meaning(petf.standard_link_flag,'YES_NO',0) standard_link,
xxen_util.meaning(petf.processing_type,'PROCESSING_TYPE',3) processing_type,
xxen_util.meaning(petf.post_termination_rule,'TERMINATION_RULE',3) post_termination_rule,
petf.effective_start_date,
petf.effective_end_date,
petf.processing_priority,
xxen_util.user_name(petf.created_by) created_by,
xxen_util.client_time(petf.creation_date) creation_date,
xxen_util.user_name(petf.last_updated_by) last_updated_by,
xxen_util.client_time(petf.last_update_date) last_update_date,
petf.element_type_id
from
pay_element_types_f petf, 
pay_element_classifications pec
where
1=1 and
petf.classification_id=pec.classification_id
Parameter Name SQL text Validation
Effective Date 
:effective_date between petf.effective_start_date and petf.effective_end_date
 Date
Download
Related Blitz Reports
PAY Employee Run Results PAY Payroll Reconciliation Detail PAY Earnings Audit PAY List Payroll Actions and Results By Person PAY Gross To Net Summary Report (GB) PAY Payroll Actions By Person PAY Employee Run Results Report (CA) PAY Payroll Reconciliation (New Zealand) PAY NI Class Validation PAY Fringe Benefits
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™