eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PSTL_ZIP_RNG_F

Line 2116: FROM ben_pstl_zip_rng_f zip

2112: CURSOR get_zip_ranges(p_pstl_zip_rng_id IN NUMBER
2113: ,p_postal_code IN VARCHAR2
2114: ,cv_effective_date in date) IS
2115: SELECT zip.from_value, zip.to_value
2116: FROM ben_pstl_zip_rng_f zip
2117: WHERE zip.pstl_zip_rng_id = p_pstl_zip_rng_id
2118: AND LENGTH(p_postal_code) >= LENGTH(zip.from_value)
2119: AND (SUBSTR( nvl(p_postal_code,'-1'),1,LENGTH(zip.from_value))
2120: BETWEEN zip.from_value AND NVL(zip.to_value,p_postal_code)

Line 2760: FROM ben_pstl_zip_rng_f zip

2756: CURSOR get_zip_ranges(p_svc_area_id IN NUMBER
2757: ,p_postal_code in VARCHAR2
2758: ,cv_effective_date in date) IS
2759: SELECT zip.from_value, zip.to_value
2760: FROM ben_pstl_zip_rng_f zip
2761: WHERE zip.pstl_zip_rng_id IN (
2762: SELECT pstl_zip_rng_id
2763: FROM ben_svc_area_pstl_zip_rng_f rng
2764: WHERE rng.SVC_AREA_ID = p_svc_area_id