ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717451A9E05362FB09050512Y SELECT ACTION_INFORMATION_CATEGORY ,ACTION_INFORMATION1 ,ACTION_INFORMATION2 ,ACTION_INFORMATION3 ,ACTION_INFORMATION4 ,ACTION_INFORMATION5 ,ACTION_INFORMATION6 ,ACTION_INFORMATION7 ,ACTION_INFORMATION8 ,ACTION_INFORMATION9 ,ACTION_INFORMATION10 ,ACTION_INFORMATION11 ,ACTION_INFORMATION12 ,ACTION_INFORMATION13 ,ACTION_INFORMATION14 ,ACTION_INFORMATION15 ,ACTION_INFORMATION16 ,ACTION_INFORMATION17 ,ACTION_INFORMATION18 ,ACTION_INFORMATION19 ,ACTION_INFORMATION20 ,ACTION_INFORMATION21 ,ACTION_INFORMATION22 ,ACTION_INFORMATION23 ,ACTION_INFORMATION24 ,ACTION_INFORMATION25 ,ACTION_INFORMATION26 ,ACTION_INFORMATION27 ,ACTION_INFORMATION28 ,ACTION_INFORMATION29 ,ACTION_INFORMATION30 FROM PAY_ZA_ACTION_INFORMATION pai Where action_context_id = :L_ASSIGNMENT_ACTION_ID PAY PYZAPAYEEXDT US PAY Tax Explanation Imported from BI Publisher Description: Tax Explanation Details Application: Payroll Source: Tax Explanation Report Short Name: PYZAPAYEEXDT DB package: BI Publisher :l_assignment_action_id 1 -20 :p_payroll_id_hidden Char SELECT '|PAYROLL_ID='||:$flex$.payroll_name:NULL||'|' FROM DUAL Y US Payroll ID (Hidden) Payroll ID (Hidden) 2 -10 :p_period_id_hidden Char SELECT '|PAYROLL_PERIOD_ID='||:$flex$.payroll_period||'|' FROM DUAL Y US Payroll Period (Hidden) Payroll Period (Hidden) 3 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 4 20 :p_period_id LOV Oracle PY_SRS_PAY_PERIOD_ID Y select time_period_id id, period_name value, null description from per_time_periods p,fnd_sessions f where p.payroll_id=:$flex$.py_srs_payroll and p.start_date<=f.effective_date and f.session_id= userenv('sessionid') order by p.start_date desc Select p.period_name from per_time_periods p, fnd_sessions f Where p.payroll_id = :$flex$.payroll_name and f.session_id = userenv('sessionid') and f.effective_date between p.start_date and p.end_date Y US Payroll Period Payroll Period 5 30 :p_payroll_action_id LOV Oracle PY_ZA_PYRL_QPY_RQST_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,pay_payrolls_f ppf where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type in ('Q','R') and ppa.action_status='C' and ppa.payroll_id=:$flex$.py_srs_payroll and ppa.time_period_id=:$flex$.py_srs_pay_period_id and ppf.payroll_id=ppa.payroll_id and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date and exists ( select 1 from pay_assignment_actions paa, pay_za_action_information pai where paa.payroll_action_id=ppa.payroll_action_id and paa.assignment_action_id=pai.action_context_id and paa.source_action_id is not null and paa.action_status='C') order by value,description Y US Request Id Request Id 6 40 :p_assignment_id LOV Oracle PY_ZA_PAYE_EXPLNTN_ASG_ID Y select asg.assignment_id id, asg.assignment_number value, null description from pay_assignment_actions paa,pay_payroll_actions ppa,per_all_assignments_f asg,per_all_people_f pap where pap.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type in ('Q','R') and ppa.action_status='C' and ppa.payroll_id=:$flex$.py_srs_payroll and ppa.time_period_id=:$flex$.py_srs_pay_period_id and ppa.payroll_action_id=:$flex$.py_za_pyrl_qpy_rqst_id and paa.payroll_action_id=paa.payroll_action_id and paa.action_status='C' and paa.assignment_action_type in ('Q','R') and paa.source_action_id is not null and asg.assignment_id=paa.assignment_id and ppa.effective_date between asg.effective_start_date and asg.effective_end_date and asg.person_id=pap.person_id and ppa.effective_date between pap.effective_start_date and pap.effective_end_date and exists ( select 1 from pay_za_action_information pai where paa.payroll_action_id=ppa.payroll_action_id and paa.assignment_action_id=pai.action_context_id and pai.assignment_id=paa.assignment_id and pai.action_information_category in ('ZA_TAX_CALC_EE_SPCFC_INFO','ZA_EE_NE_BP_AE') ) order by value,description US Specific Assignment Assignment