DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 1761: FROM hz_cust_site_uses_all

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

Line 1793: FROM hz_cust_site_uses_all

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