PAY KR Separation Pay Liability Detail

Description
Categories: BI Publisher
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 Name SQL text Validation
Business Place Name
 
LOV Oracle
PAYROLL
 
LOV Oracle
Selection Date
 
LOV Oracle
Sort By
 
LOV Oracle
BUSINESS_GROUP_ID
 
Number