PAY KR Separation Pay Liability Detail

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: KR Separation Pay Liability Detail Report
Application: Payroll
Source: KR Separation Pay Liability Detail Report (XML)
Short Name: PAYKRSPL_XML
DB package: PAY_PAYKRSPL_XMLP_PKG
select  element_name
       ,employee_name
       ,element_type_id
       ,employee_number
       ,date_start
       ,working_period
       ,yearly_bonus
       ,alr
       ,average_salary_me
       ,average_salary_ybon
       ,average_salary_alr
       ,separation_pay
       ,business_group_id
       ,time_period_id
       ,result_value
       ,assignment_id
       ,assignment_action_id
       ,separation_date
       ,payment_days
       ,cost_center
       ,grade_name
       ,establishment_name
       ,establishment_id
       ,liability_rate
      ,proportion, 
	PAY_PAYKRSPL_XMLP_PKG.cf_page_totalformula(:CS_TOTAL) CF_PAGE_TOTAL, 
	PAY_PAYKRSPL_XMLP_PKG.cf_separation_payformula(separation_pay, liability_rate) CF_SEPARATION_PAY, 
	PAY_PAYKRSPL_XMLP_PKG.cf_average_salaryformula(average_salary_me, average_salary_ybon, average_salary_alr) CF_AVERAGE_SALARY, 
	PAY_PAYKRSPL_XMLP_PKG.cf_format_working_periodformul(working_period, proportion, assignment_id) CF_FORMAT_WORKING_PERIOD
from pay_kr_sep_liab_detail_v
 where business_group_id   = :p_business_group_id  
   and time_period_id      = :p_selection_date
   and payroll_id          = :p_payroll_id
   and establishment_id    = :p_establishment_id
   order by employee_number,&p_selection_value,element_type_id
Parameter NameSQL textValidation
Business Place Name
 
LOV Oracle
PAYROLL
 
LOV Oracle
Selection Date
 
LOV Oracle
Sort By
 
LOV Oracle
Download
Related Blitz Reports
PAY KR Separation Pay Liability Summary PN Generate Lease Details AP Turnover (1) AP Turnover PAY Payslip (Korea) ECC Service Contracts, Service Contract Customer Details PAY IR8A Summary JA Cash Flow Statement Program - Cash Flow Detail PAY KR Simple Earnings Report Efile
Blitz Report™