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