APPS.BEN_SAZ_CACHE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

    select saz.pstl_zip_rng_id
    from   ben_svc_area_pstl_zip_rng_f saz
    where  saz.SVC_AREA_ID = c_svc_area_id
    and    c_eff_date
      between saz.effective_start_date and saz.effective_end_date;

Line: 76

    select rzr.pstl_zip_rng_id
    from   ben_pstl_zip_rng_f rzr
    where
           length(c_zip_code) >= length(rzr.from_value)
    and
           (substr(c_zip_code,1,length(rzr.from_value))
      between rzr.from_value and rzr.to_value
           )
    and    c_eff_date
      between rzr.effective_start_date and rzr.effective_end_date;

Line: 109

    g_sazrzr_svcpzrid_va.delete;

Line: 142

    g_sazrzr_zippzrid_va.delete;

Line: 204

  g_sazrzr_svcpzrid_va.delete;

Line: 205

  g_sazrzr_zippzrid_va.delete;