PAY KR Separation Pay Liability Summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: KR Separation Pay Liability Summary Report
Application: Payroll
Source: KR Separation Pay Liability Summary Report (XML)
Short Name: PYKRSSEL_XML
DB package: PAY_PYKRSSEL_XMLP_PKG
Run PAY KR Separation Pay Liability Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select  &p_parameter_value parameter_value,
           assignment_id number_of_employees
          , sum(avg_sal)Average_Salary
          ,sum(sep_pay) Separation_pay_liability
          ,sum(sep_pay * 100 / liability_rate) Separation_pay
          ,sum(payment_days) Payment_days
          ,sum(working_period) Working_Period, 
	PAY_PYKRSSEL_XMLP_PKG.cf_average_payment_daysformula(:CS_pay_days, :CS_no_of_emp) CF_Average_Payment_Days, 
	PAY_PYKRSSEL_XMLP_PKG.cf_average_sep_payformula(:CS_sep_pay, :CS_no_of_emp) CF_Average_sep_pay, 
	PAY_PYKRSSEL_XMLP_PKG.cf_average_working_periodformu(:CS_work_period, :CS_no_of_emp) CF_Average_working_period
from pay_kr_sepl_liab_summary_v
where time_period_id = :p_selection_date
and    payroll_id = :p_payroll
and sep_pay <> 0
group by &p_parameter_value,assignment_id
Parameter Name SQL text Validation
PAYROLL 
 
 LOV Oracle
Selection Date 
 
 LOV Oracle
Selection Criteria 
 
 LOV Oracle
Download
Related Blitz Reports
PAY KR Separation Pay Liability Detail PN Generate Lease Details PAY Payslip (Korea) ECC Service Contracts, Service Contract Customer Details PO IDV Modification PO IDV Mod datatemplate for FPDS-NG PO Award Data template HXC Missing Timecard AR Reversed Receipts
Blitz Report™

Blitz Report™ provides multiple benefits: