DBA Data[Home] [Help]

APPS.FA_FIN_ADJ1_PKG dependencies on FA_DEPRN_SUMMARY

Line 14: from fa_deprn_summary ds

10: IS
11:
12: cursor deprn_check is
13: select 'Y'
14: from fa_deprn_summary ds
15: where ds.book_type_code = bks_book_type_code and
16: ds.asset_id = bks_asset_id and
17: ds.deprn_source_code = 'DEPRN' and
18: ds.deprn_amount <> 0 and

Line 24: from fa_deprn_summary ds,

20:
21: -- Bug:5172007
22: cursor check_current_period is
23: select 'Y'
24: from fa_deprn_summary ds,
25: fa_deprn_periods dp
26: where dp.book_type_code= bks_book_type_code and
27: ds.asset_id = bks_asset_id and
28: ds.book_type_code= bks_book_type_code and

Line 732: fa_deprn_summary ds

728: cursor adjustment_reqd_flag is
729: select 'Y'
730: from fa_books bk,
731: fa_transaction_headers th,
732: fa_deprn_summary ds
733: where bk.rowid = bks_row_id
734: and bks_depreciate_flag = 'YES'
735: and bk.depreciate_flag = 'NO'
736: and bk.transaction_header_id_in = th.transaction_header_id