APPS.IGI_IGIIARSV_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 489: FA_DEPRN_DETAIL DD

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

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

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

Line 583: FA_DEPRN_DETAIL DD,

579: 'FA',
580: 1
581: FROM
582: FA_DISTRIBUTION_HISTORY DH,
583: FA_DEPRN_DETAIL DD,
584: FA_ASSET_HISTORY AH,
585: FA_CATEGORY_BOOKS CB,
586: FA_BOOKS BK
587: WHERE

Line 602: FROM FA_DEPRN_DETAIL SUB_DD

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

Line 939: FA_DEPRN_DETAIL DD,

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