PAY KR Separation Pay Liability Summary

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Payroll
Source
KR Separation Pay Liability Summary Report (XML)
Short Name
PYKRSSEL_XML
DB package
PAY_PYKRSSEL_XMLP_PKG
Imported from BI Publisher
KR Separation Pay Liability Summary Report

SQL 16 lines

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

Parameters 3

ParameterTypeList of values SQL
PAYROLLLOV Oracle
Selection DateLOV Oracle
Selection CriteriaLOV Oracle