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 PAY KR Simple Earnings Report Efile PAY KR Health Insurance Premium Adjustment Annual Earnings AP Invoice on Hold AP Supplier Upload PO Award Data template
Blitz Report™

Blitz Report™ provides multiple benefits: