PAY Pay Advice (Australia)
Description
Categories: BI Publisher
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
Description: Pay Advice (Australia)
Application: Payroll
Source: Pay Advice (Australia) (XML)
Short Name: PAYAUSOE_XML
DB package: PAY_PAYAUSOE_XMLP_PKG
Run
PAY Pay Advice (Australia) and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Payroll |
|
LOV Oracle | |
Payment Run |
|
LOV Oracle | |
Organization |
|
LOV Oracle | |
Location |
|
LOV Oracle | |
Assignment Set |
|
LOV Oracle | |
Assignment Number |
|
LOV Oracle | |
Sort Order 1 |
|
LOV Oracle | |
Sort Order 2 |
|
LOV Oracle | |
Sort Order 3 |
|
LOV Oracle | |
Sort Order 4 |
|
LOV Oracle |