APPS.ZX_TCM_GET_DEF_EXEMPTION dependencies on HZ_LOCATIONS

Line 192: l_log_msg := 'B: SEL hz_locations: in: p_ship_to_party_site_id='||p_ship_to_party_site_id;

188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: -- Logging Infra: Statement level: "B" means "B"reak point
191: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
192: l_log_msg := 'B: SEL hz_locations: in: p_ship_to_party_site_id='||p_ship_to_party_site_id;
193: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
194: END IF;
195:
196: SELECT hzl.COUNTRY

Line 198: FROM hz_locations hzl,

194: END IF;
195:
196: SELECT hzl.COUNTRY
197: INTO l_country_code
198: FROM hz_locations hzl,
199: hz_party_sites hzp
200: WHERE hzl.location_id = hzp.location_id
201: AND hzp.PARTY_SITE_ID = p_ship_to_party_site_id;
202:

Line 205: l_log_msg := 'R: SEL hz_locations:: out: l_country_code='||l_country_code;

201: AND hzp.PARTY_SITE_ID = p_ship_to_party_site_id;
202:
203: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
204: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
205: l_log_msg := 'R: SEL hz_locations:: out: l_country_code='||l_country_code;
206: l_log_msg := l_log_msg ||' B: get_tax_subscriber: in: p_legal_entity_id, p_org_id='||p_legal_entity_id||p_org_id;
207: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
208: END IF;
209: