APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on FA_DEPRN_SUMMARY

Line 837: FROM fa_deprn_summary

833:
834: CURSOR C_ytd_asset(p_max_period_counter in number)
835: IS
836: SELECT ytd_deprn
837: FROM fa_deprn_summary
838: WHERE asset_id=p_asset_id AND
839: book_type_code=p_book_type_code AND
840: period_counter=p_max_period_counter-1;
841:

Line 1893: from fa_deprn_summary fds

1889: and bk.transaction_header_id_out is null;
1890:
1891: cursor C_get_deprn_details(cp_book in varchar2, cp_asset_id in number)is
1892: Select period_counter,deprn_reserve
1893: from fa_deprn_summary fds
1894: where book_type_code =cp_book
1895: and asset_id = cp_asset_id
1896: and period_counter = ( select max(period_counter)
1897: from fa_deprn_summary

Line 1897: from fa_deprn_summary

1893: from fa_deprn_summary fds
1894: where book_type_code =cp_book
1895: and asset_id = cp_asset_id
1896: and period_counter = ( select max(period_counter)
1897: from fa_deprn_summary
1898: where book_type_code =fds.book_type_code
1899: and asset_id = fds.asset_id);
1900:
1901: --l_errbuf VARCHAR2(1200) ;