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.

[Home] [Help]

APPS.CSF_LF_GEOPVT dependencies on HZ_LOCATIONS

Line 109: l_country_code hz_locations.country%TYPE;

105: , p_lon OUT NOCOPY NUMBER
106: , p_lat OUT NOCOPY NUMBER
107: )
108: IS
109: l_country_code hz_locations.country%TYPE;
110: l_geometry mdsys.sdo_geometry;
111: CURSOR c_country_code (p_country hz_locations.country%TYPE)
112: IS
113: SELECT ftt.territory_code country_code

Line 111: CURSOR c_country_code (p_country hz_locations.country%TYPE)

107: )
108: IS
109: l_country_code hz_locations.country%TYPE;
110: l_geometry mdsys.sdo_geometry;
111: CURSOR c_country_code (p_country hz_locations.country%TYPE)
112: IS
113: SELECT ftt.territory_code country_code
114: FROM fnd_territories_tl ftt
115: WHERE UPPER (ftt.territory_short_name) = UPPER (p_country)