APPS.IGI_IGIIABLD_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 492: FA_DEPRN_DETAIL DD

488: FROM
489: FA_DISTRIBUTION_HISTORY DH,
490: FA_CATEGORY_BOOKS CB,
491: FA_ASSET_HISTORY AH,
492: FA_DEPRN_DETAIL DD
493: WHERE
494: NOT EXISTS (SELECT ASSET_ID
495: FROM IGI_IAC_BALANCES_REPORT
496: WHERE ASSET_ID = DH.ASSET_ID

Line 562: SELECT /*+ index(dd FA_DEPRN_DETAIL_U1) */

558: Source_Type_Code,
559: Amount,
560: Data_source,
561: Display_order)
562: SELECT /*+ index(dd FA_DEPRN_DETAIL_U1) */
563: DH.Asset_ID,
564: DH.Code_Combination_ID,
565: null,
566: DECODE (p_Report_Type,

Line 586: FA_DEPRN_DETAIL DD,

582: 'FA',
583: 1
584: FROM
585: FA_DISTRIBUTION_HISTORY DH,
586: FA_DEPRN_DETAIL DD,
587: FA_ASSET_HISTORY AH,
588: FA_CATEGORY_BOOKS CB,
589: FA_BOOKS BK
590: WHERE

Line 605: FROM FA_DEPRN_DETAIL SUB_DD

601: 'BEGIN', DD.Deprn_Source_Code, 'D') =
602: DD.Deprn_Source_Code AND
603: DD.Period_Counter =
604: (SELECT MAX (SUB_DD.Period_Counter)
605: FROM FA_DEPRN_DETAIL SUB_DD
606: WHERE SUB_DD.Book_Type_Code = p_Book AND
607: SUB_DD.Distribution_ID = DH.Distribution_ID AND
608: DH.Distribution_ID = DD.Distribution_ID AND
609: SUB_DD.Period_Counter <= p_Period_PC) AND

Line 942: FA_DEPRN_DETAIL DD,

938: FROM
939: FA_CATEGORY_BOOKS CB,
940: FA_DISTRIBUTION_HISTORY DH,
941: FA_ASSET_HISTORY AH,
942: FA_DEPRN_DETAIL DD,
943: FA_DEPRN_PERIODS DP
944: WHERE
945: DH.Book_Type_Code = p_Distribution_Source_Book AND
946: AH.Asset_ID = DH.Asset_ID AND