483: 'BILL_TO',NULL,p_return_status);
484: begin
485: select territory_id
486: into l_territory_id
487: from hz_cust_site_uses_all
488: where site_use_id = l_Site_Use_Id ;
489:
490: exception
491: when no_data_found then
501: 'SHIP_TO',NULL,p_return_status);
502: begin
503: select territory_id
504: into l_territory_id
505: from hz_cust_site_uses_all
506: where site_use_id =l_Site_Use_Id ;
507:
508: exception
509: when no_data_found then
567: 'SHIP_TO',NULL, p_return_status);
568: begin
569: select ship_via
570: into l_ship_via_ship_site_default
571: from hz_cust_site_uses_all
572: where site_use_id =l_Site_Use_Id ;
573:
574: exception
575: when no_data_found then