PAY Payslip (Korea)

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Payslip (Korea) (XML)
Short Name: PAYKRSOE_XML
DB package: PAY_PAYKRSOE_XMLP_PKG
Select
            Assignment_Action_Id       Assignment_Action_Id
           , Assignment_Action_Id_Payroll Assignment_Action_Id_Payroll
           , Payroll_Action_Id_Payroll Payroll_Action_Id_Payroll
           , First_Name||' '||Last_Name Name
           , Employee_Number            Employee_Number
           , Assignment_Number          Assignment_Number
           , Establishment_Name         Establishment_Name
           , Run_Type_Name              Run_Type_Name
           , Grade                                Grade
           , Kr_Grade                           Kr_Grade
           , Payroll_Name                    Payroll_Name
           , Start_Date||' - '||End_Date  Period_Dates
           , Hire_Date                          Hire_Date
           , Paid_Date                         Paid_Date, 
	PAY_PAYKRSOE_XMLP_PKG.cf_miscearningsformula(Assignment_Action_Id) CF_MiscEarnings, 
	PAY_PAYKRSOE_XMLP_PKG.cf_mischoursformula(Assignment_Action_Id) CF_MiscHours, 
	PAY_PAYKRSOE_XMLP_PKG.cf_miscdeductionsformula(Assignment_Action_Id) CF_MiscDeductions
From     Pay_Kr_Asg_Actions_v
Where  Payroll_Id = :P_PAYROLL_ID
And       Payroll_Action_Id = :P_TIME_PERIOD_ID
And       to_char(Organization_Id) like nvl(:P_ESTABLISHMENT_ID,'%')
And       to_char(Assignment_Id) like nvl(:P_ASSIGNMENT_ID,'%')
Order By decode(:P_SORT_ORDER_1,'FULL_NAME',ORDER_NAME||LAST_NAME||FIRST_NAME,'ESTABLISHMENT_ID',ORGANIZATION_ID)
              ,decode(:P_SORT_ORDER_2,'FULL_NAME',ORDER_NAME||LAST_NAME||FIRST_NAME,'ESTABLISHMENT_ID',ORGANIZATION_ID)
              ,ORDER_NAME||LAST_NAME||FIRST_NAME
Parameter Name SQL text Validation
Business Group Id
 
Number
Sort Order 4
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Assignment Number
 
LOV Oracle
Business Place
 
LOV Oracle
Run Type/Period
 
LOV Oracle
Payroll
 
LOV Oracle