[Home] [Help]
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
Name |
MATERNITY_ID |
DUE_DATE |
MPP_START_DATE |
MPP_END_DATE |
EWC |
QW |
ACTUAL_BIRTH_DATE |
PAY_SMP_AS_LUMP_SUM |