DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 487: from hz_cust_site_uses_all

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

Line 505: from hz_cust_site_uses_all

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

Line 571: from hz_cust_site_uses_all

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