ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717751A9E05362FB09050512Y SELECT decode (rf_bal_name4, 'Gross Retirement Funding Income', 'Gross Employment Income (Taxable)', 'Gross Non Retirement Funding Income', 'Gross Employment Income (Taxable)', 'Directors Fees Resident NED', 'Gross Employment Income (Taxable)', rf_bal_name4) rf_bal_name4, decode (rf_bal_code4, '3620', '3699', '3670', '3699', '3697', '3699', '3698', '3699', rf_bal_code4) rf_bal_code4, assignment_action_id1, sum (rf_tot_ptd6) rf_tot_ptd6, sum (rf_tot_mtd6) rf_tot_mtd6, sum (rf_tot_ytd6) rf_tot_ytd6 FROM ( SELECT decode (pai.action_information16, 'RFIable Ann Pymt of EE Debt NTG', 'Total RFIable Annual Income', 'NRFIable Ann Pymt of EE Debt NTG', 'Total NRFIable Annual Income', pai.action_information16) rf_bal_name4, pai.action_information12 assignment_action_id1, pai.action_information17 rf_bal_code4, sum (fnd_number.canonical_to_number (pai.action_information18)) rf_tot_ptd6, sum (fnd_number.canonical_to_number (pai.action_information19)) rf_tot_mtd6, sum (fnd_number.canonical_to_number (pai.action_information20)) rf_tot_ytd6 FROM pay_action_information pai, pay_assignment_actions paa WHERE pai.action_context_id = paa.assignment_action_id AND paa.payroll_action_id = :P_PAYROLL_ACTION_ID AND paa.assignment_action_id = :assignment_action_id AND pai.action_context_type = 'AAP' AND pai.action_information_category = 'ZA_TAX_REG_REP' AND pai.action_information21 = :payroll_id AND pai.action_information17 IN (3620,3670,3696,3697,3698) GROUP BY decode (pai.action_information16, 'RFIable Ann Pymt of EE Debt NTG', 'Total RFIable Annual Income', 'NRFIable Ann Pymt of EE Debt NTG', 'Total NRFIable Annual Income', pai.action_information16), pai.action_information12, pai.action_information17 ORDER BY pai.action_information17 ) GROUP BY decode (rf_bal_name4, 'Gross Retirement Funding Income', 'Gross Employment Income (Taxable)', 'Gross Non Retirement Funding Income', 'Gross Employment Income (Taxable)', 'Directors Fees Resident NED', 'Gross Employment Income (Taxable)', rf_bal_name4), decode (rf_bal_code4, '3620', '3699', '3670', '3699', '3697', '3699', '3698', '3699', rf_bal_code4), assignment_action_id1 PAY PYZATXREGREP US PAY Tax Register Imported from BI Publisher Application: Payroll Source: Tax Register Report (XML) Short Name: PYZATXREGREP DB package: PAY_ZA_TAX_REG_AR BI Publisher :assignment_action_id :c_period_end :c_period_num :c_period_start :cp_total_assignments :cp_total_employees :p_assignment_id :p_detail :p_end_period_id :p_include :p_legal_entity_id :p_legal_entity_name :p_payroll_action_id :p_payroll_id :p_payroll_name :p_period_end_date :p_retrieve_mtd :p_retrieve_ptd :p_retrieve_ytd :p_sort_1 :p_sort_2 :p_sort_3 :p_start_period_id :payroll_id :sort_order 1 -30 :p_start_period_id Number SELECT MIN(ptp.time_period_id) min_time_period FROM per_time_periods ptp WHERE ptp.payroll_id = :$flex$.payroll_name AND ptp.prd_information1 = (SELECT ptp2.prd_information1 FROM per_time_periods ptp2 WHERE ptp2.payroll_id = :$flex$.payroll_name AND ptp2.time_period_id = :$flex$.payroll_period) US Start Period ID Start Period ID 2 -20 :p_payroll_name Char SELECT fnd_date.date_to_displaydate(fnd.effective_date) from fnd_sessions fnd where fnd.session_id = USERENV('SESSIONID') US Payroll Name 2 Payroll Name 3 -10 :p_period_end_date Date SELECT fnd_date.date_to_displaydate(fnd.effective_date) from fnd_sessions fnd where fnd.session_id = USERENV('SESSIONID') US End Period Date End Period Date 4 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 5 20 :p_end_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 End Period ID 6 30 :p_include LOV Oracle PY_SRS_ZA_TX_RGSTR_INCL_ASG Y select hl.lookup_code id, hl.meaning value, hl.description description from hr_lookups hl where lookup_type='ZA_TX_RGSTR_ASG_TYPE' and enabled_flag='Y' order by value,description SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'ZA_TX_RGSTR_ASG_TYPE' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'A' Y US Include Assignments Include Assignments Types 7 40 :p_assignment_id Number US Specific Assignment? Assignment 8 50 :p_retrieve_ptd 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 SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'YES_NO' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'N' Y US Print PTD Retrieve PTD 9 60 :p_retrieve_mtd 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 SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'YES_NO' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'N' Y US Print MTD Retrieve MTD 10 70 :p_retrieve_ytd 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 SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'YES_NO' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'Y' Y US Print YTD Retrieve YTD 11 80 :p_sort_1 LOV Oracle PY_SRS_ZA_TX_RGSTR_SORT Y select hl.lookup_code id, hl.meaning value, hl.description description from hr_lookups hl where lookup_type='ZA_TX_RGSTR_SORT' and enabled_flag='Y' order by value,description SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'ZA_TX_RGSTR_SORT' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'FULL_NAME' Y US Sort Order 1 Sort Order 1 12 90 :p_sort_2 LOV Oracle PY_SRS_ZA_TX_RGSTR_SORT Y select hl.lookup_code id, hl.meaning value, hl.description description from hr_lookups hl where lookup_type='ZA_TX_RGSTR_SORT' and enabled_flag='Y' order by value,description SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'ZA_TX_RGSTR_SORT' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'EMPLOYEE_NUMBER' Y US Sort Order 2 Sort Order 2 13 100 :p_sort_3 LOV Oracle PY_SRS_ZA_TX_RGSTR_SORT Y select hl.lookup_code id, hl.meaning value, hl.description description from hr_lookups hl where lookup_type='ZA_TX_RGSTR_SORT' and enabled_flag='Y' order by value,description SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'ZA_TX_RGSTR_SORT' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'ASSIGNMENT_NUMBER' Y US Sort Order 3 Sort Order 3 14 110 :p_detail 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 SELECT hl.meaning FROM hr_lookups hl WHERE hl.lookup_type = 'YES_NO' AND hl.enabled_flag = 'Y' AND hl.lookup_code = 'Y' Y US Generate Detail Report? Print Detail 15 120 :p_payroll_action_id Char US Payroll Action ID Payroll Action ID 16 130 :p_legal_entity_name Char Y US Legal Entity Name Legal Entity Name 17 140 :debugflag 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 N US DebugFlag DebugFlag