ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716E51A9E05362FB09050512Y select distinct registered_employer reg_employer_name, full_name emp_full_name, nvl(order_name, full_name) emp_order_name, assignment_number ass_number, nvl(expense_check_send_to_address,'O') home_office_ind, location_id location_id, location_code location_name, /* Removed for Bug #17207736 cost_centre ass_cost_centre, cost_centre_proportion, */ person_id person_id, time_period_id time_period_id, assignment_id assignment_id, assignment_action_id assignment_action_id, run_assignment_action_id run_ass_action_id_link_from_q1, payroll_id payroll_id, salary, ird_number, to_char(date_earned,'dd-Mon-yyyy') date_earned, tax_code, to_char(pay_advice_date,'dd-Mon-yyyy') pay_date, period_number period_num, to_char(period_start_date,'dd-Mon-yyyy') period_start_date, to_char(period_end_date,'dd-Mon-yyyy') period_end_date, PAY_PYNZSOE_XMLP_PKG.cf_get_miscellaneous_valuesfor(assignment_id, assignment_action_id, date_earned) CF_get_miscellaneous_values, PAY_PYNZSOE_XMLP_PKG.cf_net_this_payformula() CF_net_this_pay, PAY_PYNZSOE_XMLP_PKG.cf_net_ytdformula() CF_net_ytd, PAY_PYNZSOE_XMLP_PKG.f_get_detailsformula(assignment_number, assignment_id, date_earned, nvl ( expense_check_send_to_address , 'O' ), person_id, location_id) F_Get_Details ,PAY_PYNZSOE_XMLP_PKG.P_Address_Line_1_p P_Address_Line_1, PAY_PYNZSOE_XMLP_PKG.P_Address_Line_2_p P_Address_Line_2, PAY_PYNZSOE_XMLP_PKG.P_Address_Line_3_p P_Address_Line_3, PAY_PYNZSOE_XMLP_PKG.P_Town_City_p P_Town_City, PAY_PYNZSOE_XMLP_PKG.P_PostCode_p P_PostCode, PAY_PYNZSOE_XMLP_PKG.P_Country_p P_Country, PAY_PYNZSOE_XMLP_PKG.P_Position_Name_p P_Position_Name, /* bug 18172201 begin */ PAY_PYNZSOE_XMLP_PKG.P_Grade_Name_p P_Grade_Name, PAY_PYNZSOE_XMLP_PKG.P_Job_Name_p P_Job_Name, /* bug 18172201 end */ PAY_PYNZSOE_XMLP_PKG.CP_non_tax_allow_this_pay_p CP_non_tax_allow_this_pay, PAY_PYNZSOE_XMLP_PKG.CP_non_tax_allow_ytd_p CP_non_tax_allow_ytd, PAY_PYNZSOE_XMLP_PKG.CP_gross_ytd_p CP_gross_ytd, PAY_PYNZSOE_XMLP_PKG.CP_gross_this_pay_p CP_gross_this_pay, PAY_PYNZSOE_XMLP_PKG.CP_other_deductions_ytd_p CP_other_deductions_ytd, PAY_PYNZSOE_XMLP_PKG.CP_other_deductions_this_pay_p CP_other_deductions_this_pay, PAY_PYNZSOE_XMLP_PKG.CP_tax_deductions_ytd_p CP_tax_deductions_ytd, PAY_PYNZSOE_XMLP_PKG.CP_pre_tax_deductions_this_pa CP_pre_tax_deductions_this_pay, PAY_PYNZSOE_XMLP_PKG.CP_pre_tax_deductions_ytd_p CP_pre_tax_deductions_ytd, PAY_PYNZSOE_XMLP_PKG.CP_tax_deductions_this_pay_p CP_tax_deductions_this_pay, 'A' dummy /*This is added because last function call was not executed*/ /*from_q1, payroll_id payroll_id, salary, ird_number, date_earned, tax_code, pay_advice_date pay_date, period_number period_num, period_start_date period_start_date, period_end_date*/ from pay_nz_asg_payment_runs_v where business_group_id =:p_business_group_id and payroll_id = :p_payroll_id and payroll_action_id = :p_payroll_action_id &CP_WHERE_CLAUSE &CP_ORDER_BY PAY PYNZSOE_XML US PAY Statement Of Earnings (New Zealand) Imported from BI Publisher Description: Statement Of Earnings (New Zealand) Application: Payroll Source: Statement Of Earnings (New Zealand) (XML) Short Name: PYNZSOE_XML DB package: PAY_PYNZSOE_XMLP_PKG BI Publisher &cp_order_by &cp_where_clause :cp_gross_this_pay :cp_gross_ytd :cp_non_tax_allow_this_pay :cp_non_tax_allow_ytd :cp_order_by :cp_other_deductions_this_pay :cp_other_deductions_ytd :cp_payment_run :cp_payroll_name :cp_pre_tax_deductions_this_pay :cp_pre_tax_deductions_ytd :cp_tax_deductions_this_pay :cp_tax_deductions_ytd :cp_where_clause :p_address_line_1 :p_address_line_2 :p_address_line_3 :p_assignment_id :p_business_group_id :p_conc_request_id :p_country :p_cumulative_leave_bal :p_grade_name :p_job_name :p_location_id :p_organisation_name :p_payroll_action_id :p_payroll_id :p_position_name :p_postcode :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 :p_town_city 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US 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 3 20 :p_payroll_action_id LOV Oracle PY_NZ_SOE_PAYMENT_RUN Y select payroll_action_id id, fnd_date.date_to_chardate(nvl(pa.pay_advice_date,pa.effective_date))||'('||to_char(pa.payroll_action_id)||decode(pa.action_type,'U','(Quickpay)',null)||')' value, null description from pay_payroll_actions pa where action_type in('P','U') and action_status='C' and payroll_id=:$flex$.py_srs_payroll order by payroll_action_id Y US Payment Run 4 30 :p_assignment_id LOV Oracle PY_NZ_SOE_ASG_NUMBER Y select paf.assignment_id id, paf.assignment_number value, null description from per_assignments_f paf,pay_payroll_actions ppa,pay_assignment_actions paa where ppa.payroll_action_id=:$flex$.py_nz_soe_payment_run and ppa.payroll_action_id=paa.payroll_action_id and paa.action_status='C' and paa.assignment_id=paf.assignment_id and ppa.effective_date between paf.effective_start_date and paf.effective_end_date order by paf.assignment_number US Assignment Number 5 40 :p_location_id LOV Oracle PY_NZ_SOE_LOCATION_CODES Y select location_id id, hrl.location_code value, null description from hr_locations hrl where hrl.location_id in (select paf.location_id from per_assignments_f paf,pay_assignment_actions paa,pay_payroll_actions ppa where ppa.payroll_action_id=:$flex$.py_nz_soe_payment_run and ppa.payroll_action_id=paa.payroll_action_id and paa.action_status='C' and paa.assignment_id=paf.assignment_id and ppa.effective_date between paf.effective_start_date and paf.effective_end_date) order by hrl.location_code US Location 6 50 :p_organisation_name LOV Oracle PY_NZ_SOE_ORG_UNITS Y select substr(hro.name,1,150) id, substr(hro.name,1,150) value, null description from hr_organization_units hro where hro.organization_id in (select to_number(scl.segment1) from per_assignments_f paf,pay_assignment_actions paa ,pay_payroll_actions ppa,hr_soft_coding_keyflex scl where ppa.payroll_action_id=:$flex$.py_nz_soe_payment_run and ppa.payroll_action_id=paa.payroll_action_id and paa.action_status='C' and paa.assignment_id=paf.assignment_id and ppa.effective_date between paf.effective_start_date and paf.effective_end_date and paf.soft_coding_keyflex_id=scl.soft_coding_keyflex_id) order by hro.name US Registered Employer 7 60 :p_sort_order_1 LOV Oracle PY_NZ_SOE_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='NZ_SOE_REPORT_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 1 8 70 :p_sort_order_2 LOV Oracle PY_NZ_SOE_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='NZ_SOE_REPORT_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 2 9 80 :p_sort_order_3 LOV Oracle PY_NZ_SOE_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='NZ_SOE_REPORT_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 3 10 90 :p_sort_order_4 LOV Oracle PY_NZ_SOE_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='NZ_SOE_REPORT_SORT_BY' and enabled_flag='Y' order by meaning select meaning from hr_lookups where lookup_type = 'NZ_SOE_REPORT_SORT_BY' and enabled_flag = 'Y' and lookup_code = 'ASSIGNMENT_NUMBER' Y US Sort Order 4