DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG3 dependencies on FA_BOOKS

Line 134: SELECT cost, itc_amount_id FROM FA_BOOKS

130: CURSOR get_ceiling_type IS
131: SELECT ceiling_type FROM FA_CEILING_TYPES
132: WHERE ceiling_name = p_new_ceiling_name;
133: CURSOR get_cost_itc IS
134: SELECT cost, itc_amount_id FROM FA_BOOKS
135: WHERE asset_id = p_asset_id and book_type_code = p_book_type_code
136: AND date_ineffective IS NULL;
137: BEGIN
138: -- Skip validation if rule remains the same or if new ceiling name

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

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