DBA Data[Home] [Help]

APPS.SSP_ERN_T1 dependencies on SSP_SMP_SUPPORT_PKG

Line 15: < ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)

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)

Line 17: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:new.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

Line 19: >= ssp_smp_support_pkg.NI_lower_earnings_limit (:old.effective_date)

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

Line 21: < ssp_smp_support_pkg.NI_lower_earnings_limit

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