View: SSP_SSPRPSMP_V

Product:	SSP - SSP
Description:	Details of a Maternity Pay Period, including derived dates, used in SMP reports.
Implementation/DBA Data:	APPS.SSP_SSPRPSMP_V

View Text

SELECT MAT.MATERNITY_ID
, MAT.DUE_DATE
, MAT.MPP_START_DATE
, NEXT_DAY (MAX (ENT.DATE_FROM)
, 'SATURDAY')
, SSP_SMP_PKG.EXPECTED_WEEK_OF_CONFINEMENT (MAT.DUE_DATE)
, SSP_SMP_PKG.QUALIFYING_WEEK (MAT.DUE_DATE)
, MAT.ACTUAL_BIRTH_DATE
, MAT.PAY_SMP_AS_LUMP_SUM
FROM SSP_MATERNITIES MAT
, SSP_SMP_ENTRIES_V ENT
WHERE MAT.MATERNITY_ID = ENT.MATERNITY_ID GROUP BY MAT.MATERNITY_ID
, MAT.DUE_DATE
, MAT.MPP_START_DATE
, SSP_SMP_PKG.EXPECTED_WEEK_OF_CONFINEMENT (MAT.DUE_DATE)
, SSP_SMP_PKG.QUALIFYING_WEEK (MAT.DUE_DATE)
, MAT.ACTUAL_BIRTH_DATE
, MAT.PAY_SMP_AS_LUMP_SUM

Columns