APPS.FA_MASS_RET_PKG dependencies on FA_TRANSACTION_HEADERS

Line 895: from fa_transaction_headers th,

891: AND bk.book_type_code = frt.book_type_code;
892: /* Excluded due to SLA
893: CURSOR check_current_period_add is
894: select 'FA_RET_CANT_RET_NONDEPRN'
895: from fa_transaction_headers th,
896: fa_book_controls bc,
897: fa_deprn_periods dp
898: where th.asset_id = p_Asset_id
899: AND th.book_type_code = G_Book_Type_Code

Line 915: FA_TRANSACTION_HEADERS th

911: CURSOR check_current_period_cap is
912: select 'FA_RET_CANT_RET_NONDEPRN'
913: from FA_BOOKS fab,
914: FA_DEPRN_PERIODS dp,
915: FA_TRANSACTION_HEADERS th
916: where
917: fab.transaction_header_id_in = th.transaction_header_id
918: and fab.book_type_code = G_Book_Type_Code
919: and fab.asset_id = p_Asset_id

Line 928: from fa_transaction_headers fth

924: and dp.period_close_date is NULL;
925: */
926: CURSOR check_other_trans_follow is
927: select 'FA_SHARED_OTHER_TRX'
928: from fa_transaction_headers fth
929: where fth.asset_id = p_Asset_id
930: and fth.book_type_code = G_Book_Type_Code
931: and (fth.transaction_date_entered > G_Retirement_Date
932: and fth.transaction_type_code in ('TAX', 'REVALUATION'));

Line 3356: FROM FA_TRANSACTION_HEADERS fth

3352: OR G_tag_number IS NULL)
3353: AND (faa.manufacturer_name = G_manufacturer_name
3354: OR G_manufacturer_name IS NULL)
3355: AND NOT EXISTS (SELECT null
3356: FROM FA_TRANSACTION_HEADERS fth
3357: WHERE fth.asset_id = fab.asset_id
3358: AND fth.book_type_code = fab.book_type_code
3359: AND (fth.transaction_date_entered > G_Retirement_Date and
3360: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))