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 813: fa_deprn_periods dp

809: fa_additions_b ad,
810: fa_book_controls bc,
811: fa_category_books cb,
812: fa_deprn_summary ds,
813: fa_deprn_periods dp
814: where th.rowid between p_start_rowid and p_end_rowid
815: and bc.book_type_code = th.book_type_code
816: and nvl(bc.date_ineffective, sysdate + 1) > sysdate
817: and bc.book_type_code = cb.book_type_code

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_asset_invoices ai,
1758: fa_invoice_transactions it,
1759: (select 'SOURCE' source_dest_code from dual union all

Line 1795: fa_deprn_periods dp,

1791: adj.debit_credit_flag,
1792: adj.code_combination_id
1793: from fa_transaction_headers th,
1794: fa_book_controls bc,
1795: fa_deprn_periods dp,
1796: fa_adjustments adj,
1797: fa_distribution_history dh,
1798: (select 'SOURCE' source_dest_code from dual union all
1799: select 'DEST' source_dest_code from dual) mult