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 373: FROM IGI_IAC_CATEGORY_BOOKS

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