DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1757: FROM hz_cust_site_uses_all

1753: l_return_value BOOLEAN := TRUE;
1754: BEGIN
1755: SELECT 'x'
1756: INTO l_dummy
1757: FROM hz_cust_site_uses_all
1758: WHERE site_use_id = p_bill_to_add_id
1759: AND site_use_code = 'BILL_TO';
1760: -- and ((active_end_date is null) OR (active_end_date >= sysdate));
1761: RETURN l_return_value;

Line 1789: FROM hz_cust_site_uses_all

1785: l_return_value BOOLEAN := TRUE;
1786: BEGIN
1787: SELECT 'x'
1788: INTO l_dummy
1789: FROM hz_cust_site_uses_all
1790: WHERE site_use_id = p_ship_to_add_id
1791: AND site_use_code = 'SHIP_TO';
1792: -- and ((active_end_date is null) OR (active_end_date >= sysdate));
1793: RETURN l_return_value;