APPS.IGI_IGIIARRD_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 488: FA_DEPRN_DETAIL DD

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

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

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

Line 582: FA_DEPRN_DETAIL DD,

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

Line 601: FROM FA_DEPRN_DETAIL SUB_DD

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

Line 938: FA_DEPRN_DETAIL DD,

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