APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_TRANSACTION_HEADERS

Line 323: select fa_transaction_headers_s.nextval

319: px_src_trans_rec.transaction_subtype := 'AMORTIZED';
320: px_src_trans_rec.transaction_key := 'GC';
321: px_src_trans_rec.transaction_date_entered := p_trans_rec.amortization_start_date;
322:
323: select fa_transaction_headers_s.nextval
324: into px_src_trans_rec.transaction_header_id
325: from dual;
326:
327: end if;

Line 739: from fa_transaction_headers

735: elsif (l_group_reclass_code = 'NONE-GRP') then -- reporting is implied in else
736:
737: select transaction_header_id
738: into l_trans_rec.transaction_header_id
739: from fa_transaction_headers
740: where asset_id = p_asset_hdr_rec.asset_id
741: and book_type_code = p_asset_hdr_rec.book_type_code
742: and transaction_type_code = 'TRANSFER'
743: and transaction_header_id > p_trans_rec.transaction_header_id;

Line 803: select fa_transaction_headers_s.nextval

799: px_dest_trans_rec.transaction_key := 'GC';
800: px_dest_trans_rec.transaction_date_entered := p_trans_rec.amortization_start_date;
801:
802:
803: select fa_transaction_headers_s.nextval
804: into px_dest_trans_rec.transaction_header_id
805: from dual;
806:
807: end if;

Line 2160: from fa_transaction_headers th1,

2156: where ret.book_type_code = h_book_type_code
2157: and ret.asset_id = h_member_asset_id
2158: and ret.transaction_header_id_in in
2159: (select th1.transaction_header_id
2160: from fa_transaction_headers th1,
2161: fa_deprn_periods dp1,
2162: fa_deprn_periods dp3
2163: where th1.asset_id = ret.asset_id
2164: and dp1.book_type_code = h_book_type_code

Line 2185: from fa_transaction_headers th1,

2181: and ret.asset_id = h_member_asset_id
2182: and ret.set_of_books_id = h_set_of_books_id
2183: and ret.transaction_header_id_in in
2184: (select th1.transaction_header_id
2185: from fa_transaction_headers th1,
2186: fa_deprn_periods dp1,
2187: fa_deprn_periods dp3
2188: where th1.asset_id = ret.asset_id
2189: and dp1.book_type_code = h_book_type_code