PAY STP Report Declaration

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Single Touch Payroll Report Declaration to ATO
Application: Payroll
Source: STP Report Declaration
Short Name: PYAUSTPDECL_XML
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select meaning
         from fnd_lookup_values_vl
         where lookup_type = 'PY_AU_STP_SSP'
         and lookup_code = :P_DECL_SSP
         and :P_REQUEST_DATE between start_date_active and nvl(end_date_active, to_date('4712/12/31','YYYY/MM/DD'))
Parameter Name SQL text Validation
P_DECL_USER_ID
 
Char
P_DECL_SSP
 
Char
P_REQUEST_DATE
 
Char
P_REQUEST_ID
 
Char