APPS.FA_FIN_ADJ1_PKG dependencies on FA_DEPRN_PERIODS

Line 25: fa_deprn_periods dp

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
29: ds.deprn_source_code = 'BOOKS' and

Line 376: fa_deprn_periods dp

372: CURSOR cbachand_part_ret IS
373: SELECT 'Y'
374: FROM fa_transaction_headers th,
375: fa_book_controls bc,
376: fa_deprn_periods dp
377: WHERE th.book_type_code = bks_book_type_code
378: AND th.book_type_code = bc.book_type_code
379: AND bc.book_type_code = dp.book_type_code
380: AND th.transaction_type_code = 'PARTIAL RETIREMENT'