DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on HZ_LOCATIONS

Line 2587: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));

2583: END IF;
2584:
2585: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2586: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2587: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));
2588: END IF;
2589: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2590: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2591: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));

Line 2591: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));

2587: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));
2588: END IF;
2589: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2590: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2591: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));
2592: END IF;
2593:
2594:
2595: if(inv_in_rec.fJurisSTGeoCd is null) then

Line 2602: FROM hz_locations loc

2598: INTO inv_in_rec.fJurisSTStAbbrv
2599: ,inv_in_rec.fJurisSTCoName
2600: ,inv_in_rec.fJurisSTCiName
2601: ,inv_in_rec.fJurisSTZipCd
2602: FROM hz_locations loc
2603: WHERE loc.location_id = NVL(pg_ship_to_loc_id_tab(I),pg_bill_to_loc_id_tab(I));
2604: EXCEPTION
2605: WHEN OTHERS THEN
2606: inv_in_rec.fJurisSTStAbbrv := NULL;