816:
817: CURSOR C_ytd_dist(p_distribution_id in NUMBER)
818: IS
819: SELECT ytd_deprn
820: FROM fa_deprn_detail
821: WHERE
822: distribution_id=p_distribution_id AND
823: book_type_code =p_book_type_code AND
824: asset_id =p_asset_id AND
823: book_type_code =p_book_type_code AND
824: asset_id =p_asset_id AND
825: -- Bug 3575041 start (1) --
826: period_counter=(select max(period_counter)
827: from fa_deprn_detail
828: where distribution_id = p_distribution_id
829: and book_type_code = p_book_type_code
830: and asset_id = p_asset_id ) ;
831: