APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_BOOKS

Line 1344: FROM fa_books

1340: -- snarayan
1341: CURSOR lock_asset IS
1342: SELECT transaction_header_id_out,
1343: adjustment_required_status
1344: FROM fa_books
1345: WHERE book_type_code = X_book
1346: AND asset_id = X_asset_id
1347: AND transaction_header_id_out is null
1348: FOR UPDATE OF

Line 1355: FROM fa_books

1351:
1352: CURSOR lock_asset_mass IS
1353: SELECT transaction_header_id_out,
1354: adjustment_required_status
1355: FROM fa_books
1356: WHERE book_type_code = X_book
1357: AND asset_id = X_asset_id
1358: AND transaction_header_id_out is null
1359: FOR UPDATE OF

Line 1376: -- For individual asset transaction only lock the active FA_BOOKS row

1372: end if;
1373:
1374: -- ******************************************************************
1375: -- Lock Book Controls row only if a Mass Request is submitted.
1376: -- For individual asset transaction only lock the active FA_BOOKS row
1377: -- For ADDITION not necessary to lock row. ADDITION should be allowed
1378: -- as long as depreciation or no mass request is running on the book
1379: -- Fix for Bug 1067205 - snarayan
1380: -- ******************************************************************

Line 1659: fa_books bks,

1655: where exists
1656: (select 'x'
1657: FROM fa_deprn_summary ds,
1658: fa_book_controls bc,
1659: fa_books bks,
1660: fa_additions_b ad
1661: WHERE bc.book_type_code = X_Book
1662: AND ds.book_type_code = bc.book_type_code
1663: AND ds.period_counter = bc.last_period_counter + 1