APPS.IGI_IGIIABLS_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 678: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 800: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 877: igi_iac_category_books icb

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

Line 1106: cp_category_id igi_iac_category_books.category_id%TYPE,

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

Line 1110: FROM igi_iac_category_books

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