DBA Data[Home] [Help]

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