APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_TRANSACTION_HEADERS

Line 327: select fa_transaction_headers_s.nextval

323: if (p_trans_rec.amortization_start_date is not null) then
324: px_src_trans_rec.transaction_date_entered := p_trans_rec.amortization_start_date;
325: end if;
326:
327: select fa_transaction_headers_s.nextval
328: into px_src_trans_rec.transaction_header_id
329: from dual;
330:
331: end if;

Line 623: select fa_transaction_headers_s.nextval

619: if (p_trans_rec.amortization_start_date is not null) then
620: px_dest_trans_rec.transaction_date_entered := p_trans_rec.amortization_start_date;
621: end if;
622:
623: select fa_transaction_headers_s.nextval
624: into px_dest_trans_rec.transaction_header_id
625: from dual;
626:
627: end if;

Line 1923: from fa_transaction_headers th1,

1919: where ret.book_type_code = h_book_type_code
1920: and ret.asset_id = h_member_asset_id
1921: and ret.transaction_header_id_in in
1922: (select th1.transaction_header_id
1923: from fa_transaction_headers th1,
1924: fa_deprn_periods dp1,
1925: fa_deprn_periods dp3
1926: where th1.asset_id = ret.asset_id
1927: and dp1.book_type_code = h_book_type_code

Line 1948: from fa_transaction_headers th1,

1944: and ret.asset_id = h_member_asset_id
1945: and ret.set_of_books_id = h_set_of_books_id
1946: and ret.transaction_header_id_in in
1947: (select th1.transaction_header_id
1948: from fa_transaction_headers th1,
1949: fa_deprn_periods dp1,
1950: fa_deprn_periods dp3
1951: where th1.asset_id = ret.asset_id
1952: and dp1.book_type_code = h_book_type_code