APPS.OE_AUDIT_HISTORY_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 59: FROM HZ_CUST_SITE_USES_ALL

55: IF attribute_value is not null then
56: BEGIN
57: SELECT LOCATION
58: INTO l_attribute_display_value
59: FROM HZ_CUST_SITE_USES_ALL
60: WHERE site_use_id = attribute_value
61: AND SITE_USE_CODE = 'DELIVER_TO'
62: AND ROWNUM = 1;
63: END;

Line 79: FROM HZ_CUST_SITE_USES_ALL

75: IF attribute_value is not null then
76: BEGIN
77: SELECT LOCATION
78: INTO l_attribute_display_value
79: FROM HZ_CUST_SITE_USES_ALL
80: WHERE site_use_id = attribute_value
81: AND SITE_USE_CODE = 'BILL_TO'
82: AND ROWNUM = 1;
83: END;

Line 118: FROM HZ_CUST_SITE_USES_ALL

114: IF attribute_value is not null then
115: BEGIN
116: SELECT LOCATION
117: INTO l_attribute_display_value
118: FROM HZ_CUST_SITE_USES_ALL
119: WHERE site_use_id = attribute_value
120: AND SITE_USE_CODE = 'SHIP_TO'
121: AND ROWNUM = 1;
122: END;