APPS.IGI_IGIIACST_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 494: FA_DEPRN_DETAIL DD

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

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

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

Line 588: FA_DEPRN_DETAIL DD,

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

Line 607: FROM FA_DEPRN_DETAIL SUB_DD

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

Line 944: FA_DEPRN_DETAIL DD,

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