[Home] [Help]
91: 31-JUL-98 A.Myers 30.42 701750 Only inserting temp_affected row if it
92: does not already exist (new procedure).
93: 01-NOV-99 M.Vilrokx 110.8 960689 Added service.date_start to the cursor
94: csr_personal_details. This date will be
95: passed to ssp_ern_ins.ins in stead of the
96: QW date if the latter is smaller than the
97: service.date_start. When this is not done
98: the ssp_ern_ins.ins procedure will try to
99: validate the QW and raise error 35049
94: csr_personal_details. This date will be
95: passed to ssp_ern_ins.ins in stead of the
96: QW date if the latter is smaller than the
97: service.date_start. When this is not done
98: the ssp_ern_ins.ins procedure will try to
99: validate the QW and raise error 35049
100: because it is before the effective start
101: date of the person.
102: 06-JAN-2000 ILeath 110.9 1021179 Remove the stoppage for
136: 22-NOV-2002 BTHAMMIN 115.16 2663899 SMP was paid one week more than
137: required
138: 27-JAN-2003 GButler 115.17 nocopy fix to average_earnings - 2nd
139: dummy variable created as placeholder
140: to OUT param from ssp_ern_ins
141: 24-FEB-2003 ABlinko 115.18 2811430 Amended csr_maternity in earnings_control
142: for SAP/SPP
143: 17-APR-2003 MMAhmad 115.19 2801805 Amended code for Late Absence Notification
144: 14-MAY-2003 GButler 115.20 2939058 Changes to csr_period_of_service_qw in
479: open csr_average_earnings;
480: fetch csr_average_earnings into l_average_earnings;
481: if csr_average_earnings%notfound
482: then
483: ssp_ern_ins.ins (p_earnings_calculations_id => l_dummy,
484: p_object_version_number => l_dummy2,
485: p_person_id => woman.person_id,
486: p_effective_date => l_effective_date,
487: p_average_earnings_amount => l_average_earnings,