APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on FND_LOOKUPS

Line 396: FROM fnd_lookups fl

392: AND eiai.status_code IS NOT NULL
393: AND NOT EXISTS
394: (
395: SELECT 1
396: FROM fnd_lookups fl
397: WHERE fl.lookup_type = 'EGO_ASSOCIATION_STATUS'
398: AND fl.lookup_code = eiai.status_code
399: );
400: UPDATE ego_item_associations_intf eiai