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_ELIG_PROFILES dependencies on BEN_PSTL_ZIP_RNG_F

Line 3839: from ben_pstl_zip_rng_f zip

3835: --
3836: cursor get_zip_ranges(p_svc_area_id in number
3837: ,p_zip_code in VARCHAR2) is
3838: select zip.from_value, zip.to_value
3839: from ben_pstl_zip_rng_f zip
3840: where zip.pstl_zip_rng_id in (
3841: select pstl_zip_rng_id
3842: from ben_svc_area_pstl_zip_rng_f rng
3843: where rng.SVC_AREA_ID = p_svc_area_id

Line 3986: from ben_pstl_zip_rng_f zip

3982: --
3983: cursor get_zip_ranges(p_pstl_zip_rng_id in number
3984: ,p_zip_code in VARCHAR2) is
3985: select zip.from_value, zip.to_value
3986: from ben_pstl_zip_rng_f zip
3987: where zip.pstl_zip_rng_id = p_pstl_zip_rng_id
3988: and length(p_zip_code) >= length(zip.from_value)
3989: and (substr( nvl(p_zip_code,'-1'),1,length(zip.from_value))
3990: between zip.from_value and nvl(zip.to_value,p_zip_code)