DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 1605: FROM fa_mc_deprn_summary ds,

1601:
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

Line 1656: fa_mc_deprn_summary ds

1652: SELECT count(*)
1653: INTO h_count
1654: FROM fa_mc_adjustments adj,
1655: fa_mc_book_controls bc,
1656: fa_mc_deprn_summary ds
1657: WHERE bc.book_type_code = X_book
1658: AND bc.enabled_flag = 'Y'
1659: AND adj.set_of_books_id = adj.set_of_books_id
1660: AND adj.book_type_code = X_book

Line 1732: FROM fa_mc_deprn_summary ds,

1728:
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