APPS.AMS_CHANNEL_PVT dependencies on JTF_LOC_AREAS_VL

Line 1309: p_table_name => 'jtf_loc_hierarchies_vl', --'jtf_loc_areas_vl',

1305: IF p_chan_rec.country_id <> FND_API.g_miss_num THEN
1306:
1307: -- modified by soagrawa on 31-May-2001
1308: IF AMS_Utility_PVT.check_fk_exists(
1309: p_table_name => 'jtf_loc_hierarchies_vl', --'jtf_loc_areas_vl',
1310: p_pk_name => 'location_hierarchy_id', --'location_area_id',
1311: p_pk_value => p_chan_rec.country_id,
1312: p_pk_data_type => AMS_Utility_PVT.G_NUMBER,
1313: -- modified by soagrawa on 28-sep-2001, bug# 2021940

Line 1953: -- FROM jtf_loc_areas_vl

1949: -- get_country_name
1950: -- USAGE
1951: -- Example:
1952: -- SELECT AMS_CHANNEL_PVT.get_country_name (country_id)
1953: -- FROM jtf_loc_areas_vl
1954: -- HISTORY
1955: -- 13-DEC-2000 rrajesh Created.
1956: ---------------------------------------------------------------------
1957: FUNCTION get_country_name (

Line 1966: FROM jtf_loc_areas_vl

1962: l_country_name VARCHAR2(80);
1963:
1964: CURSOR c_country_name IS
1965: SELECT location_area_name
1966: FROM jtf_loc_areas_vl
1967: WHERE location_area_id = p_country_id
1968: AND location_type_code = 'COUNTRY';
1969:
1970: BEGIN