APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_BOOK_CONTROLS

Line 171: from fa_book_controls_bas bc

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

Line 576: from fa_book_controls

572: h_mass_req_id,
573: h_sob_id,
574: h_mc_source_flag,
575: h_allow_cip_assets
576: from fa_book_controls
577: where book_type_code = X_book;
578:
579: if (nvl(h_last_period_ctr, -99) <>
580: nvl(FA_CACHE_PKG.fazcbc_record.last_period_counter, -99) OR

Line 1129: from fa_book_controls bc

1125: h_cursor varchar2(6);
1126:
1127: cursor tax_cursor is
1128: select bc.book_type_code
1129: from fa_book_controls bc
1130: where bc.distribution_source_book = X_book
1131: and bc.book_class = 'TAX'
1132: and bc.date_ineffective is null;
1133:

Line 1381: from fa_book_controls

1377: end if;
1378: else
1379: select mass_request_id
1380: into h_mass_id
1381: from fa_book_controls
1382: where book_type_code = X_book
1383: for update of mass_request_id
1384: NOWAIT;
1385: end if;

Line 1513: fa_book_controls bc

1509:
1510: CURSOR check_deprn_run IS
1511: SELECT nvl(deprn_run, 'N')
1512: FROM fa_deprn_periods dp,
1513: fa_book_controls bc
1514: WHERE bc.book_type_code = X_book
1515: AND dp.book_type_code = bc.book_type_code
1516: AND dp.period_close_date is null;
1517:

Line 1586: fa_book_controls bc

1582: elsif (G_release = 11) then
1583: SELECT count(*)
1584: INTO h_count
1585: FROM fa_deprn_summary ds,
1586: fa_book_controls bc
1587: WHERE bc.book_type_code = X_book
1588: AND ds.book_type_code = bc.book_type_code
1589: AND ds.period_counter = bc.last_period_counter + 1
1590: AND ds.asset_id = X_asset_id

Line 1606: fa_book_controls bc

1602: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
1603: SELECT count(*)
1604: INTO h_count
1605: FROM fa_mc_deprn_summary ds,
1606: fa_book_controls bc
1607: WHERE bc.book_type_code = X_book
1608: AND ds.book_type_code = bc.book_type_code
1609: AND ds.period_counter = bc.last_period_counter + 1
1610: AND ds.asset_id = X_asset_id

Line 1628: fa_book_controls bc,

1624: -- done in the same period .
1625: SELECT count(*)
1626: INTO h_count
1627: FROM fa_adjustments adj,
1628: fa_book_controls bc,
1629: fa_deprn_summary ds
1630: WHERE bc.book_type_code = X_book
1631: AND adj.book_type_code = X_book
1632: AND adj.period_counter_created = bc.last_period_counter + 1

Line 1684: fa_book_controls bc

1680: else -- release <> 11
1681: SELECT count(*)
1682: INTO h_count
1683: FROM fa_deprn_summary ds,
1684: fa_book_controls bc
1685: WHERE bc.book_type_code = X_book
1686: AND ds.book_type_code = bc.book_type_code
1687: AND ds.period_counter = bc.last_period_counter + 1
1688: AND ds.asset_id = X_asset_id

Line 1703: fa_book_controls bc,

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

Line 1733: fa_book_controls bc

1729: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
1730: SELECT count(*)
1731: INTO h_count
1732: FROM fa_mc_deprn_summary ds,
1733: fa_book_controls bc
1734: WHERE bc.book_type_code = X_book
1735: AND ds.book_type_code = bc.book_type_code
1736: AND ds.period_counter = bc.last_period_counter + 1
1737: AND ds.asset_id = X_asset_id