APPS.FA_MASSCP_PKG dependencies on FA_RETIREMENTS

Line 1658: from fa_retirements

1654:
1655: -- cursors
1656: cursor c_ret_id is
1657: select max(retirement_id)
1658: from fa_retirements
1659: where book_type_code = p_tax_book
1660: and asset_id = p_asset_id
1661: and transaction_header_id_out is null;
1662:

Line 1688: fa_retirements corp_rt,

1684: corp_rt.trade_in_asset_id
1685: from fa_transaction_headers corp_th,
1686: fa_books corp_bk,
1687: fa_books tax_bk,
1688: fa_retirements corp_rt,
1689: fa_additions_b ad,
1690: fa_asset_history ah
1691: where corp_th.transaction_header_id = p_corp_thid
1692: and corp_th.asset_id = ah.asset_id

Line 1831: fa_retirements ret

1827:
1828: select count(*)
1829: into l_count
1830: from fa_transaction_headers th,
1831: fa_retirements ret
1832: where th.book_type_code = p_tax_book
1833: and th.asset_id = p_asset_id
1834: and ret.book_type_code(+) = p_tax_book
1835: and ret.asset_id(+) = p_asset_id

Line 1914: from fa_retirements

1910:
1911: -- pending ret reinstate
1912: select count(*)
1913: into l_count
1914: from fa_retirements
1915: where book_type_code = p_tax_book
1916: and asset_id = p_asset_id
1917: and status in ('REINSTATE', 'PENDING');
1918:

Line 1965: from fa_retirements rt,

1961: -- verify asset has been retired (from fampvt)
1962: -- combine with the cursor???
1963: select count(*)
1964: into l_count
1965: from fa_retirements rt,
1966: fa_transaction_headers th
1967: where rt.transaction_header_id_out = p_corp_thid
1968: and th.book_type_code = p_tax_book
1969: and th.asset_id = p_asset_id

Line 1995: from fa_retirements

1991:
1992: -- Can't reinstate if asset is already reinstated
1993: select status
1994: into l_ret_status
1995: from fa_retirements
1996: where book_type_code = p_tax_book
1997: and asset_id = p_asset_id
1998: and retirement_id = l_asset_retire_rec.retirement_id;
1999: