ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717551A9E05362FB09050512 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 Y PAY PYZARPCOXML US PAY COIDA Imported from BI Publisher Application: Payroll Source: COIDA Report Short Name: PYZARPCOXML DB package: BI Publisher :d_month :p_detail_report :p_payroll_action_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id Business Group Id 2 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y US Payroll Name Payroll Id 3 20 :p_tax_year Number Y US PY_SRS_COIDA_TAX_YEAR Tax Year 4 30 :p_payroll_action_id LOV Oracle PAY_ZA_COIDA_PAYROLL_ACTION_ID Y select ppa.payroll_action_id id, to_char(ppa.effective_date,'DD-MON-YYYY') || '(' || to_char(ppa.payroll_action_id)||')' value, null description from pay_payroll_actions ppa where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type='X' and ppa.report_type='ZA_COIDA' and ppa.action_status='C' and pay_za_irp5_archive_pkg.get_parameter('PAYROLL_ID',ppa.legislative_parameters)=:$flex$.py_srs_payroll and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',ppa.legislative_parameters)=:$flex$.py_srs_coida_tax_year order by ppa.request_id desc Y US COIDA Preprocess Payroll Action Id 5 40 :p_detail_report LOV Oracle ZA_COIDA_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and enabled_flag = 'Y' and lookup_code = 'N' Y US Generate Detail Report? Print Detail :$flex$.py_srs_coida_tax_year PY_SRS_COIDA_TAX_YEAR COIDA Preprocess :$flex$.py_srs_payroll Payroll Name COIDA Preprocess