APPS.FA_MASS_RET_PKG dependencies on FA_TRANSACTION_HEADERS

Line 882: from fa_transaction_headers th,

878: AND bk.book_type_code = frt.book_type_code;
879:
880: CURSOR check_current_period_add is
881: select 'FA_RET_CANT_RET_NONDEPRN'
882: from fa_transaction_headers th,
883: fa_book_controls bc,
884: fa_deprn_periods dp
885: where th.asset_id = p_Asset_id
886: AND th.book_type_code = G_Book_Type_Code

Line 898: from fa_transaction_headers fth

894: AND dp.book_type_code = th.book_type_code
895: AND dp.period_close_date is NULL;
896: CURSOR check_other_trans_follow is
897: select 'FA_SHARED_OTHER_TRX'
898: from fa_transaction_headers fth
899: where fth.asset_id = p_Asset_id
900: and fth.book_type_code = G_Book_Type_Code
901: and (fth.transaction_date_entered > G_Retirement_Date
902: and fth.transaction_type_code in ('TAX', 'REVALUATION'));

Line 3187: FROM FA_TRANSACTION_HEADERS fth

3183: OR G_tag_number IS NULL)
3184: AND (faa.manufacturer_name = G_manufacturer_name
3185: OR G_manufacturer_name IS NULL)
3186: AND NOT EXISTS (SELECT null
3187: FROM FA_TRANSACTION_HEADERS fth
3188: WHERE fth.asset_id = fab.asset_id
3189: AND fth.book_type_code = fab.book_type_code
3190: AND (fth.transaction_date_entered > G_Retirement_Date and
3191: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))