Product: | SSP - SSP |
---|---|
Description: | Base view for SSPWSMAT form maternities block. |
Implementation/DBA Data: | APPS.SSP_SSPWSMAT_V |
SELECT MAT.MATERNITY_ID
, MAT.PERSON_ID
, MAT.DUE_DATE
, MAT.MPP_START_DATE
, SSP_SMP_PKG.EXPECTED_WEEK_OF_CONFINEMENT (MAT.DUE_DATE)
, SSP_SMP_PKG.EARLIEST_MPP_START_DATE (MAT.DUE_DATE)
, SSP_SMP_PKG.QUALIFYING_WEEK (MAT.DUE_DATE)
, SSP_SMP_PKG.CONTINUOUS_EMPLOYMENT_DATE (MAT.DUE_DATE)
, MAT.PAY_SMP_AS_LUMP_SUM
, MAT.SMP_MUST_BE_PAID_BY_DATE
, MAT.START_DATE_WITH_NEW_EMPLOYER
, MAT.START_DATE_MATERNITY_ALLOWANCE
, MAT.NOTIFICATION_OF_BIRTH_DATE
, MAT.LIVE_BIRTH_FLAG
, MAT.ACTUAL_BIRTH_DATE
, MAT.STATED_RETURN_DATE
, MAT.INTEND_TO_RETURN_FLAG
, MAT.UNFIT_FOR_SCHEDULED_RETURN
, MAT.OBJECT_VERSION_NUMBER
, MAT.ATTRIBUTE_CATEGORY
, MAT.ATTRIBUTE1
, MAT.ATTRIBUTE2
, MAT.ATTRIBUTE3
, MAT.ATTRIBUTE4
, MAT.ATTRIBUTE5
, MAT.ATTRIBUTE6
, MAT.ATTRIBUTE7
, MAT.ATTRIBUTE8
, MAT.ATTRIBUTE9
, MAT.ATTRIBUTE10
, MAT.ATTRIBUTE11
, MAT.ATTRIBUTE12
, MAT.ATTRIBUTE13
, MAT.ATTRIBUTE14
, MAT.ATTRIBUTE15
, MAT.ATTRIBUTE16
, MAT.ATTRIBUTE17
, MAT.ATTRIBUTE18
, MAT.ATTRIBUTE19
, MAT.ATTRIBUTE20
, MAT.CREATED_BY
, MAT.CREATION_DATE
, MAT.LAST_UPDATE_DATE
, MAT.LAST_UPDATED_BY
, MAT.LAST_UPDATE_LOGIN
FROM SSP_MATERNITIES MAT