APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_BOOK_CONTROLS

Line 175: from fa_book_controls_bas bc

171:
172: -- used when called from a reporting book
173: CURSOR check_primary_sync IS
174: select count(1)
175: from fa_book_controls_bas bc
176: where bc.book_type_code = X_book
177: and (bc.last_period_counter <> h_last_period_counter or
178: bc.mass_request_id is not null);
179:

Line 593: from fa_book_controls

589: h_mass_req_id,
590: h_sob_id,
591: h_mc_source_flag,
592: h_allow_cip_assets
593: from fa_book_controls
594: where book_type_code = X_book;
595:
596: if (nvl(h_last_period_ctr, -99) <>
597: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR

Line 1161: from fa_book_controls bc

1157: h_cursor varchar2(6);
1158:
1159: cursor tax_cursor is
1160: select bc.book_type_code
1161: from fa_book_controls bc
1162: where bc.distribution_source_book = X_book
1163: and bc.book_class = 'TAX'
1164: and bc.date_ineffective is null;
1165:

Line 1422: from fa_book_controls

1418: end if;
1419: else
1420: select mass_request_id
1421: into h_mass_id
1422: from fa_book_controls
1423: where book_type_code = X_book
1424: for update of mass_request_id
1425: NOWAIT;
1426: end if;

Line 1560: fa_book_controls bc

1556:
1557: CURSOR check_deprn_run IS
1558: SELECT nvl(deprn_run, 'N')
1559: FROM fa_deprn_periods dp,
1560: fa_book_controls bc
1561: WHERE bc.book_type_code = X_book
1562: AND dp.book_type_code = bc.book_type_code
1563: AND dp.period_close_date is null;
1564:

Line 1639: fa_book_controls bc

1635:
1636: SELECT count(*)
1637: INTO h_count
1638: FROM fa_deprn_summary ds,
1639: fa_book_controls bc
1640: WHERE bc.book_type_code = X_book
1641: AND ds.book_type_code = bc.book_type_code
1642: AND ds.period_counter = bc.last_period_counter + 1
1643: AND ds.asset_id = X_asset_id

Line 1658: fa_book_controls bc,

1654: from dual
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

Line 1691: fa_book_controls bc

1687: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
1688: SELECT count(*)
1689: INTO h_count
1690: FROM fa_mc_deprn_summary ds,
1691: fa_book_controls bc
1692: WHERE bc.book_type_code = X_book
1693: AND ds.book_type_code = bc.book_type_code
1694: AND ds.period_counter = bc.last_period_counter + 1
1695: AND ds.asset_id = X_asset_id