APPS.IGI_IGIIAOPE_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 659: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 781: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 858: igi_iac_category_books icb

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

Line 1087: cp_category_id igi_iac_category_books.category_id%TYPE,

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

Line 1091: FROM igi_iac_category_books

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