DBA Data[Home] [Help]

APPS.IGI_IAC_PROJ_PKG dependencies on FA_DEPRN_DETAIL

Line 640: fa_deprn_Detail dd ,

636: 'IAC' source_type
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,

Line 690: fa_deprn_Detail dd,

686: 'FA' source_type
687: FROM fa_additions ad,
688: fa_Books bk,
689: fa_distribution_history dh,
690: fa_deprn_Detail dd,
691: gl_code_combinations cc,
692: fa_categories cf,
693: fa_asset_history ah
694: WHERE ad.asset_id = bk.asset_id

Line 734: fa_deprn_Detail dd,

730: 'NONDEPFA' source_type
731: FROM fa_additions ad,
732: fa_Books bk,
733: fa_distribution_history dh,
734: fa_deprn_Detail dd,
735: gl_code_combinations cc,
736: fa_categories cf,
737: fa_asset_history ah
738: WHERE ad.asset_id = bk.asset_id

Line 753: FROM fa_deprn_detail

749: AND dh.asset_id = ah.asset_id
750: AND nvl(dh.date_ineffective,sysdate+1) > ah.date_effective
751: AND nvl(dh.date_ineffective,sysdate+1) <= nvl(ah.date_ineffective,sysdate+1)
752: AND dd.period_counter = (SELECT max(period_counter)
753: FROM fa_deprn_detail
754: WHERE book_type_code = n_book_type_code
755: AND asset_id = n_asset_id)
756: AND bk.depreciate_flag = 'NO'
757: GROUP BY ad.asset_id,

Line 773: fa_deprn_Detail dd,

769: 'FULLRSVDFA' source_type
770: FROM fa_additions ad,
771: fa_Books bk,
772: fa_distribution_history dh,
773: fa_deprn_Detail dd,
774: gl_code_combinations cc,
775: fa_categories cf,
776: fa_asset_history ah
777: WHERE ad.asset_id = bk.asset_id