APPS.FA_DISTRIBUTION_PVT dependencies on FA_BOOKS

Line 55: FROM fa_books bk,

51:
52: CURSOR c_books (l_book_type_code varchar2,
53: l_asset_id number) IS
54: SELECT bc.book_type_code
55: FROM fa_books bk,
56: fa_book_controls bc
57: WHERE bc.distribution_source_book = l_book_type_code
58: AND bk.book_type_code = bc.book_type_code
59: AND bk.asset_id = l_asset_id

Line 320: -- update fa_books for prior period transfer

316: end if;
317:
318: end if;
319:
320: -- update fa_books for prior period transfer
321: if (px_trans_rec.transaction_type_code = 'TRANSFER' and
322: G_release = 11) then
323: if not update_books(l_trans_rec,
324: l_asset_hdr_rec,

Line 759: from fa_books

755:
756: if (l_asset_type_rec_old.asset_type <> 'GROUP') then
757: select group_asset_id
758: into l_group_asset_id
759: from fa_books
760: where asset_id = p_asset_hdr_rec.asset_id
761: and book_type_code = p_asset_hdr_rec.book_type_code
762: and date_ineffective is null;
763: end if;

Line 1256: fa_books bk,

1252: cursor prior_period_tax_books(l_asset_id in number,
1253: l_book_type_code in varchar2) is
1254: select bc.book_type_code,nvl(bc.allow_backdated_transfers_flag,'Y')
1255: from fa_book_controls bc,
1256: fa_books bk,
1257: fa_deprn_summary ds
1258: where bk.asset_id = l_asset_id
1259: and bk.book_type_code = bc.book_type_code
1260: and bk.date_ineffective is null

Line 1301: update fa_books fabk

1297: l_tax_flag:= 1;--bug fix 2186234
1298: -- if prior period transfer, update books
1299: if (p_trans_rec.transaction_date_entered < p_period_rec.calendar_period_open_date) then
1300:
1301: update fa_books fabk
1302: set adjustment_required_status = 'TFR',
1303: annual_deprn_rounding_flag = 'TFR'
1304: where fabk.asset_id = p_asset_hdr_rec.asset_id
1305: and fabk.book_type_code = p_asset_hdr_rec.book_type_code

Line 1353: update fa_books fabk

1349: if (trx_date_entered < l_tax_cal_period_open_date)
1350: then
1351: l_tax_flag:= 0;
1352:
1353: update fa_books fabk
1354: set
1355: adjustment_required_status = 'NONE',
1356: annual_deprn_rounding_flag = NULL
1357: where fabk.asset_id = p_asset_hdr_rec.asset_id

Line 1385: update fa_books fabk

1381:
1382:
1383: if (p_trans_rec.transaction_date_entered < l_tax_cal_period_open_date) then
1384:
1385: update fa_books fabk
1386: set adjustment_required_status = decode(l_allow_backdated_transfers,'N','NONE','TFR'),
1387: annual_deprn_rounding_flag = decode(l_allow_backdated_transfers,'N',NULL,'TFR')
1388: where fabk.asset_id = p_asset_hdr_rec.asset_id
1389: and fabk.book_type_code = l_tax_book_type_code

Line 1439: from fa_books

1435: BEGIN
1436:
1437: select transaction_header_id_in
1438: into l_Book_Header_Id
1439: from fa_books
1440: where asset_id = p_asset_hdr_rec.asset_id
1441: and book_type_code = p_asset_hdr_rec.book_type_code
1442: and date_ineffective is null;
1443: