APPS.FA_INS_DETAIL_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 175: FROM fa_mc_deprn_detail

171: if (X_mrc_sob_type_code ='R') then
172:
173: SELECT sum(nvl(deprn_adjustment_amount,0))
174: INTO h_deprn_adjustment_amount
175: FROM fa_mc_deprn_detail
176: WHERE book_type_code = X_book_type_code
177: AND asset_id = X_asset_id
178: AND deprn_source_code = 'B'
179: AND set_of_books_id = X_set_of_books_id;

Line 486: FROM FA_MC_DEPRN_DETAIL

482: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
483: IF X_mrc_sob_type_code = 'R' THEN
484: SELECT COUNT(*)
485: INTO h_count
486: FROM FA_MC_DEPRN_DETAIL
487: WHERE book_type_code = h_book_type_code AND
488: asset_id = h_asset_id AND
489: period_counter = h_period_counter;
490: ELSE

Line 559: DELETE FROM fa_mc_deprn_detail

555:
556: h_msg_name := NULL;
557:
558: if X_mrc_sob_type_code = 'R' then
559: DELETE FROM fa_mc_deprn_detail
560: WHERE book_type_code = h_book_type_code AND
561: asset_id = h_asset_id AND
562: period_counter = h_period_counter AND
563: set_of_books_id = X_set_of_books_id;

Line 609: FROM fa_mc_deprn_detail

605: /*Bug#8421266 - Modified query to fetch ytd_deprn of transferred out distribution.*/
606: if (X_mrc_sob_type_code = 'R') then
607: SELECT ytd_deprn
608: INTO h_part_ytd
609: FROM fa_mc_deprn_detail
610: WHERE book_type_code = h_book_type_code
611: and asset_id = h_asset_id
612: and distribution_id = h_dist_id
613: and period_counter = (select max(period_counter)

Line 614: from fa_mc_deprn_detail fdd2

610: WHERE book_type_code = h_book_type_code
611: and asset_id = h_asset_id
612: and distribution_id = h_dist_id
613: and period_counter = (select max(period_counter)
614: from fa_mc_deprn_detail fdd2
615: where fdd2.asset_id = h_asset_id
616: and fdd2.distribution_id = h_dist_id
617: and fdd2.set_of_books_id = X_set_of_books_id
618: and fdd2.book_type_code = h_book_type_code)

Line 652: INSERT INTO fa_mc_deprn_detail

648: /*Bug#8421266 - Insert row in deprn table only when transferred out in current period.*/
649: if h_pc_counter = h_period_counter then
650: if (X_mrc_sob_type_code = 'R') then
651:
652: INSERT INTO fa_mc_deprn_detail
653: (SET_OF_BOOKS_ID,
654: BOOK_TYPE_CODE,
655: ASSET_ID,
656: DISTRIBUTION_ID,

Line 1068: INSERT INTO fa_mc_deprn_detail

1064: h_cost_to_clear := h_part_cost;
1065: end if;
1066:
1067: if (X_mrc_sob_type_code = 'R') then
1068: INSERT INTO fa_mc_deprn_detail
1069: (SET_OF_BOOKS_ID,
1070: BOOK_TYPE_CODE,
1071: ASSET_ID,
1072: DISTRIBUTION_ID,