APPS.IGI_IGIIARSV_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 673: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 795: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 872: igi_iac_category_books icb

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

Line 1101: cp_category_id igi_iac_category_books.category_id%TYPE,

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

Line 1105: FROM igi_iac_category_books

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