APPS.FA_DISTRIBUTION_PVT dependencies on FA_RETIREMENTS

Line 1074: from fa_retirements

1070:
1071: if (p_trans_rec.transaction_type_code = 'TRANSFER OUT') then
1072: select transaction_header_id_in
1073: into l_txn_id
1074: from fa_retirements
1075: where asset_id = p_asset_hdr_rec.asset_id
1076: and book_type_code = p_asset_hdr_rec.book_type_code
1077: and status = 'PENDING';
1078: --l_txn_id := 9999;

Line 1447: from fa_retirements

1443:
1444: if p_trans_rec.transaction_type_code = 'TRANSFER OUT' then
1445: select retirement_id
1446: into l_retirement_id
1447: from fa_retirements
1448: where asset_id = p_asset_hdr_rec.asset_id
1449: and book_type_code = p_asset_hdr_rec.book_type_code
1450: and status = 'PENDING';
1451: --l_retirement_id := 8888;