ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4715751A9E05362FB09050512 SELECT X_PAYEE_PAYROLL_ID ,X_PAYEE_FAMILY_NAME ,X_PAYEE_FIRST_NAME ,X_PAYEE_TFN ,to_char(to_date(X_PERIOD_START_DATE,'YYYY-MM-DD'),'DD-MM-YYYY') X_PERIOD_START_DATE ,to_char(to_date(X_PERIOD_END_DATE,'YYYY-MM-DD'),'DD-MM-YYYY') X_PERIOD_END_DATE ,FINAL_EVENT_IND ,X_TFN_TERM_IND ,X_TFN_EMP_TYPE_CODE ,X_TFN_RESIDENCY_STATUS ,X_TFN_TAX_FREE_THRESHOLD ,X_TFN_HELP_IND ,X_TFN_SFSS_IND ,X_TFN_DECL_DATE ,X_PERIOD_GROSS_PAYMENT ,X_PERIOD_TOTAL_INB_PAYGW ,X_GROSS_PAYMENT ,X_CDEP_PAYMENT ,X_TOTAL_INB_PAYGW ,X_EXEMPT_FOREIGN_INCOME ,X_LUMP_SUM_A_PAYMENT ,X_LUMP_SUM_B_PAYMENT ,X_LUMP_SUM_D_PAYMENT ,X_LUMP_SUM_E_PAYMENT ,X_DEDUCTION_AMOUNT_UF ,X_DEDUCTION_AMOUNT_WG ,X_SUPER_GURANTEE ,X_RESC ,X_FB_NON_EXEMPT ,X_FB_EXEMPT ,X_FW_J_GROSS_PAYMENTS ,X_FW_J_FOREIGN_TAX_PAID ,X_FW_J_TOTAL_TAX_WITHHELD ,X_FW_F_GROSS_PAYMENTS ,X_FW_F_FOREIGN_TAX_PAID ,X_FW_F_TOTAL_TAX_WITHHELD ,X_WHM_GROSS ,X_WHM_PAYGW ,(X_PRE_JUL_83_COMPONENT_ASG_YTD + X_INV_PAYMENT_ASG_YTD) X_PRE_JUL_83_COMPONENT ,X_POST_JUN_83_TAXED_ASG_YTD ,X_LUMP_SUM_C_DEDUCTION ,(X_ALLOWANCE_1_VALUE + X_ALLOWANCE_2_VALUE + X_ALLOWANCE_3_VALUE + X_ALLOWANCE_4_VALUE + X_ALLOWANCE_5_VALUE + X_ALLOWANCE_6_VALUE + X_ALLOWANCE_7_VALUE + X_ALLOWANCE_8_VALUE + X_ALLOWANCE_9_VALUE + X_ALLOWANCE_10_VALUE + X_ALLOWANCE_11_VALUE + X_ALLOWANCE_12_VALUE + X_ALLOWANCE_13_VALUE + X_ALLOWANCE_14_VALUE + X_ALLOWANCE_15_VALUE + X_ALLOWANCE_16_VALUE + X_ALLOWANCE_17_VALUE + X_ALLOWANCE_18_VALUE + X_ALLOWANCE_19_VALUE + X_ALLOWANCE_20_VALUE + X_ALLOWANCE_21_VALUE + X_ALLOWANCE_22_VALUE + X_ALLOWANCE_23_VALUE + X_ALLOWANCE_24_VALUE + X_ALLOWANCE_25_VALUE + X_ALLOWANCE_26_VALUE + X_ALLOWANCE_27_VALUE + X_ALLOWANCE_28_VALUE + X_ALLOWANCE_29_VALUE + X_ALLOWANCE_30_VALUE) ALLOWANCE_TOTAL_AMOUNT ,pay_au_stp_archive.get_etp_codes(ASSIGNMENT_ACTION_ID) AS X_ETP_CODE FROM pay_au_stp_archive_v WHERE payroll_action_id = :P_PAYROLL_ACTION_ID AND X_BAL_ZERO_FLAG <> 'YES' ORDER BY X_PAYEE_PAYROLL_ID Y PAY PYAUSTPVALID_XML US PAY STP Archive Validation Imported from BI Publisher Description: Australian Single Touch Payroll Validation report Application: Payroll Source: STP Archive Validation Report Short Name: PYAUSTPVALID_XML DB package: BI Publisher :p_payroll_action_id 1 -10 :scalableflag Char Y US ScalableFlag 2 10 :p_payroll_action_id Number Y US P_PAYROLL_ACTION_ID