APPS.FA_REC_PVT_PKG3 dependencies on FA_BOOK_CONTROLS

Line 128: FROM FA_BOOK_CONTROLS

124: l_itc_amount_id NUMBER(15);
125: l_new_ceiling_type VARCHAR2(30);
126: CURSOR get_book_info IS
127: SELECT book_class, allow_cost_ceiling, allow_deprn_exp_ceiling
128: FROM FA_BOOK_CONTROLS
129: WHERE book_type_code = p_book_type_code;
130: CURSOR get_ceiling_type IS
131: SELECT ceiling_type FROM FA_CEILING_TYPES
132: WHERE ceiling_name = p_new_ceiling_name;

Line 317: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc

313: WHERE conv.prorate_convention_code = p_new_conv
314: AND p_date_placed_in_service between conv.start_date and conv.end_date;
315: CURSOR check_prorate_date IS
316: SELECT 'x'
317: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc
318: WHERE bc.book_type_code = p_book_type_code
319: AND bc.prorate_calendar = cp.calendar_type
320: AND l_prorate_date between cp.start_date and cp.end_date;
321: BEGIN

Line 408: FA_BOOK_CONTROLS bc, FA_BOOKS bk

404: AND l_new_rate_src_rule = 'PRODUCTION';
405: CURSOR check_tax_book_method IS
406: SELECT 'x'
407: FROM FA_METHODS mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
408: FA_BOOK_CONTROLS bc, FA_BOOKS bk
409: WHERE bc.distribution_source_book = p_book_type_code
410: AND bc.book_class = 'TAX'
411: AND bk.book_type_code = bc.book_type_code
412: AND bk.asset_id = p_asset_id

Line 424: FA_BOOK_CONTROLS bc, FA_BOOKS bk

420: AND l_new_rate_src_rule <> 'PRODUCTION';
421: CURSOR check_corp_book_method IS
422: SELECT 'x'
423: FROM FA_METHODS corp_mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
424: FA_BOOK_CONTROLS bc, FA_BOOKS bk
425: WHERE bc.book_type_code = p_book_type_code
426: AND bk.book_type_code = bc.distribution_source_book
427: AND bk.asset_id = p_asset_id
428: AND bk.date_ineffective IS NULL

Line 447: SELECT book_class FROM FA_BOOK_CONTROLS

443: FROM FA_BOOKS
444: WHERE asset_id = p_asset_id AND book_type_code = p_book_type_code
445: AND date_ineffective IS NULL;
446: CURSOR get_book_class IS
447: SELECT book_class FROM FA_BOOK_CONTROLS
448: WHERE book_type_code = p_book_type_code;
449: /* cursor to validate depreciation method change for a
450: short-tax-year asset */
451: CURSOR check_short_tax IS