DBA Data[Home] [Help]

APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_FA_DEPRN

Line 642: igi_iac_fa_deprn ifd,

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
646: WHERE ad.asset_id = dh.asset_id

Line 829: igi_iac_fa_deprn ifd,

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
833: AND dd.distribution_id = ifd.distribution_id