APPS.FA_ASSET_VAL_PVT dependencies on FA_BOOK_CONTROLS

Line 772: from fa_book_controls bc

768: from fa_books bks
769: where exists
770: (
771: select 'X'
772: from fa_book_controls bc
773: where bc.book_type_code = p_book_type_code
774: and bc.distribution_source_book = bks.book_type_code
775: )
776: and bks.asset_id = p_asset_id;

Line 1147: fa_book_controls bc

1143: begin
1144: select 'x'
1145: into l_check_prorate_date
1146: from fa_calendar_periods cp,
1147: fa_book_controls bc
1148: where bc.book_type_code = p_book_type_code
1149: and bc.prorate_calendar = cp.calendar_type
1150: and l_prorate_date between cp.start_date and cp.end_date;
1151:

Line 1276: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;

1272: p_calling_fn IN VARCHAR2,
1273: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1274: ) return boolean IS
1275:
1276: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1277: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1278:
1279: l_same_fiscal_year NUMBER;
1280: l_abs_deprn_reserve NUMBER;

Line 1277: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;

1273: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1274: ) return boolean IS
1275:
1276: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1277: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1278:
1279: l_same_fiscal_year NUMBER;
1280: l_abs_deprn_reserve NUMBER;
1281: l_abs_ytd_deprn NUMBER;

Line 2812: fa_book_controls bc,

2808:
2809: -- Validate warranty currency is correct
2810: SELECT count(w.warranty_id) INTO l_count
2811: FROM gl_sets_of_books glsob,
2812: fa_book_controls bc,
2813: fa_warranties w
2814: WHERE w.warranty_id = p_warranty_id
2815: AND bc.book_type_code = p_book_type_code
2816: AND bc.set_of_books_id = glsob.set_of_books_id

Line 2845: fa_book_controls bc,

2841: where asset_id = p_asset_id );
2842: CURSOR C1 IS
2843: select currency_code
2844: from gl_sets_of_books sob,
2845: fa_book_controls bc,
2846: fa_books bk
2847: where bk.asset_id = p_asset_id
2848: and bk.date_ineffective is null
2849: and bk.book_type_code = bc.book_type_code