VIEW: APPS.SSP_SSPRPSMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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