PAY Pay Advice (Australia)

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Pay Advice (Australia) (XML)
Short Name: PAYAUSOE_XML
DB package: PAY_PAYAUSOE_XMLP_PKG
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
Business Group Id
 
Number
Sort Order 4
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Assignment Number
 
LOV Oracle
Assignment Set
 
LOV Oracle
Location
 
LOV Oracle
Organization
 
LOV Oracle
Payment Run
 
LOV Oracle
Payroll
 
LOV Oracle