APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_BOOKS

Line 1304: FROM fa_books

1300: -- snarayan
1301: CURSOR lock_asset IS
1302: SELECT transaction_header_id_out,
1303: adjustment_required_status
1304: FROM fa_books
1305: WHERE book_type_code = X_book
1306: AND asset_id = X_asset_id
1307: AND transaction_header_id_out is null
1308: FOR UPDATE OF

Line 1315: FROM fa_books

1311:
1312: CURSOR lock_asset_mass IS
1313: SELECT transaction_header_id_out,
1314: adjustment_required_status
1315: FROM fa_books
1316: WHERE book_type_code = X_book
1317: AND asset_id = X_asset_id
1318: AND transaction_header_id_out is null
1319: FOR UPDATE OF

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

1331: end if;
1332:
1333: -- ******************************************************************
1334: -- Lock Book Controls row only if a Mass Request is submitted.
1335: -- For individual asset transaction only lock the active FA_BOOKS row
1336: -- For ADDITION not necessary to lock row. ADDITION should be allowed
1337: -- as long as depreciation or no mass request is running on the book
1338: -- Fix for Bug 1067205 - snarayan
1339: -- ******************************************************************

Line 1704: fa_books bks,

1700: where exists
1701: (select 'x'
1702: FROM fa_deprn_summary ds,
1703: fa_book_controls bc,
1704: fa_books bks,
1705: fa_books bks2,
1706: fa_additions_b ad
1707: WHERE bc.book_type_code = X_Book
1708: AND ds.book_type_code = bc.book_type_code

Line 1705: fa_books bks2,

1701: (select 'x'
1702: FROM fa_deprn_summary ds,
1703: fa_book_controls bc,
1704: fa_books bks,
1705: fa_books bks2,
1706: fa_additions_b ad
1707: WHERE bc.book_type_code = X_Book
1708: AND ds.book_type_code = bc.book_type_code
1709: AND ds.period_counter = bc.last_period_counter + 1