APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 1266: fa_deprn_periods_mrc_v dp

1262: 'DR',adj.adjustment_amount,
1263: 'CR',-adj.adjustment_amount))),0) current_period_expense
1264: from fa_adjustments_mrc_v adj,
1265: fa_transaction_headers th,
1266: fa_deprn_periods_mrc_v dp
1267: where adj.asset_id = px_rule_in.asset_id
1268: and adj.book_type_code = px_rule_in.book_type_code
1269: and dp.book_type_code = px_rule_in.book_type_code
1270: and adj.transaction_header_id = th.transaction_header_id

Line 1628: FA_DEPRN_PERIODS_MRC_V DP,

1624: Cursor C_EOFY_RESERVE_RETIRED_M is
1625: select nvl(sum(RET.EOFY_RESERVE),0)
1626: from FA_RETIREMENTS_MRC_V RET,
1627: FA_TRANSACTION_HEADERS TH,
1628: FA_DEPRN_PERIODS_MRC_V DP,
1629: FA_FISCAL_YEAR FY,
1630: FA_BOOK_CONTROLS_MRC_V BC
1631: where RET.ASSET_ID= px_rule_in.asset_id
1632: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1674: FA_DEPRN_PERIODS_MRC_V DP,

1670: Cursor GP_EOFY_RESERVE_RETIRED_M is
1671: select nvl(sum(RET.EOFY_RESERVE),0)
1672: from FA_RETIREMENTS_MRC_V RET,
1673: FA_TRANSACTION_HEADERS TH,
1674: FA_DEPRN_PERIODS_MRC_V DP,
1675: FA_FISCAL_YEAR FY,
1676: FA_BOOK_CONTROLS_MRC_V BC
1677: where TH.ASSET_ID= px_rule_in.asset_id
1678: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code