APPS.FA_DELETION_PVT dependencies on FA_CATEGORIES
Line 115: FROM FA_CATEGORIES
111: FROM FA_ADDITIONS_B
112: WHERE LEASE_ID = p_asset_desc_rec.lease_id
113: AND ASSET_CATEGORY_ID =
114: ANY (SELECT CATEGORY_ID 115: FROM FA_CATEGORIES 116: WHERE CATEGORY_TYPE = 'LEASEHOLD IMPROVEMENT');
117:
118: if l_count > 0 then
119: -- can't delete asset