PAY COIDA

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: COIDA Report
Short Name: PYZARPCOXML
DB package:
Run PAY COIDA and other Oracle EBS reports with Blitz Report™ on our demo environment
              SELECT PAI.ACTION_INFORMATION1 DD_MONTH
                    , EMP_PAI.ACTION_INFORMATION1 DD_LAST_NAME
                    , EMP_PAI.ACTION_INFORMATION2 DD_EMP_NO
                    , PAI.ACTION_INFORMATION3 DD_INCOME
                    , PAI.ACTION_INFORMATION4 DD_CASH_VAL_FOOD_QTR
                    , PAI.ACTION_INFORMATION5 DD_TOT_EARNINGS
                    , PAI.ACTION_INFORMATION6 DD_ACT_COIDA_EARNINGS1
                    , PAI.ACTION_INFORMATION7 DD_ACT_COIDA_EARNINGS2
                    , PAI.ACTION_INFORMATION8 DD_DAYS_WORKED
		    , PAI.ACTION_INFORMATION11 DD_TYPE
                    , DECODE (TO_NUMBER (TO_CHAR (TO_DATE (PAI.ACTION_INFORMATION1, 'MONTH'), 'MM')), 1
                    , PAI.ACTION_INFORMATION10, 2
                    , PAI.ACTION_INFORMATION10, TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION10),'YYYY')) D_TAX_YEAR
              FROM    PAY_ACTION_INFORMATION PAI
                    , PAY_ACTION_INFORMATION EMP_PAI
                    , PAY_PAYROLL_ACTIONS    PPA
                    , PAY_ASSIGNMENT_ACTIONS PAA
              WHERE   PPA.PAYROLL_ACTION_ID = :P_PAYROLL_ACTION_ID
              AND     PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID  
              AND     PAI.ACTION_CONTEXT_ID =  PAA.ASSIGNMENT_ACTION_ID  
              AND     PAI.ACTION_CONTEXT_TYPE = 'AAP'
              AND     PAI.ACTION_INFORMATION_CATEGORY = 'ZA_COID_EMP_INCOME_INFO'
              AND     PAI.ACTION_INFORMATION9 = 'D'
              AND     EMP_PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
              AND     EMP_PAI.ACTION_CONTEXT_TYPE = 'AAP'
              AND     EMP_PAI.ACTION_INFORMATION_CATEGORY = 'ZA_COID_EMP_INFO'
              AND     PAI.ACTION_INFORMATION9   = EMP_PAI.ACTION_INFORMATION9
              AND     NVL(PAI.ACTION_INFORMATION29,'I')  <> 'E'          
              AND     NVL(EMP_PAI.ACTION_INFORMATION29,'I') <> 'E'           
     	      AND     :P_DETAIL_REPORT = 'Y'
		      AND     PAI.ACTION_INFORMATION1 = :D_MONTH
Parameter Name SQL text Validation
Payroll Name 
 
 LOV Oracle
PY_SRS_COIDA_TAX_YEAR 
 
 Number
COIDA Preprocess 
 
 LOV Oracle
Generate Detail Report? 
 
 LOV Oracle
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY P46 EDI Process v6 Output PQP Generate MCR CSV PAY P46EXP EDI Process v6 Output PAY GB Pensions Automatic Enrollment not applied PAY Payroll Tax Report by Legal Employer PAY GB BIK Audit PAY RTI - Earlier Year Update Output 2014/15 PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™

Blitz Report™ provides multiple benefits: