124: -- both categories must be capitalized or expensed types
125: --
126: select capitalize_flag, category_type
127: into lv_new_cap_flag, X_New_Cat_Type
128: from fa_categories
129: where category_id = X_New_Cat_Id;
130: --
131: if X_Old_Cap_Flag = 'YES' then
132: if lv_new_cap_flag = 'NO' then
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