125: l_rate_change_flag varchar2(1);
126:
127: Cursor c_rate_change_flag is
128: select 'Y'
129: from fa_books fbks1,
130: fa_books fbks2
131: where fbks1.book_type_code = dpr.book
132: and fbks1.asset_id = dpr.asset_id
133: and fbks2.book_type_code = fbks1.book_type_code
126:
127: Cursor c_rate_change_flag is
128: select 'Y'
129: from fa_books fbks1,
130: fa_books fbks2
131: where fbks1.book_type_code = dpr.book
132: and fbks1.asset_id = dpr.asset_id
133: and fbks2.book_type_code = fbks1.book_type_code
134: and fbks2.asset_id = fbks2.asset_id
145: l_deprn_method_code2 varchar2(48);
146: Cursor c_rate_details is
147: select fbks1.adjusted_rate,fbks1.transaction_header_id_in,fbks1.deprn_method_code,
148: fbks2.adjusted_rate,fbks2.transaction_header_id_in,fbks2.deprn_method_code
149: from fa_books fbks1,
150: fa_books fbks2
151: where fbks1.book_type_code=dpr.book
152: and fbks1.asset_id=dpr.asset_id
153: and fbks2.book_type_code =fbks1.book_type_code
146: Cursor c_rate_details is
147: select fbks1.adjusted_rate,fbks1.transaction_header_id_in,fbks1.deprn_method_code,
148: fbks2.adjusted_rate,fbks2.transaction_header_id_in,fbks2.deprn_method_code
149: from fa_books fbks1,
150: fa_books fbks2
151: where fbks1.book_type_code=dpr.book
152: and fbks1.asset_id=dpr.asset_id
153: and fbks2.book_type_code =fbks1.book_type_code
154: and fbks2.asset_id =fbks2.asset_id
434: select outbk.salvage_value - inbk.salvage_value
435: , nvl(outbk.allowed_deprn_limit_amount, 0) -
436: nvl(inbk.allowed_deprn_limit_amount, 0),
437: outbk.unrevalued_cost - inbk.unrevalued_cost
438: from fa_books inbk
439: , fa_books outbk
440: where inbk.transaction_header_id_in = ret.th_id_in
441: and outbk.asset_id = ret.asset_id
442: and outbk.book_type_code = ret.book
435: , nvl(outbk.allowed_deprn_limit_amount, 0) -
436: nvl(inbk.allowed_deprn_limit_amount, 0),
437: outbk.unrevalued_cost - inbk.unrevalued_cost
438: from fa_books inbk
439: , fa_books outbk
440: where inbk.transaction_header_id_in = ret.th_id_in
441: and outbk.asset_id = ret.asset_id
442: and outbk.book_type_code = ret.book
443: and outbk.transaction_header_id_out = ret.th_id_in;
446: select outbk.salvage_value - inbk.salvage_value
447: , nvl(outbk.allowed_deprn_limit_amount, 0) -
448: nvl(inbk.allowed_deprn_limit_amount, 0),
449: outbk.unrevalued_cost - inbk.unrevalued_cost
450: from fa_books_mrc_v inbk
451: , fa_books_mrc_v outbk
452: where inbk.transaction_header_id_in = ret.th_id_in
453: and outbk.asset_id = ret.asset_id
454: and outbk.book_type_code = ret.book
447: , nvl(outbk.allowed_deprn_limit_amount, 0) -
448: nvl(inbk.allowed_deprn_limit_amount, 0),
449: outbk.unrevalued_cost - inbk.unrevalued_cost
450: from fa_books_mrc_v inbk
451: , fa_books_mrc_v outbk
452: where inbk.transaction_header_id_in = ret.th_id_in
453: and outbk.asset_id = ret.asset_id
454: and outbk.book_type_code = ret.book
455: and outbk.transaction_header_id_out = ret.th_id_in;