APPS.IGI_IAC_WEBADI_PKG dependencies on FA_BOOK_CONTROLS

Line 116: From fa_calendar_types ct, fa_book_controls bc, fa_books bk

112: l_life_in_months number;
113: Begin
114: Select ct.calendar_type, ct.number_per_fiscal_year, bk.life_in_months
115: Into l_calendar_type, l_number_per_fiscal_year, l_life_in_months
116: From fa_calendar_types ct, fa_book_controls bc, fa_books bk
117: Where ct.calendar_type = bc.deprn_calendar
118: and bk.book_type_code = p_book_type_code
119: and bk.date_ineffective is null
120: and bk.asset_id = p_asset_id

Line 457: From fa_book_controls

453:
454: Cursor C_Last_Closed_Period(
455: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
456: Select last_period_counter
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;

Line 701: From fa_book_controls fa, gl_sets_of_books gl

697:
698: Cursor C_Book_Defaults(
699: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
700: Select fa.last_period_counter, gl.currency_code
701: From fa_book_controls fa, gl_sets_of_books gl
702: Where book_type_code = cp_book_type_code
703: and gl.set_of_books_id = fa.set_of_books_id;
704:
705: Cursor C_Asset_Details(

Line 1195: From fa_book_controls

1191:
1192: Cursor C_Last_Closed_Period(
1193: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
1194: Select last_period_counter
1195: From fa_book_controls
1196: Where book_type_code = cp_book_type_code;
1197:
1198: -- bug 3443410, start 1
1199: CURSOR c_preview_exists(cp_book_type_code igi_iac_upload_headers.book_type_code%TYPE)