PAY COIDA
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Payroll
Source: COIDA Report
Short Name: PYZARPCOXML
DB package:
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 | |
---|---|---|---|
Payroll Name |
|
LOV Oracle | |
PY_SRS_COIDA_TAX_YEAR |
|
Number | |
COIDA Preprocess |
|
LOV Oracle | |
Generate Detail Report? |
|
LOV Oracle |