APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_TRANSACTION_HEADERS

Line 21: from fa_transaction_headers

17:
18: CURSOR c_get_thid IS
19: select transaction_header_id
20: , event_id
21: from fa_transaction_headers
22: where asset_id = p_asset_hdr_rec.asset_id
23: and book_type_code = p_asset_hdr_rec.book_type_code
24: and date_effective between p_period_rec.period_open_date
25: and nvl(p_period_rec.period_close_date, sysdate)

Line 32: from fa_transaction_headers

28:
29: CURSOR c_get_new_thid IS
30: select transaction_header_id
31: , date_effective
32: from fa_transaction_headers
33: where asset_id = p_asset_hdr_rec.asset_id
34: and book_type_code = p_asset_hdr_rec.book_type_code
35: and date_effective between p_period_rec.period_open_date
36: and nvl(p_period_rec.period_close_date, sysdate)

Line 720: SELECT fa_transaction_headers_s.nextval

716: if (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
717: -- Reverse Terminal Gain Loss
718:
719: if (p_mrc_sob_type_code <> 'R') then
720: SELECT fa_transaction_headers_s.nextval
721: INTO l_trans_rec.transaction_header_id
722: FROM DUAL;
723:
724: --

Line 749: INSERT INTO FA_TRANSACTION_HEADERS(

745: ,p_log_level_rec => p_log_level_rec);
746: raise rb_error;
747: end if;
748:
749: INSERT INTO FA_TRANSACTION_HEADERS(
750: TRANSACTION_HEADER_ID
751: , BOOK_TYPE_CODE
752: , ASSET_ID
753: , TRANSACTION_TYPE_CODE

Line 825: from fa_transaction_headers

821: , MASS_TRANSACTION_ID
822: , MEMBER_TRANSACTION_HEADER_ID
823: , TRX_REFERENCE_ID
824: , l_trans_rec.event_id -- EVENT_ID
825: from fa_transaction_headers
826: where asset_id = p_asset_hdr_rec.asset_id
827: and book_type_code = p_asset_hdr_rec.book_type_code
828: and transaction_header_id = l_thid
829: ;

Line 1170: delete from fa_transaction_headers

1166: p_security_context => l_security_context);
1167:
1168: -- Rollback Terminal Gain Loss
1169: if (p_mrc_sob_type_code <> 'R') then
1170: delete from fa_transaction_headers
1171: where transaction_header_id = l_thid;
1172:
1173: delete from fa_adjustments
1174: where asset_id = p_asset_hdr_rec.asset_id