DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on IGI_IAC_CATEGORY_BOOKS

Line 877: from igi_iac_category_books

873: where asset_id = X_asset_id;
874:
875: Cursor prc_idx(p_cat number) is
876: select price_index_id
877: from igi_iac_category_books
878: where book_type_code = X_book_type_code
879: and category_id = p_cat;
880:
881: Cursor idx_nam(p_prc_idx number) is

Line 924: from igi_iac_category_books

920: where asset_id = X_asset_id;
921:
922: Cursor cal_price_idx_id(p_cat number ) is
923: select cal_price_index_link_id
924: from igi_iac_category_books
925: where category_id = p_cat
926: and book_type_code = X_book_type_code;
927:
928: p_dep_cal varchar2(15);

Line 1410: FROM igi_iac_category_books

1406: nvl(GENERAL_FUND_CCID,-1),
1407: nvl(OPERATING_EXPENSE_CCID,-1),
1408: nvl(REVAL_RSV_CCID,-1),
1409: nvl(REVAL_RSV_RET_CCID,-1)
1410: FROM igi_iac_category_books
1411: WHERE book_type_code = X_book_type_code
1412: AND category_id = p_asset_category_id;
1413:
1414: CURSOR get_reval_rsv_ccid (p_asset_category_id number) is