PAY KR Separation Pay Liability Summary

Description
Categories: BI Publisher
Application: Payroll
Source: KR Separation Pay Liability Summary Report (XML)
Short Name: PYKRSSEL_XML
DB package: PAY_PYKRSSEL_XMLP_PKG
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
BUSINESS_GROUP_ID
 
Number