APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_DEPRN_PERIODS

Line 36: fa_deprn_periods dp,

32: ad.asset_type ,
33: ad.current_units ,
34: bc.set_of_books_id
35: from fa_transaction_headers th,
36: fa_deprn_periods dp,
37: fa_books bk,
38: fa_category_books cb,
39: fa_additions_b ad,
40: fa_book_controls bc

Line 796: fa_deprn_periods dp

792: fa_additions_b ad,
793: fa_book_controls bc,
794: fa_category_books cb,
795: fa_deprn_summary ds,
796: fa_deprn_periods dp
797: where th.rowid between p_start_rowid and p_end_rowid
798: and bc.book_type_code = th.book_type_code
799: and nvl(bc.date_ineffective, sysdate) <= sysdate
800: and bc.book_type_code = cb.book_type_code

Line 1715: fa_deprn_periods dp,

1711: adj.debit_credit_flag,
1712: adj.code_combination_id
1713: from fa_transaction_headers th,
1714: fa_book_controls bc,
1715: fa_deprn_periods dp,
1716: fa_adjustments adj,
1717: fa_asset_invoices ai,
1718: fa_invoice_transactions it,
1719: (select 'SOURCE' source_dest_code from dual union all

Line 1755: fa_deprn_periods dp,

1751: adj.debit_credit_flag,
1752: adj.code_combination_id
1753: from fa_transaction_headers th,
1754: fa_book_controls bc,
1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_distribution_history dh,
1758: (select 'SOURCE' source_dest_code from dual union all
1759: select 'DEST' source_dest_code from dual) mult