APPS.IGI_IGIIACSD_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 657: IGI_IAC_CATEGORY_BOOKS ICB,

653: FA_DISTRIBUTION_HISTORY DH,
654: IGI_IAC_DET_BALANCES DD,
655: FA_ASSET_HISTORY AH,
656: FA_CATEGORY_BOOKS CB,
657: IGI_IAC_CATEGORY_BOOKS ICB,
658: FA_BOOKS BK,
659: IGI_IAC_TRANSACTION_HEADERS ITH
660: WHERE
661: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 779: IGI_IAC_CATEGORY_BOOKS ICB,

775: FA_DISTRIBUTION_HISTORY DH,
776: IGI_IAC_DET_BALANCES DD,
777: FA_ASSET_HISTORY AH,
778: FA_CATEGORY_BOOKS CB,
779: IGI_IAC_CATEGORY_BOOKS ICB,
780: FA_BOOKS BK,
781: IGI_IAC_TRANSACTION_HEADERS ITH
782: WHERE
783: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 856: igi_iac_category_books icb

852: FROM
853: igi_iac_det_balances db,
854: fa_distribution_history dh,
855: fa_asset_history ah,
856: igi_iac_category_books icb
857: WHERE
858: dh.book_type_code = p_book AND
859: nvl(dh.date_ineffective, p_earliest_date-1) > p_earliest_date AND
860: dh.asset_id = ah.asset_id AND

Line 1085: cp_category_id igi_iac_category_books.category_id%TYPE,

1081:
1082: /* Cursor to fetch the revaluation reserve account for the book
1083: and the category */
1084: CURSOR c_get_account(cp_book fa_books.book_type_code%TYPE,
1085: cp_category_id igi_iac_category_books.category_id%TYPE,
1086: cp_report_type varchar2) IS
1087: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1088: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid
1089: FROM igi_iac_category_books

Line 1089: FROM igi_iac_category_books

1085: cp_category_id igi_iac_category_books.category_id%TYPE,
1086: cp_report_type varchar2) IS
1087: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1088: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid
1089: FROM igi_iac_category_books
1090: WHERE book_type_code = cp_book
1091: AND category_id = cp_category_id;
1092:
1093: /* Cursor to fetch the distribution ccid for a distribution */