DBA Data[Home] [Help]

APPS.OE_INLINE_CUSTOMER_PUB dependencies on HZ_CUST_SITE_USES

Line 1657: from hz_cust_site_uses

1653: p_type_of_address = 'SHIP_TO' Then
1654:
1655: begin --bug#5566811
1656: select 'Y' into l_site_id_exists
1657: from hz_cust_site_uses
1658: where site_use_id=address_info_rec.new_address_id_ship
1659: and status='A';
1660:
1661: if l_site_id_exists='Y' then

Line 1682: from hz_cust_site_uses

1678: p_type_of_address = 'BILL_TO' Then
1679:
1680: begin --bug#5566811
1681: select 'Y' into l_site_id_exists
1682: from hz_cust_site_uses
1683: where site_use_id=address_info_rec.new_address_id_bill
1684: and status='A';
1685:
1686: if l_site_id_exists='Y' then

Line 1707: from hz_cust_site_uses

1703: p_type_of_address = 'DELIVER_TO' Then
1704:
1705: begin --bug#5566811
1706: select 'Y' into l_site_id_exists
1707: from hz_cust_site_uses
1708: where site_use_id=address_info_rec.new_address_id_deliver
1709: and status='A';
1710:
1711: if l_site_id_exists='Y' then