PAY Payslip (Korea)
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- Payslip (Korea) (XML)
- Short Name
- PAYKRSOE_XML
- DB package
- PAY_PAYKRSOE_XMLP_PKG
Imported from BI Publisher
Payslip (Korea)
Payslip (Korea)
SQL 27 lines
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 |
Parameters 8
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |