APPS.FA_REC_PVT_PKG3 dependencies on FA_BOOK_CONTROLS

Line 122: FROM FA_BOOK_CONTROLS

118: l_itc_amount_id NUMBER(15);
119: l_new_ceiling_type VARCHAR2(30);
120: CURSOR get_book_info IS
121: SELECT book_class, allow_cost_ceiling, allow_deprn_exp_ceiling
122: FROM FA_BOOK_CONTROLS
123: WHERE book_type_code = p_book_type_code;
124: CURSOR get_ceiling_type IS
125: SELECT ceiling_type FROM FA_CEILING_TYPES
126: WHERE ceiling_name = p_new_ceiling_name;

Line 303: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc

299: WHERE conv.prorate_convention_code = p_new_conv
300: AND p_date_placed_in_service between conv.start_date and conv.end_date;
301: CURSOR check_prorate_date IS
302: SELECT 'x'
303: FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc
304: WHERE bc.book_type_code = p_book_type_code
305: AND bc.prorate_calendar = cp.calendar_type
306: AND l_prorate_date between cp.start_date and cp.end_date;
307: BEGIN

Line 391: FA_BOOK_CONTROLS bc, FA_BOOKS bk

387: AND l_new_rate_src_rule = 'PRODUCTION';
388: CURSOR check_tax_book_method IS
389: SELECT 'x'
390: FROM FA_METHODS mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
391: FA_BOOK_CONTROLS bc, FA_BOOKS bk
392: WHERE bc.distribution_source_book = p_book_type_code
393: AND bc.book_class = 'TAX'
394: AND bk.book_type_code = bc.book_type_code
395: AND bk.asset_id = p_asset_id

Line 407: FA_BOOK_CONTROLS bc, FA_BOOKS bk

403: AND l_new_rate_src_rule <> 'PRODUCTION';
404: CURSOR check_corp_book_method IS
405: SELECT 'x'
406: FROM FA_METHODS corp_mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
407: FA_BOOK_CONTROLS bc, FA_BOOKS bk
408: WHERE bc.book_type_code = p_book_type_code
409: AND bk.book_type_code = bc.distribution_source_book
410: AND bk.asset_id = p_asset_id
411: AND bk.date_ineffective IS NULL

Line 430: SELECT book_class FROM FA_BOOK_CONTROLS

426: FROM FA_BOOKS
427: WHERE asset_id = p_asset_id AND book_type_code = p_book_type_code
428: AND date_ineffective IS NULL;
429: CURSOR get_book_class IS
430: SELECT book_class FROM FA_BOOK_CONTROLS
431: WHERE book_type_code = p_book_type_code;
432: /* cursor to validate depreciation method change for a
433: short-tax-year asset */
434: CURSOR check_short_tax IS