APPS.AMS_EVENTOFFER_PVT dependencies on HZ_LOCATIONS

Line 1607: FROM hz_locations loc, ams_event_offers_all_b evo

1603: WHERE user_id = l_user_id;
1604:
1605: CURSOR c_location(id_in IN NUMBER) IS
1606: SELECT loc.address1, loc.address2, loc.city, loc.state, loc.country
1607: FROM hz_locations loc, ams_event_offers_all_b evo
1608: WHERE loc.location_id = evo.event_location_id
1609: and evo.event_offer_id = id_in;
1610:
1611:

Line 3546: 'hz_locations',

3542: ----------------------- event_location_id ------------------------
3543: IF p_evo_rec.event_location_id <> FND_API.g_miss_num
3544: AND p_evo_rec.event_location_id IS NOT NULL THEN
3545: IF AMS_Utility_PVT.check_fk_exists(
3546: 'hz_locations',
3547: 'location_id',
3548: p_evo_rec.event_location_id
3549: ) = FND_API.g_false
3550: THEN

Line 5122: FROM hz_locations

5118: WHERE event_offer_id = p_evo_rec.event_offer_id;
5119:
5120: CURSOR c_location(loc_id IN NUMBER) IS
5121: SELECT city, state, country
5122: FROM hz_locations
5123: WHERE location_id = loc_id;
5124:
5125: l_evo_rec c_evo%ROWTYPE;
5126: l_city VARCHAR2(60);