[Home] [Help]
1948:
1949: -- cursors
1950: cursor c_ret_id is
1951: select retirement_id,status
1952: from fa_retirements
1953: where book_type_code = p_tax_book
1954: and asset_id = p_asset_id
1955: order by retirement_id desc;
1956:
1978: corp_rt.trade_in_asset_id
1979: from fa_transaction_headers corp_th,
1980: fa_books corp_bk,
1981: fa_books tax_bk,
1982: fa_retirements corp_rt,
1983: fa_additions_b ad,
1984: fa_asset_history ah
1985: where corp_th.transaction_header_id = p_corp_thid
1986: and corp_th.asset_id = ah.asset_id
2121:
2122: select count(*)
2123: into l_count
2124: from fa_transaction_headers th,
2125: fa_retirements ret
2126: where th.book_type_code = p_tax_book
2127: and th.asset_id = p_asset_id
2128: and ret.book_type_code(+) = p_tax_book
2129: and ret.asset_id(+) = p_asset_id
2204:
2205: -- pending ret reinstate
2206: select count(*)
2207: into l_count
2208: from fa_retirements
2209: where book_type_code = p_tax_book
2210: and asset_id = p_asset_id
2211: and status in ('REINSTATE', 'PENDING');
2212:
2278: -- HH: 8364239
2279: BEGIN
2280: select rtx.transaction_header_id_out
2281: into l_tax_reinst_thid
2282: from fa_retirements rt, fa_transaction_headers th,
2283: fa_retirements rtx
2284: where rt.transaction_header_id_out = p_corp_thid
2285: and th.book_type_code = p_tax_book
2286: and th.asset_id = p_asset_id
2279: BEGIN
2280: select rtx.transaction_header_id_out
2281: into l_tax_reinst_thid
2282: from fa_retirements rt, fa_transaction_headers th,
2283: fa_retirements rtx
2284: where rt.transaction_header_id_out = p_corp_thid
2285: and th.book_type_code = p_tax_book
2286: and th.asset_id = p_asset_id
2287: and th.transaction_type_code
2326: /* bug fix 5743332
2327: -- Can't reinstate if asset is already reinstated
2328: select status
2329: into l_ret_status
2330: from fa_retirements
2331: where book_type_code = p_tax_book
2332: and asset_id = p_asset_id
2333: and retirement_id = l_asset_retire_rec.retirement_id;
2334: */