ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713251A9E05362FB09050512 select assignment_id, assignment_action_id, person_id, full_name, assignment_number, position_title, job, salary, location_id, location_code, expense_check_send_to_address, registered_employer, abn, payroll_id, payroll_action_id, time_period_id, period_number, period_start_date, period_end_date, pay_advice_date, date_earned, run_assignment_action_id, run_payroll_action_id, organization_name, grade, PAY_PAYAUSOE_XMLP_PKG.cf_grade_stepformula(assignment_id, date_earned) CF_Grade_Step, PAY_PAYAUSOE_XMLP_PKG.cf_get_miscellaneous_valuesfor(expense_check_send_to_address, person_id, location_id, assignment_id, assignment_action_id, date_earned) CF_get_miscellaneous_values, PAY_PAYAUSOE_XMLP_PKG.cf_period_start_dateformula(assignment_action_id) CF_period_start_date, PAY_PAYAUSOE_XMLP_PKG.cf_net_this_payformula() CF_net_this_pay, PAY_PAYAUSOE_XMLP_PKG.cf_net_ytdformula() CF_net_ytd, PAY_PAYAUSOE_XMLP_PKG.CP_address_line_1_p CP_address_line_1, PAY_PAYAUSOE_XMLP_PKG.CP_address_line_2_p CP_address_line_2, PAY_PAYAUSOE_XMLP_PKG.CP_address_line_3_p CP_address_line_3, PAY_PAYAUSOE_XMLP_PKG.CP_postal_code_p CP_postal_code, PAY_PAYAUSOE_XMLP_PKG.CP_town_city_p CP_town_city, PAY_PAYAUSOE_XMLP_PKG.CP_country_p CP_country, PAY_PAYAUSOE_XMLP_PKG.CP_pre_tax_deductions_this_pa CP_pre_tax_deductions_this_pay, PAY_PAYAUSOE_XMLP_PKG.CP_Direct_Payments_YTD_p CP_Direct_Payments_YTD, PAY_PAYAUSOE_XMLP_PKG.CP_Taxable_Income_YTD_p CP_Taxable_Income_YTD, PAY_PAYAUSOE_XMLP_PKG.CP_Direct_Payments_This_Pay_p CP_Direct_Payments_This_Pay, PAY_PAYAUSOE_XMLP_PKG.CP_Taxable_Income_This_Pay_p CP_Taxable_Income_This_Pay, PAY_PAYAUSOE_XMLP_PKG.CP_pre_tax_deductions_ytd_p CP_pre_tax_deductions_ytd, PAY_PAYAUSOE_XMLP_PKG.CP_non_tax_allow_ytd_p CP_non_tax_allow_ytd, PAY_PAYAUSOE_XMLP_PKG.CP_gross_this_pay_p CP_gross_this_pay, PAY_PAYAUSOE_XMLP_PKG.CP_non_tax_allow_this_pay_p CP_non_tax_allow_this_pay, PAY_PAYAUSOE_XMLP_PKG.CP_other_deductions_this_pay_p CP_other_deductions_this_pay, PAY_PAYAUSOE_XMLP_PKG.CP_tax_deductions_this_pay_p CP_tax_deductions_this_pay, PAY_PAYAUSOE_XMLP_PKG.CP_gross_ytd_p CP_gross_ytd, PAY_PAYAUSOE_XMLP_PKG.CP_other_deductions_ytd_p CP_other_deductions_ytd, PAY_PAYAUSOE_XMLP_PKG.CP_tax_deductions_ytd_p CP_tax_deductions_ytd, PAY_PAYAUSOE_XMLP_PKG.CF_EFECTIVE_DATEFORMULA(assignment_action_id) CF_EFFECTIVE_DATE, 'X' dummy from pay_au_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 and 'Y' = pay_au_soe_pkg.GET_DOC_EIT(assignment_id, run_payroll_action_id) &cp_order_by --,23,12,9,1,2,3,4,5,6,7,8,10,11,12,13,15,16,17,18,19,20,21,22 Y PAY PAYAUSOE_XML US PAY Pay Advice (Australia) Imported from BI Publisher Description: Pay Advice (Australia) Application: Payroll Source: Pay Advice (Australia) (XML) Short Name: PAYAUSOE_XML DB package: PAY_PAYAUSOE_XMLP_PKG BI Publisher &cp_order_by &cp_where_clause :cf_effective_date :cp_accrual :cp_accrual_end_date :cp_address_line_1 :cp_address_line_2 :cp_address_line_3 :cp_country :cp_direct_payments_this_pay :cp_direct_payments_ytd :cp_end_date :cp_foreign_tax_this_pay :cp_foreign_tax_ytd :cp_gross_this_pay :cp_gross_ytd :cp_net_entitlement :cp_non_tax_allow_this_pay :cp_non_tax_allow_ytd :cp_order_by :cp_other_deductions_this_pay :cp_other_deductions_ytd :cp_postal_code :cp_pre_tax_deductions_this_pay :cp_pre_tax_deductions_ytd :cp_start_date :cp_tax_deductions_this_pay :cp_tax_deductions_ytd :cp_taxable_income_this_pay :cp_taxable_income_ytd :cp_town_city :cp_where_clause :p_assignment_id :p_assignment_set :p_business_group_id :p_conc_request_id :p_location_id :p_organisation_name :p_payroll_action_id :p_payroll_id :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 :print_leave_balances :print_leave_taken :print_messages 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_AU_SOE_PAYMENT_RUN Y select payroll_action_id id, to_char(nvl(ppa.pay_advice_date,ppa.effective_date),'DD-MON-YYYY') || ' (' || to_char(ppa.payroll_action_id) || decode(ppa.action_type,'U',' (QuickPay)',null) || ')' value, null description from pay_payroll_actions ppa,pay_payrolls_f ppf where ppa.business_group_id=fnd_global.per_business_group_id and ppa.action_type in ('P','U') and ppa.action_status='C' and ppa.payroll_id=:$flex$.py_srs_payroll and ppf.business_group_id=fnd_global.per_business_group_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 where paa.payroll_action_id=ppa.payroll_action_id and paa.action_status='C' ) order by payroll_action_id Y US Payment Run 4 30 :p_organisation_name LOV Oracle PY_AU_SOE_ORG_UNITS Y select substr(name,1,150) id, substr(name,1,150) value, null description from hr_organization_units where business_group_id=fnd_global.per_business_group_id order by value,description US Organization 5 40 :p_location_id LOV Oracle PY_AU_SOE_LOCATION_CODES Y select location_id id, location_code value, description description from hr_locations where location_use='HR' order by value,description US Location 6 50 :p_assignment_set LOV Oracle PAY_AU_ASSIGNMENT_SET Y select ass_set.assignment_set_id id, ass_set.assignment_set_name value, null description from hr_assignment_sets ass_set,pay_payroll_actions pay where pay.payroll_id=ass_set.payroll_id and pay.payroll_action_id=:$flex$.py_au_soe_payment_run order by ass_set.assignment_set_name US Assignment Set 7 60 :p_assignment_id LOV Oracle PY_AU_SOE_ASG_NUMBER Y select asg.assignment_id id, assignment_number value, null description from per_assignments_f asg,pay_assignment_actions paa,pay_payroll_actions ppa where asg.payroll_id=:$flex$.py_srs_payroll and paa.assignment_id=asg.assignment_id and ppa.payroll_id=asg.payroll_id and ppa.payroll_action_id=paa.payroll_action_id and ppa.payroll_action_id=:$flex$.py_au_soe_payment_run and ppa.effective_date between asg.effective_start_date and asg.effective_end_date and paa.action_status='C' and :$flex$.pay_au_assignment_set:null is null order by asg.assignment_number US Assignment Number 8 70 :p_sort_order_1 LOV Oracle PY_AU_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='AU_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 1 9 80 :p_sort_order_2 LOV Oracle PY_AU_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='AU_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 2 10 90 :p_sort_order_3 LOV Oracle PY_AU_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='AU_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 3 11 100 :p_sort_order_4 LOV Oracle PY_AU_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='AU_SOE_SORT_BY' and enabled_flag='Y' order by meaning SELECT meaning from HR_LOOKUPS where lookup_type = 'AU_SOE_SORT_BY' and lookup_code='ASSIGNMENT_NUMBER' US Sort Order 4 :$flex$.py_au_soe_payment_run Payment Run Assignment Number :$flex$.py_au_soe_payment_run Payment Run Assignment Set :$flex$.py_srs_payroll Payroll Assignment Number :$flex$.py_srs_payroll Payroll Payment Run