APPS.HZ_ORG_INFO_VALIDATE dependencies on HZ_STOCK_MARKETS

Line 99: -- stock_exchange_id to hz_stock_markets,

95:
96: END IF;
97:
98: -- validate foreign key: party_id to hz_parties,
99: -- stock_exchange_id to hz_stock_markets,
100: -- security_currency_code to fnd_currencies.
101:
102:
103: IF p_security_issued_rec.party_id is NOT NULL AND

Line 126: FROM hz_stock_markets

122: IF p_security_issued_rec.stock_exchange_id is NOT NULL AND
123: p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM THEN
124:
125: SELECT COUNT(*) INTO l_count
126: FROM hz_stock_markets
127: where stock_exchange_id = p_security_issued_rec.stock_exchange_id;
128:
129: IF l_count = 0 THEN
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_stock_markets');

129: IF l_count = 0 THEN
130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
131: FND_MESSAGE.SET_TOKEN('FK', 'stock_exchange_id');
132: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_stock_markets');
134: FND_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136:
137: END IF;