DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_DEPRN_SUMMARY

Line 1585: FROM fa_deprn_summary ds,

1581: end if;
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

Line 1629: fa_deprn_summary ds

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
1633: AND adj.asset_id = X_asset_id

Line 1683: FROM fa_deprn_summary ds,

1679: end if;
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

Line 1702: FROM fa_deprn_summary ds,

1698: into h_count
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