APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_CATEGORY_BOOKS

Line 444: From igi_iac_category_books

440: Cursor C_Valid_Iac_Cat(
441: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
442: cp_category_id in igi_iac_upload_lines.category_id%type) Is
443: Select allow_prof_reval_flag
444: From igi_iac_category_books
445: Where book_type_code = cp_book_type_code
446: and category_id = cp_category_id;
447:
448: Cursor C_Max_Period_counter(

Line 461: l_allow_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%type;

457: From fa_book_controls
458: Where book_type_code = cp_book_type_code;
459:
460: l_asset_cnt number;
461: l_allow_prof_reval_flag igi_iac_category_books.allow_prof_reval_flag%type;
462: l_max_period_counter number;
463: l_last_closed_period number;
464: l_get_period_rec igi_iac_types.prd_rec;
465: Begin