PAY Payslip (Korea)

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