11: then
12: if
13: -- the change in amount crosses the NI LEL boundary
14: ((:old.average_earnings_amount
15: < ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
16: and :new.average_earnings_amount
17: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:new.effective_date))
18: or ((:old.average_earnings_amount
19: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
13: -- the change in amount crosses the NI LEL boundary
14: ((:old.average_earnings_amount
15: < ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
16: and :new.average_earnings_amount
17: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:new.effective_date))
18: or ((:old.average_earnings_amount
19: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
20: and :new.average_earnings_amount
21: < ssp_smp_support_pkg.NI_lower_earnings_limit
15: < ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
16: and :new.average_earnings_amount
17: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:new.effective_date))
18: or ((:old.average_earnings_amount
19: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
20: and :new.average_earnings_amount
21: < ssp_smp_support_pkg.NI_lower_earnings_limit
22: (:new.effective_date))))
23: then
17: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:new.effective_date))
18: or ((:old.average_earnings_amount
19: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)
20: and :new.average_earnings_amount
21: < ssp_smp_support_pkg.NI_lower_earnings_limit
22: (:new.effective_date))))
23: then
24:
25: -- Recalculate SSP only if the change will affect entitlement