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_CA_CITY_UPD dependencies on PAY_CA_DISPLAY_CITIES

Line 38: TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;

34: duplicates from pay_us_city_names
35: */
36:
37: TYPE prov_list IS TABLE OF pay_us_counties.county_abbrev%type INDEX BY BINARY_INTEGER;
38: TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;
39: TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;
40: TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;
41: TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;
42: TYPE primary_flag_list IS TABLE OF pay_us_city_names.primary_flag%type INDEX BY BINARY_INTEGER;

Line 39: TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;

35: */
36:
37: TYPE prov_list IS TABLE OF pay_us_counties.county_abbrev%type INDEX BY BINARY_INTEGER;
38: TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;
39: TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;
40: TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;
41: TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;
42: TYPE primary_flag_list IS TABLE OF pay_us_city_names.primary_flag%type INDEX BY BINARY_INTEGER;
43:

Line 40: TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;

36:
37: TYPE prov_list IS TABLE OF pay_us_counties.county_abbrev%type INDEX BY BINARY_INTEGER;
38: TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;
39: TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;
40: TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;
41: TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;
42: TYPE primary_flag_list IS TABLE OF pay_us_city_names.primary_flag%type INDEX BY BINARY_INTEGER;
43:
44: FUNCTION get_derived_locale(p_town_or_city in varchar2,

Line 41: TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;

37: TYPE prov_list IS TABLE OF pay_us_counties.county_abbrev%type INDEX BY BINARY_INTEGER;
38: TYPE county_code_list IS TABLE OF pay_ca_display_cities.county_code%type INDEX BY BINARY_INTEGER;
39: TYPE city_code_list IS TABLE OF pay_ca_display_cities.city_code%type INDEX BY BINARY_INTEGER;
40: TYPE old_city_name_list IS TABLE OF pay_ca_display_cities.city_name%type INDEX BY BINARY_INTEGER;
41: TYPE new_city_name_list IS TABLE OF pay_ca_display_cities.display_city_name%type INDEX BY BINARY_INTEGER;
42: TYPE primary_flag_list IS TABLE OF pay_us_city_names.primary_flag%type INDEX BY BINARY_INTEGER;
43:
44: FUNCTION get_derived_locale(p_town_or_city in varchar2,
45: p_country in varchar2)