APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 437: fa_mc_deprn_summary ds,

433: nvl(ds.ytd_deprn,0) ytd_deprn,
434: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
435: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
436: from fa_mc_books bk,
437: fa_mc_deprn_summary ds,
438: fa_additions_b ad
439: where bk.group_asset_id = h_group_asset_id
440: and bk.book_type_code = h_book_type_code
441: and bk.date_ineffective is null

Line 448: from fa_mc_deprn_summary ds1

444: and ds.book_type_code = h_book_type_code
445: and ds.asset_id = bk.asset_id
446: and ds.period_counter =
447: (select max(ds1.period_counter)
448: from fa_mc_deprn_summary ds1
449: where ds1.book_type_code = h_book_type_code
450: and ds1.asset_id = bk.asset_id
451: and ds1.set_of_books_id = h_set_of_books_id
452: and ds1.period_counter <= h_period_counter - 1)

Line 640: fa_mc_deprn_summary ds,

636: ds.bonus_deprn_reserve,
637: ds.bonus_ytd_deprn
638: from fa_track_members tr,
639: fa_mc_books bk,
640: fa_mc_deprn_summary ds,
641: fa_mc_deprn_periods dp,
642: fa_additions_b ad
643: where tr.group_asset_id = h_group_asset_id
644: and tr.period_counter = h_period_counter

Line 3847: fa_mc_deprn_summary ds,

3843: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3844: temp.eofy_salvage_value temp_eofy_salvage_value,
3845: temp.eop_salvage_value temp_eop_salvage_value
3846: from fa_mc_books bk,
3847: fa_mc_deprn_summary ds,
3848: fa_track_members temp
3849: where bk.book_type_code = h_book_type_code
3850: and bk.group_asset_id = h_group_asset_id
3851: and bk.date_ineffective is null

Line 3858: from fa_mc_deprn_summary ds1

3854: and ds.asset_id = bk.asset_id
3855: -- and ds.period_counter = h_period_counter - 1
3856: and (ds.period_counter =
3857: (select max(ds1.period_counter)
3858: from fa_mc_deprn_summary ds1
3859: where ds1.book_type_code=h_book_type_code
3860: and ds1.asset_id=bk.asset_id
3861: and ds1.set_of_books_id = h_set_of_books_id
3862: and ds1.period_counter <= h_period_counter - 1)

Line 5999: fa_mc_deprn_summary ds,

5995: dp1.fiscal_year
5996: from fa_mc_books bk,
5997: fa_mc_deprn_periods dp,
5998: fa_mc_deprn_periods dp1,
5999: fa_mc_deprn_summary ds,
6000: fa_additions_b ad
6001: where dp.book_type_code = h_book_type_code
6002: and dp.period_counter = h_loop_period_counter
6003: and dp.set_of_books_id = h_set_of_books_id

Line 6020: from fa_mc_deprn_summary ds1

6016: and bk.depreciate_flag = 'YES'
6017: and ds.book_type_code = bk.book_type_code
6018: and ds.period_counter =
6019: (select min(period_counter)
6020: from fa_mc_deprn_summary ds1
6021: where ds1.book_type_code = h_book_type_code
6022: and ds1.asset_id = bk.asset_id
6023: and ds1.period_counter >= h_period_counter - 1)
6024: and ds.set_of_books_id = h_set_of_books_id

Line 6090: fa_mc_deprn_summary ds,

6086: ds.bonus_ytd_deprn,
6087: dp.fiscal_year
6088: from fa_mc_books bk,
6089: fa_mc_deprn_periods dp,
6090: fa_mc_deprn_summary ds,
6091: fa_additions_b ad
6092: where dp.book_type_code = h_book_type_code
6093: and dp.period_counter = h_loop_period_counter
6094: and dp.set_of_books_id = h_set_of_books_id

Line 6103: from fa_mc_deprn_summary ds1

6099: and bk.depreciate_flag = 'YES'
6100: and ds.book_type_code = bk.book_type_code
6101: and ds.period_counter =
6102: (select min(period_counter)
6103: from fa_mc_deprn_summary ds1
6104: where ds1.book_type_code = h_book_type_code
6105: and ds1.asset_id = bk.asset_id
6106: and ds1.period_counter >= h_period_counter - 1)
6107: and ds.set_of_books_id = h_set_of_books_id

Line 6267: from fa_mc_deprn_summary ds

6263:
6264: cursor ADDITION_RESERVE_YTD_MRC is
6265: select ds.deprn_reserve,
6266: ds.ytd_deprn
6267: from fa_mc_deprn_summary ds
6268: where ds.book_type_code=h_book_type_code
6269: and ds.asset_id=h_member_asset_id
6270: and ds.deprn_source_code='BOOKS'
6271: and ds.set_of_books_id=h_set_of_books_id;