DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 489: from hz_cust_site_uses_all

485: 'BILL_TO',NULL,p_return_status);
486: begin
487: select territory_id
488: into l_territory_id
489: from hz_cust_site_uses_all
490: where site_use_id = l_Site_Use_Id ;
491:
492: exception
493: when no_data_found then

Line 507: from hz_cust_site_uses_all

503: 'SHIP_TO',NULL,p_return_status);
504: begin
505: select territory_id
506: into l_territory_id
507: from hz_cust_site_uses_all
508: where site_use_id =l_Site_Use_Id ;
509:
510: exception
511: when no_data_found then

Line 573: from hz_cust_site_uses_all

569: 'SHIP_TO',NULL, p_return_status);
570: begin
571: select ship_via
572: into l_ship_via_ship_site_default
573: from hz_cust_site_uses_all
574: where site_use_id =l_Site_Use_Id ;
575:
576: exception
577: when no_data_found then