DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_MC_DEPRN_PERIODS

Line 1446: fa_mc_deprn_periods dp

1442: 'DR',adj.adjustment_amount,
1443: 'CR',-adj.adjustment_amount))),0) current_period_expense
1444: from fa_mc_adjustments adj,
1445: fa_transaction_headers th,
1446: fa_mc_deprn_periods dp
1447: where adj.asset_id = px_rule_in.asset_id
1448: and adj.book_type_code = px_rule_in.book_type_code
1449: and dp.book_type_code = px_rule_in.book_type_code
1450: and adj.transaction_header_id = th.transaction_header_id

Line 1800: FA_MC_DEPRN_PERIODS DP,

1796: Cursor C_EOFY_RESERVE_RETIRED_M is
1797: select nvl(sum(RET.EOFY_RESERVE),0)
1798: from FA_MC_RETIREMENTS RET,
1799: FA_TRANSACTION_HEADERS TH,
1800: FA_MC_DEPRN_PERIODS DP,
1801: FA_FISCAL_YEAR FY,
1802: FA_MC_BOOK_CONTROLS MBC,
1803: FA_BOOK_CONTROLS BC
1804: where RET.ASSET_ID= px_rule_in.asset_id

Line 1851: FA_MC_DEPRN_PERIODS DP,

1847: Cursor GP_EOFY_RESERVE_RETIRED_M is
1848: select nvl(sum(RET.EOFY_RESERVE),0)
1849: from FA_MC_RETIREMENTS RET,
1850: FA_TRANSACTION_HEADERS TH,
1851: FA_MC_DEPRN_PERIODS DP,
1852: FA_FISCAL_YEAR FY,
1853: FA_MC_BOOK_CONTROLS MBC,
1854: FA_BOOK_CONTROLS BC
1855: where TH.ASSET_ID= px_rule_in.asset_id