PAY Payslip (Korea)

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Payslip (Korea)
Application: Payroll
Source: Payslip (Korea) (XML)
Short Name: PAYKRSOE_XML
DB package: PAY_PAYKRSOE_XMLP_PKG
Run PAY Payslip (Korea) and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Payroll
 
LOV Oracle
Run Type/Period
 
LOV Oracle
Business Place
 
LOV Oracle
Assignment Number
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 4
 
LOV Oracle
Blitz Report™