APPS.FA_DELETION_PVT dependencies on FA_CATEGORIES

Line 99: FROM FA_CATEGORIES

95: FROM FA_ADDITIONS_B
96: WHERE LEASE_ID = p_asset_desc_rec.lease_id
97: AND ASSET_CATEGORY_ID =
98: ANY (SELECT CATEGORY_ID
99: FROM FA_CATEGORIES
100: WHERE CATEGORY_TYPE = 'LEASEHOLD IMPROVEMENT');
101:
102: if l_count > 0 then
103: -- can't delete asset