PAY KR Simple Earnings Report Efile

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: KR Simple Earnings Report Efile
Short Name: PAYKRSER
DB package:
Run PAY KR Simple Earnings Report Efile and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ROW_NUMBER() OVER(ORDER BY action_information3) as Seq_Num
                ,REPLACE(action_information3, '-', '') as RRN
                ,RPAD(action_information4,30,' ') as Employee_name
                ,NVL(action_information5,:P_CONT_PHONE_NO) as Contact
                ,action_information6 as Korean_foreign_identifier
                ,action_information7 as Residence_identifier
                ,action_information8 as Residence_country_code
                ,action_information9 as Start_date_of_working_Period
                ,action_information10 as End_date_of_working_Period
                ,action_information11 as Taxable_earnings
                ,action_information12 as Non_taxable_earnings
            FROM pay_action_information pai
            WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
            AND PAI.ACTION_INFORMATION_CATEGORY = 'KR_SER_EMP_DETAILS'
            AND pai.ACTION_CONTEXT_ID IN
            (       SELECT MAX(ASSIGNMENT_ACTION_ID) ASSIGNMENT_ACTION_ID FROM PAY_PAYROLL_ACTIONS PPA,
                    PAY_ASSIGNMENT_ACTIONS PAA
                    WHERE PPA.action_type IN ('X')
                    AND PPA.action_status = 'C'
                    and PPA.report_type = 'SER'
                    and PPA.report_qualifier = 'KR'
                    AND PPA.REPORT_CATEGORY='ARCHIVE'
                    AND pay_core_utils.get_parameter('BP',ppa.legislative_parameters)=:P_LEGAL_EMP_ID
                    AND pay_core_utils.get_parameter('TY',ppa.legislative_parameters)=:P_TARGET_YEAR
                    AND pay_core_utils.get_parameter('REP_PERIOD',ppa.legislative_parameters) = :P_REPORTING_PERIOD
                    AND PPA.PAYROLL_ACTION_ID = NVL(:P_PAYROLL_ACTION_ID,PPA.PAYROLL_ACTION_ID)
                    AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
                    GROUP BY ASSIGNMENT_ID
            )
Parameter Name SQL text Validation
P_LEGAL_EMP_ID
 
LOV Oracle
TARGET_YEAR
 
Number
REPORTING_PERIOD
 
LOV Oracle
Payroll Action
 
LOV Oracle
Report Date
 
Date
Tax Reporting Organization
 
Char
Tax Reporter
 
Char
Contact Phone Number
 
Char
Home Tax ID
 
Char
Blitz Report™