APPS.OE_AUDIT_HISTORY_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 126: FROM HZ_CUST_SITE_USES_ALL

122: IF attribute_value is not null then
123: BEGIN
124: SELECT LOCATION
125: INTO l_attribute_display_value
126: FROM HZ_CUST_SITE_USES_ALL
127: WHERE site_use_id = attribute_value
128: AND SITE_USE_CODE = 'DELIVER_TO'
129: AND ROWNUM = 1;
130: END;

Line 146: FROM HZ_CUST_SITE_USES_ALL

142: IF attribute_value is not null then
143: BEGIN
144: SELECT LOCATION
145: INTO l_attribute_display_value
146: FROM HZ_CUST_SITE_USES_ALL
147: WHERE site_use_id = attribute_value
148: AND SITE_USE_CODE = 'BILL_TO'
149: AND ROWNUM = 1;
150: END;

Line 190: FROM HZ_CUST_SITE_USES_ALL

186: IF attribute_value is not null then
187: BEGIN
188: SELECT LOCATION
189: INTO l_attribute_display_value
190: FROM HZ_CUST_SITE_USES_ALL
191: WHERE site_use_id = attribute_value
192: AND SITE_USE_CODE = 'SHIP_TO'
193: AND ROWNUM = 1;
194: END;