DBA Data[Home] [Help]

APPS.IGI_IAC_ADDITIONS_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 293: FROM igi_iac_category_books

289: ) return BOOLEAN IS
290:
291: CURSOR c_allow_indexed_reval_flag IS
292: SELECT allow_indexed_reval_flag
293: FROM igi_iac_category_books
294: WHERE book_type_code = p_book_type_code
295: AND category_id = p_category_id;
296:
297: CURSOR c_period_num_for_catchup IS

Line 330: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;

326:
327: l_dpis_period_counter NUMBER;
328: l_open_period igi_iac_types.prd_rec;
329: l_period_info igi_iac_types.prd_rec;
330: l_allow_indexed_reval_flag igi_iac_category_books.allow_indexed_reval_flag%TYPE;
331: l_period_num_for_catchup igi_iac_book_controls.period_num_for_catchup%TYPE;
332: l_idx1 BINARY_INTEGER DEFAULT 0;
333: l_idx2 BINARY_INTEGER DEFAULT 0;
334: l_reval_control igi_iac_types.iac_reval_control_tab;

Line 374: FROM IGI_IAC_CATEGORY_BOOKS

370: FUNCTION is_iac_cat_book_defined(l_book_type_code VARCHAR2,
371: l_category_id NUMBER) return BOOLEAN IS
372: CURSOR c_cat_book_defined IS
373: SELECT 'X'
374: FROM IGI_IAC_CATEGORY_BOOKS
375: WHERE book_type_code = l_book_type_code
376: AND category_id = l_category_id
377: AND rownum = 1;
378: