APPS.FA_REC_PVT_PKG3 dependencies on FA_METHODS

Line 223: FROM FA_METHODS mth

219: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
220: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
221: CURSOR chk_deprn_flag IS
222: SELECT 'N'
223: FROM FA_METHODS mth
224: WHERE mth.method_code = p_old_rules.deprn_method
225: AND mth.rate_source_rule = 'PRODUCTION';
226: check_flag VARCHAR2(3);
227: BEGIN

Line 400: FROM FA_METHODS mth

396: l_count NUMBER := 0;
397: check_flag VARCHAR2(3);
398: CURSOR check_method IS
399: SELECT 'N'
400: FROM FA_METHODS mth
401: WHERE l_depreciation_check = 'Y'
402: AND p_old_deprn_method = mth.method_code
403: AND mth.rate_source_rule <> 'PRODUCTION'
404: AND l_new_rate_src_rule = 'PRODUCTION';

Line 407: FROM FA_METHODS mth, FA_CATEGORY_BOOK_DEFAULTS cbd,

403: AND mth.rate_source_rule <> 'PRODUCTION'
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

Line 423: FROM FA_METHODS corp_mth, FA_CATEGORY_BOOK_DEFAULTS cbd,

419: AND mth.rate_source_rule = 'PRODUCTION'
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

Line 438: FROM FA_METHODS

434: AND corp_mth.rate_source_rule <> 'PRODUCTION'
435: AND l_new_rate_src_rule = 'PRODUCTION';
436: CURSOR get_rate_deprn_rules IS
437: SELECT rate_source_rule, deprn_basis_rule
438: FROM FA_METHODS
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

Line 453: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth

449: /* cursor to validate depreciation method change for a
450: short-tax-year asset */
451: CURSOR check_short_tax IS
452: SELECT 'N'
453: FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth
454: WHERE mth.method_code = p_old_deprn_method
455: AND mth.rate_source_rule = 'FORMULA'
456: AND ds.asset_id = p_asset_id
457: AND ds.book_type_code = p_book_type_code

Line 617: FROM FA_FLAT_RATES fr, FA_METHODS mth

613: check_flag VARCHAR2(3);
614: l_rate_src_rule VARCHAR2(10);
615: CURSOR check_rate IS
616: SELECT 'Y'
617: FROM FA_FLAT_RATES fr, FA_METHODS mth
618: WHERE mth.method_code = p_deprn_method
619: AND mth.life_in_months IS NULL
620: AND mth.method_id = fr.method_id
621: AND fr.basic_rate = p_basic_rate

Line 625: FROM FA_METHODS mth

621: AND fr.basic_rate = p_basic_rate
622: AND fr.adjusted_rate = p_adjusted_rate;
623: CURSOR check_life IS
624: SELECT 'Y'
625: FROM FA_METHODS mth
626: WHERE mth.method_code = p_deprn_method
627: AND nvl(mth.life_in_months, 99999) = p_life_in_months;
628: CURSOR get_rate_src_rule IS
629: SELECT rate_source_rule FROM FA_METHODS

Line 629: SELECT rate_source_rule FROM FA_METHODS

625: FROM FA_METHODS mth
626: WHERE mth.method_code = p_deprn_method
627: AND nvl(mth.life_in_months, 99999) = p_life_in_months;
628: CURSOR get_rate_src_rule IS
629: SELECT rate_source_rule FROM FA_METHODS
630: WHERE method_code = p_deprn_method;
631: BEGIN
632: -- Small validation unit. Just validate without checking whehter
633: -- change exists or not.