APPS.HZ_BANK_PUB dependencies on HZ_LOCATIONS

Line 1483: FROM hz_locations hl

1479: and nvl(hop.effective_end_date, sysdate+1);
1480:
1481: CURSOR c_sitecountry (p_location_id IN NUMBER) IS
1482: SELECT hl.country
1483: FROM hz_locations hl
1484: WHERE hl.location_id = p_location_id;
1485:
1486: CURSOR c_site IS
1487: SELECT hps.party_id,

Line 1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');

1574: IF c_sitecountry%NOTFOUND THEN
1575: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1576: fnd_message.set_token('FK', 'active location');
1577: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1578: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1579: fnd_msg_pub.add;
1580: x_return_status := fnd_api.g_ret_sts_error;
1581: END IF;
1582: CLOSE c_sitecountry;