DBA Data[Home] [Help]

APPS.BEN_SAZ_CACHE dependencies on HR_API

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

102: -- Check if cached postal code ranges are for currently
103: -- cached service area. Or the effective date has changed.
104: --
105: if nvl(g_sazrzr_current.svc_area_id,-999999) <> p_svc_area_id
106: or nvl(g_sazrzr_current.effective_date,hr_api.g_sot) <> p_eff_date
107: then
108: --
109: g_sazrzr_svcpzrid_va.delete;
110: --

Line 139: or nvl(l_effective_date,hr_api.g_sot) <> p_eff_date

135: --
136: /* Bug 9021884: replaced g_sazrzr_current.effective_date by l_effective_date below*/
137:
138: elsif nvl(g_sazrzr_current.zip_code,'00000') <> p_zip_code
139: or nvl(l_effective_date,hr_api.g_sot) <> p_eff_date
140: then
141: --
142: g_sazrzr_zippzrid_va.delete;
143: --