PAY STP Archive Validation

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
Blitz Report™