APPS.FA_REC_PVT_PKG3 dependencies on FA_BOOKS

Line 128: SELECT cost, itc_amount_id FROM FA_BOOKS

124: CURSOR get_ceiling_type IS
125: SELECT ceiling_type FROM FA_CEILING_TYPES
126: WHERE ceiling_name = p_new_ceiling_name;
127: CURSOR get_cost_itc IS
128: SELECT cost, itc_amount_id FROM FA_BOOKS
129: WHERE asset_id = p_asset_id and book_type_code = p_book_type_code
130: AND date_ineffective IS NULL;
131: BEGIN
132: -- Skip validation if rule remains the same or if new ceiling name

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 426: FROM FA_BOOKS

422: WHERE method_code = p_new_deprn_method;
423: /* cursor to get a book row for an asset */
424: CURSOR get_book_info IS
425: SELECT itc_amount_id, conversion_date
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