DBA Data[Home] [Help]

APPS.BEN_SAZ_CACHE dependencies on HR_API

Line 97: or nvl(g_sazrzr_current.effective_date,hr_api.g_sot) <> p_eff_date

93: -- Check if cached postal code ranges are for currently
94: -- cached service area. Or the effective date has changed.
95: --
96: if nvl(g_sazrzr_current.svc_area_id,-999999) <> p_svc_area_id
97: or nvl(g_sazrzr_current.effective_date,hr_api.g_sot) <> p_eff_date
98: then
99: --
100: g_sazrzr_svcpzrid_va.delete;
101: --

Line 128: or nvl(g_sazrzr_current.effective_date,hr_api.g_sot) <> p_eff_date

124: -- Check if cached postal code ranges are for the current
125: -- zip code
126: --
127: elsif nvl(g_sazrzr_current.zip_code,'00000') <> p_zip_code
128: or nvl(g_sazrzr_current.effective_date,hr_api.g_sot) <> p_eff_date
129: then
130: --
131: g_sazrzr_zippzrid_va.delete;
132: --