APPS.FA_DISTRIBUTION_PVT dependencies on FA_BOOKS

Line 49: FROM fa_books bk,

45:
46: CURSOR c_books (l_book_type_code varchar2,
47: l_asset_id number) IS
48: SELECT bc.book_type_code
49: FROM fa_books bk,
50: fa_book_controls bc
51: WHERE bc.distribution_source_book = l_book_type_code
52: AND bk.book_type_code = bc.book_type_code
53: AND bk.asset_id = l_asset_id

Line 256: -- update fa_books for prior period transfer

252: end if;
253:
254: end if;
255:
256: -- update fa_books for prior period transfer
257: if (px_trans_rec.transaction_type_code = 'TRANSFER') then
258: if not update_books(l_trans_rec,
259: l_asset_hdr_rec,
260: l_period_rec

Line 612: from fa_books

608:
609: if (l_asset_type_rec_old.asset_type <> 'GROUP') then
610: select group_asset_id
611: into l_group_asset_id
612: from fa_books
613: where asset_id = p_asset_hdr_rec.asset_id
614: and book_type_code = p_asset_hdr_rec.book_type_code
615: and date_ineffective is null;
616: end if;

Line 1135: update fa_books fabk

1131:
1132: -- if prior period transfer, update books
1133: if (p_trans_rec.transaction_date_entered < p_period_rec.calendar_period_open_date) then
1134:
1135: update fa_books fabk
1136: set adjustment_required_status =
1137: decode(l_allow_backdated_transfers,
1138: 'N',adjustment_required_status,
1139: 'TFR'),

Line 1199: from fa_books

1195: BEGIN
1196:
1197: select transaction_header_id_in
1198: into l_Book_Header_Id
1199: from fa_books
1200: where asset_id = p_asset_hdr_rec.asset_id
1201: and book_type_code = p_asset_hdr_rec.book_type_code
1202: and date_ineffective is null;
1203: