APPS.FA_DET_ADD_PKG dependencies on FA_CATEGORIES_B
Line 153: from fa_categories_b cat
149: where ad.asset_id = X_Asset_Id
150: and ad.lease_id = X_Lease_Id
151: and exists
152: ( select 'X' 153: from fa_categories_b cat 154: where cat.category_id = ad.asset_category_id
155: and cat.category_type = 'LEASEHOLD IMPROVEMENT');
156: --
157: if lv_count > 0 then