APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on FA_CATEGORIES

Line 300: (select category_id from fa_categories

296: select count(*) into ll_count
297: from fa_additions
298: where lease_id = X_Lease_Id
299: and asset_category_id in
300: (select category_id from fa_categories
301: where category_type = 'LEASEHOLD IMPROVEMENT');
302: --
303: if ll_count > 0 then
304: x_err_code := 'FA_ADD_DELETE_LHOLD_BEFORE_RCL';