[Home] [Help]
89: DUE_DATE DATE;
90: AVG_EARNINGS NUMBER(10,2);
91: BEGIN
92: DUE_DATE := M_DUE_DATE;
93: EWC := SSP_PAB_PKG.EXPECTED_WEEK_OF_CONFINEMENT(DUE_DATE);
94: QW := SSP_PAB_PKG.QUALIFYING_WEEK(DUE_DATE);
95: C_EWC := EWC;
96: C_WQ := QW;
97: SELECT
90: AVG_EARNINGS NUMBER(10,2);
91: BEGIN
92: DUE_DATE := M_DUE_DATE;
93: EWC := SSP_PAB_PKG.EXPECTED_WEEK_OF_CONFINEMENT(DUE_DATE);
94: QW := SSP_PAB_PKG.QUALIFYING_WEEK(DUE_DATE);
95: C_EWC := EWC;
96: C_WQ := QW;
97: SELECT
98: AVERAGE_EARNINGS_AMOUNT