DBA Data[Home] [Help]

APPS.IGIRX_IMP_IAC_REP dependencies on FA_DEPRN_DETAIL

Line 559: FROM fa_deprn_detail

555: p_period_counter in number,
556: p_book_type_code in varchar2)
557: IS
558: SELECT ytd_deprn
559: FROM fa_deprn_detail
560: WHERE distribution_id=p_distribution_id AND
561: book_type_code =p_book_type_code AND
562: asset_id =p_asset_id AND
563: period_counter=p_period_counter ;

Line 570: FROM fa_deprn_detail

566: p_asset_id in number,
567: p_book_type_code in varchar2)
568: IS
569: SELECT ytd_deprn
570: FROM fa_deprn_detail
571: WHERE distribution_id=p_distribution_id AND
572: book_type_code =p_book_type_code AND
573: asset_id =p_asset_id AND
574: period_counter=(select max(period_counter)

Line 575: from fa_deprn_detail

571: WHERE distribution_id=p_distribution_id AND
572: book_type_code =p_book_type_code AND
573: asset_id =p_asset_id AND
574: period_counter=(select max(period_counter)
575: from fa_deprn_detail
576: where asset_id=p_asset_id
577: and distribution_id=p_distribution_id
578: and book_type_code =p_book_type_code);
579: