APPS.IGI_IGIIACSD_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 473: FA_DEPRN_DETAIL DD

469: FROM
470: FA_DISTRIBUTION_HISTORY DH,
471: FA_CATEGORY_BOOKS CB,
472: FA_ASSET_HISTORY AH,
473: FA_DEPRN_DETAIL DD
474: WHERE
475: NOT EXISTS (SELECT ASSET_ID
476: FROM IGI_IAC_BALANCES_REPORT
477: WHERE ASSET_ID = DH.ASSET_ID

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

539: Source_Type_Code,
540: Amount,
541: Data_source,
542: Display_order)
543: SELECT /*+ index(dd FA_DEPRN_DETAIL_U1) */
544: DH.Asset_ID,
545: DH.Code_Combination_ID,
546: null,
547: DECODE (p_Report_Type,

Line 567: FA_DEPRN_DETAIL DD,

563: 'FA',
564: 1
565: FROM
566: FA_DISTRIBUTION_HISTORY DH,
567: FA_DEPRN_DETAIL DD,
568: FA_ASSET_HISTORY AH,
569: FA_CATEGORY_BOOKS CB,
570: FA_BOOKS BK
571: WHERE

Line 586: FROM FA_DEPRN_DETAIL SUB_DD

582: 'BEGIN', DD.Deprn_Source_Code, 'D') =
583: DD.Deprn_Source_Code AND
584: DD.Period_Counter =
585: (SELECT MAX (SUB_DD.Period_Counter)
586: FROM FA_DEPRN_DETAIL SUB_DD
587: WHERE SUB_DD.Book_Type_Code = p_Book AND
588: SUB_DD.Distribution_ID = DH.Distribution_ID AND
589: DH.Distribution_ID = DD.Distribution_ID AND
590: SUB_DD.Period_Counter <= p_Period_PC) AND

Line 923: FA_DEPRN_DETAIL DD,

919: FROM
920: FA_CATEGORY_BOOKS CB,
921: FA_DISTRIBUTION_HISTORY DH,
922: FA_ASSET_HISTORY AH,
923: FA_DEPRN_DETAIL DD,
924: FA_DEPRN_PERIODS DP
925: WHERE
926: DH.Book_Type_Code = p_Distribution_Source_Book AND
927: AH.Asset_ID = DH.Asset_ID AND