APPS.FA_DEPRN_ROLLBACK_PVT dependencies on FA_TRANSACTION_HEADERS

Line 23: from fa_transaction_headers

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

Line 34: from fa_transaction_headers

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

Line 136: from fa_transaction_headers th

132: cursor c_get_pdr_thid
133: is
134: select transaction_header_id
135: , event_id
136: from fa_transaction_headers th
137: where th.asset_id = p_asset_hdr_rec.asset_id
138: and th.book_type_code = p_asset_hdr_rec.book_type_code
139: and th.date_effective between p_period_rec.period_open_date
140: and nvl(p_period_rec.period_close_date, sysdate)

Line 918: SELECT fa_transaction_headers_s.nextval

914: if (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_PROCESSED) then
915: -- Reverse Terminal Gain Loss
916:
917: if (p_mrc_sob_type_code <> 'R') then
918: SELECT fa_transaction_headers_s.nextval
919: INTO l_trans_rec.transaction_header_id
920: FROM DUAL;
921:
922: --

Line 947: INSERT INTO FA_TRANSACTION_HEADERS(

943: ,p_log_level_rec => p_log_level_rec);
944: raise rb_error;
945: end if;
946:
947: INSERT INTO FA_TRANSACTION_HEADERS(
948: TRANSACTION_HEADER_ID
949: , BOOK_TYPE_CODE
950: , ASSET_ID
951: , TRANSACTION_TYPE_CODE

Line 1023: from fa_transaction_headers

1019: , MASS_TRANSACTION_ID
1020: , MEMBER_TRANSACTION_HEADER_ID
1021: , TRX_REFERENCE_ID
1022: , l_trans_rec.event_id -- EVENT_ID
1023: from fa_transaction_headers
1024: where asset_id = p_asset_hdr_rec.asset_id
1025: and book_type_code = p_asset_hdr_rec.book_type_code
1026: and transaction_header_id = l_thid
1027: ;

Line 1389: delete from fa_transaction_headers

1385: END; --annonymous
1386: end if;
1387: -- Rollback Terminal Gain Loss
1388: if (p_mrc_sob_type_code <> 'R') then
1389: delete from fa_transaction_headers
1390: where transaction_header_id = l_thid;
1391:
1392: delete from fa_adjustments
1393: where asset_id = p_asset_hdr_rec.asset_id