APPS.FA_DISTRIBUTION_PVT dependencies on FA_RETIREMENTS

Line 937: from fa_retirements

933:
934: if (p_trans_rec.transaction_type_code = 'TRANSFER OUT') then
935: select transaction_header_id_in
936: into l_txn_id
937: from fa_retirements
938: where asset_id = p_asset_hdr_rec.asset_id
939: and book_type_code = p_asset_hdr_rec.book_type_code
940: and status = 'PENDING';
941: else

Line 1207: from fa_retirements

1203:
1204: if p_trans_rec.transaction_type_code = 'TRANSFER OUT' then
1205: select retirement_id
1206: into l_retirement_id
1207: from fa_retirements
1208: where asset_id = p_asset_hdr_rec.asset_id
1209: and book_type_code = p_asset_hdr_rec.book_type_code
1210: and status = 'PENDING';
1211: --l_retirement_id := 8888;