115: WHERE code_combination_id = l_asset_key_id;
116:
117: cursor c_fromasset is
118: Select 'Validated'
119: From fa_books bk,
120: fa_additions ad
121: Where ad.asset_number = l_from_asset_no
122: And ad.asset_id = bk.asset_id
123: And bk.book_type_code = l_book
124: And bk.date_ineffective is null;
125:
126: cursor c_toasset is
127: Select 'Validated'
128: From fa_books bk,
129: fa_additions ad
130: Where ad.asset_number = l_to_asset_no
131: And ad.asset_id = bk.asset_id
132: And bk.book_type_code = l_book