ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F35C3869E053B46B63588994 SELECT :P_LE_NAME legal_entity , pai.action_information2 payroll_name , pai.action_information3 bal_cat , decode (pai.action_information3, 'Income' , 1, 'Allowances' , 2, 'Fringe Benefit' , 3, 'Lump Sum' , 4, 'Deductions' , 5, 'Employer Contributions' , 6, 'Gross Amounts' , 7) bal_cat_no , pai.action_information4 rep_name , pai.action_information5 code , sum(nvl(pai.action_information6,0)) le_payroll_ytd_val , sum(nvl(pai.action_information7,0)) le_payroll_rollup_val FROM pay_assignment_actions paa , pay_action_information pai WHERE paa.payroll_action_id = :p_payroll_action_id AND paa.assignment_action_id = pai.action_context_id AND pai.action_context_type = 'AAP' AND pai.action_information_category = 'ZA_PAYROLL_VAL' group by pai.action_information2,pai.action_information3,pai.action_information4,pai.action_information5 ORDER BY payroll_name , to_number(bal_cat_no) , code Y PAY PYZATXAUR US PAY Tax Audit Report Template Application: Payroll Source: Tax Audit Report Template Short Name: PYZATXAUR DB package: PAY_ZA_TX_AUDIT_ARCHIVE BI Publisher :g_asg_set_id :g_end_date :g_legal_entity_id :g_payroll_id :g_start_date :p_asg_set_name :p_det_rep :p_end_date :p_le_name :p_payroll_action_id :p_payroll_name :p_start_date 1 10 :p_payroll_action_id Char Y US Payroll Action ID 2 20 :p_le_name Char Y US Legal Entity Name 3 30 :p_start_date Date Y US Start Date 4 40 :p_end_date Date Y US End Date 5 50 :p_payroll_name LOV Oracle PY_ZA_AU_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 US Payroll Name 6 60 :p_asg_set_name LOV Oracle PY_ZA_AU_ASG_SET Y select has.assignment_set_id id, has.assignment_set_name value, null description from hr_assignment_sets has where business_group_id=fnd_global.per_business_group_id order by value,description US Assignment Set 7 70 :p_det_rep LOV Oracle 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 Y US Detail Report