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:
Description: Single Touch Payroll Report Declaration to ATO
Application: Payroll
Source: STP Report Declaration
Short Name: PYAUSTPDECL_XML
DB package:
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 |