APPS.IGI_IGIIARRD_XMLP_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 672: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 794: IGI_IAC_CATEGORY_BOOKS ICB,

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

Line 871: igi_iac_category_books icb

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

Line 1100: cp_category_id igi_iac_category_books.category_id%TYPE,

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

Line 1104: FROM igi_iac_category_books

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