APPS.IGI_IGIIABLD_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 676: IGI_IAC_CATEGORY_BOOKS ICB,

672: FA_DISTRIBUTION_HISTORY DH,
673: IGI_IAC_DET_BALANCES DD,
674: FA_ASSET_HISTORY AH,
675: FA_CATEGORY_BOOKS CB,
676: IGI_IAC_CATEGORY_BOOKS ICB,
677: FA_BOOKS BK,
678: IGI_IAC_TRANSACTION_HEADERS ITH
679: WHERE
680: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 798: IGI_IAC_CATEGORY_BOOKS ICB,

794: FA_DISTRIBUTION_HISTORY DH,
795: IGI_IAC_DET_BALANCES DD,
796: FA_ASSET_HISTORY AH,
797: FA_CATEGORY_BOOKS CB,
798: IGI_IAC_CATEGORY_BOOKS ICB,
799: FA_BOOKS BK,
800: IGI_IAC_TRANSACTION_HEADERS ITH
801: WHERE
802: DH.Book_Type_Code = p_Distribution_Source_Book AND

Line 875: igi_iac_category_books icb

871: FROM
872: igi_iac_det_balances db,
873: fa_distribution_history dh,
874: fa_asset_history ah,
875: igi_iac_category_books icb
876: WHERE
877: dh.book_type_code = p_book AND
878: nvl(dh.date_ineffective, p_earliest_date-1) > p_earliest_date AND
879: dh.asset_id = ah.asset_id AND

Line 1104: cp_category_id igi_iac_category_books.category_id%TYPE,

1100:
1101: /* Cursor to fetch the revaluation reserve account for the book
1102: and the category */
1103: CURSOR c_get_account(cp_book fa_books.book_type_code%TYPE,
1104: cp_category_id igi_iac_category_books.category_id%TYPE,
1105: cp_report_type varchar2) IS
1106: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1107: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid
1108: FROM igi_iac_category_books

Line 1108: FROM igi_iac_category_books

1104: cp_category_id igi_iac_category_books.category_id%TYPE,
1105: cp_report_type varchar2) IS
1106: SELECT DECODE(cp_report_type,'REVAL RESERVE', reval_rsv_ccid,
1107: 'OP EXPENSE', operating_expense_ccid) adjustment_ccid
1108: FROM igi_iac_category_books
1109: WHERE book_type_code = cp_book
1110: AND category_id = cp_category_id;
1111:
1112: /* Cursor to fetch the distribution ccid for a distribution */