APPS.IGI_IGIIAOPE_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 475: FA_DEPRN_DETAIL DD

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

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

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

Line 569: FA_DEPRN_DETAIL DD,

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

Line 588: FROM FA_DEPRN_DETAIL SUB_DD

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

Line 925: FA_DEPRN_DETAIL DD,

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