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.PAY_GTNLOD_PKG dependencies on PAY_US_CITY_NAMES

Line 654: ls_city_name pay_us_city_names.city_name%TYPE := NULL;

650: END get_county_name;
651:
652: FUNCTION get_city_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
653: RETURN VARCHAR2 IS
654: ls_city_name pay_us_city_names.city_name%TYPE := NULL;
655: CURSOR c_get_city IS
656: SELECT city_name FROM pay_us_city_names
657: WHERE state_code = substr(p_jurisdiction_code,1,2)
658: AND county_code = substr(p_jurisdiction_code,4,3)

Line 656: SELECT city_name FROM pay_us_city_names

652: FUNCTION get_city_name(p_tax_type_code IN VARCHAR2, p_jurisdiction_code IN VARCHAR2)
653: RETURN VARCHAR2 IS
654: ls_city_name pay_us_city_names.city_name%TYPE := NULL;
655: CURSOR c_get_city IS
656: SELECT city_name FROM pay_us_city_names
657: WHERE state_code = substr(p_jurisdiction_code,1,2)
658: AND county_code = substr(p_jurisdiction_code,4,3)
659: AND city_code = substr(p_jurisdiction_code,8,4)
660: AND upper(primary_flag) = 'Y';