PAY STP Archive Validation

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Australian Single Touch Payroll Validation report
Application: Payroll
Source: STP Archive Validation Report
Short Name: PYAUSTPVALID_XML
DB package:
Run PAY STP Archive Validation and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
P_PAYROLL_ACTION_ID 
 
 Number
Download
Related Blitz Reports
PAY STP W1 and W2 Reporting PAY STP Archive Exception PAY Payroll Reconciliation Detail PAY STP Report Declaration JG JE GL Profit and Loss Report - Portugal PAY Pay Advice (Australia) PAY Superannuation Contribution PAY Leave Liability Report (Australasia) PAY NZ Payday Reconciliation
Blitz Report™

Blitz Report™ provides multiple benefits: