PAY KR Separation Pay Liability Summary
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
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 |