APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_DET_BALANCES

Line 641: igi_iac_det_balances id ,

637: FROM fa_additions ad ,
638: fa_Books bk ,
639: fa_distribution_history dh,
640: fa_deprn_Detail dd ,
641: igi_iac_det_balances id ,
642: igi_iac_fa_deprn ifd,
643: gl_code_combinations cc,
644: fa_categories cf,
645: fa_asset_history ah

Line 807: FROM igi_iac_det_balances dd,

803: CURSOR c_iac_non_deprn(n_asset_id fa_books.asset_id%TYPE,
804: n_book_code fa_books.book_type_code%TYPE)
805: IS
806: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0)
807: FROM igi_iac_det_balances dd,
808: fa_books fb
809: WHERE dd.book_type_code = fb.book_type_code
810: AND dd.asset_id = fb.asset_id
811: AND dd.book_type_code = n_book_code

Line 828: FROM igi_iac_det_balances dd,

824: IS
825: SELECT NVL(SUM(NVL(dd.adjustment_cost,0)),0) adjustment_cost,
826: NVL(sum(nvl(dd.Deprn_Period, 0)),0) deprn_period,
827: NVL(sum(nvl(dd.Deprn_YTD+ifd.deprn_ytd, 0)),0) deprn_ytd
828: FROM igi_iac_det_balances dd,
829: igi_iac_fa_deprn ifd,
830: fa_books fb
831: WHERE dd.book_type_code = fb.book_type_code
832: AND dd.asset_id = fb.asset_id