DBA Data[Home] [Help]

APPS.FA_TRACK_MEMBER_PVT dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 7112: from fa_deprn_summary_mrc_v

7108: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
7109: select deprn_source_code,
7110: ytd_deprn,
7111: deprn_reserve
7112: from fa_deprn_summary_mrc_v
7113: where book_type_code = h_book_type_code
7114: and asset_id = p_asset_id
7115: and period_counter = p_period_counter;
7116:

Line 8604: from fa_deprn_summary_mrc_v

8600: cursor GET_RESERVE_AT_ADDITION_MRC(p_asset_id number, p_period_counter number) is
8601: select deprn_source_code,
8602: ytd_deprn,
8603: deprn_reserve
8604: from fa_deprn_summary_mrc_v
8605: where book_type_code = h_book_type_code
8606: and asset_id = p_asset_id
8607: and period_counter = p_period_counter;
8608:

Line 10357: from fa_deprn_summary_mrc_v ds1,

10353: and period_counter <= h_period_counter);
10354:
10355: cursor MEM_EXP_RESERVE_MRC is
10356: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10357: from fa_deprn_summary_mrc_v ds1,
10358: fa_deprn_periods_mrc_v dp1
10359: where ds1.book_type_code = h_book_type_code
10360: and ds1.asset_id = h_member_asset_id
10361: and dp1.book_type_code = ds1.book_type_Code