APPS.FA_TRANSFER_PVT dependencies on FA_DEPRN_DETAIL

Line 555: -- Get information from FA_DEPRN_DETAIL for the Distribution requested

551: raise error_found;
552: end if;
553:
554:
555: -- Get information from FA_DEPRN_DETAIL for the Distribution requested
556:
557: begin
558: if (mrc_sob_type_code = 'R') then
559:

Line 568: FROM fa_deprn_detail_mrc_v dd

564: INTO dd_deprn_exp,
565: dd_reval_deprn_exp,
566: dd_reval_amo,
567: dd_bonus_deprn_exp
568: FROM fa_deprn_detail_mrc_v dd
569: WHERE dd.book_type_code = p_asset_hdr_rec.book_type_code
570: AND dd.asset_id = p_asset_hdr_rec.asset_id
571: AND dd.distribution_id = p_asset_dist_rec.distribution_id
572: AND dd.period_counter between

Line 583: FROM fa_deprn_detail dd

579: INTO dd_deprn_exp,
580: dd_reval_deprn_exp,
581: dd_reval_amo,
582: dd_bonus_deprn_exp
583: FROM fa_deprn_detail dd
584: WHERE dd.book_type_code = p_asset_hdr_rec.book_type_code
585: AND dd.asset_id = p_asset_hdr_rec.asset_id
586: AND dd.distribution_id = p_asset_dist_rec.distribution_id
587: AND dd.period_counter between

Line 1558: | Inserts a row into fa_deprn_detail for each row in the Adjustments |

1554: | fadpaa |
1555: | |
1556: | FA Depreciation Process Adjustments Array |
1557: | |
1558: | Inserts a row into fa_deprn_detail for each row in the Adjustments |
1559: | array; then inserts one row into fa_deprn_summary for |
1560: | sum of values in array |
1561: | |
1562: | NOTES |

Line 1573: | fa_deprn_detail table. |

1569: | |
1570: | FUNCTION |
1571: | Calculates adjusted depreciation for a specified asset_id and |
1572: | book_type and stores the distributed depreciation amounts in the |
1573: | fa_deprn_detail table. |
1574: | Returns the total amount of adjusted depreciation on the asset. |
1575: | |
1576: | NOTES |
1577: | This routine was rewritten to handle prior period transfers. Now |