APPS.HZ_BANK_PUB dependencies on HZ_LOCATIONS

Line 1471: FROM hz_locations hl

1467: and nvl(hop.effective_end_date, sysdate+1);
1468:
1469: CURSOR c_sitecountry (p_location_id IN NUMBER) IS
1470: SELECT hl.country
1471: FROM hz_locations hl
1472: WHERE hl.location_id = p_location_id;
1473:
1474: CURSOR c_site IS
1475: SELECT hps.party_id,

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

1562: IF c_sitecountry%NOTFOUND THEN
1563: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
1564: fnd_message.set_token('FK', 'active location');
1565: fnd_message.set_token('COLUMN', 'LOCATION_ID');
1566: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
1567: fnd_msg_pub.add;
1568: x_return_status := fnd_api.g_ret_sts_error;
1569: END IF;
1570: CLOSE c_sitecountry;