PAY COIDA

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: COIDA Report
Short Name: PYZARPCOXML
DB package:
              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
Business Group Id
 
Number
Generate Detail Report?
 
LOV Oracle
COIDA Preprocess
 
LOV Oracle
PY_SRS_COIDA_TAX_YEAR
 
Number
Payroll Name
 
LOV Oracle