APPS.IGI_IGIIARRD_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 486: FA_CATEGORY_BOOKS CB,

482: 'FA',
483: 1
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

Line 584: FA_CATEGORY_BOOKS CB,

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
587: DH.Book_Type_Code = p_Distribution_Source_Book AND
588: DECODE(DD.Deprn_Source_Code, 'D', P_Period_Date,

Line 671: FA_CATEGORY_BOOKS CB,

667: FROM
668: FA_DISTRIBUTION_HISTORY DH,
669: IGI_IAC_DET_BALANCES DD,
670: FA_ASSET_HISTORY AH,
671: FA_CATEGORY_BOOKS CB,
672: IGI_IAC_CATEGORY_BOOKS ICB,
673: FA_BOOKS BK,
674: IGI_IAC_TRANSACTION_HEADERS ITH
675: WHERE

Line 793: FA_CATEGORY_BOOKS CB,

789: FROM
790: FA_DISTRIBUTION_HISTORY DH,
791: IGI_IAC_DET_BALANCES DD,
792: FA_ASSET_HISTORY AH,
793: FA_CATEGORY_BOOKS CB,
794: IGI_IAC_CATEGORY_BOOKS ICB,
795: FA_BOOKS BK,
796: IGI_IAC_TRANSACTION_HEADERS ITH
797: WHERE

Line 935: FA_CATEGORY_BOOKS CB,

931: 'REVAL RESERVE', -DD.Reval_Amortization)),
932: 'FA',
933: 1
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