APPS.FA_FIN_ADJ1_PKG dependencies on FA_METHODS

Line 388: from fa_flat_rates fr, fa_methods mth

384: sysdate);
385:
386: cursor check_rate is
387: select 'Y'
388: from fa_flat_rates fr, fa_methods mth
389: where mth.method_code = bks_deprn_method_code
390: and mth.life_in_months is null
391: and mth.method_id = fr.method_id
392: and fr.basic_rate = bks_basic_rate

Line 397: from fa_methods mth

393: and fr.adjusted_rate = bks_adjusted_rate;
394:
395: cursor check_life is
396: select 'Y'
397: from fa_methods mth
398: where mth.method_code = bks_deprn_method_code
399: and bks_life_years * 12 + bks_life_months = mth.life_in_months;
400:
401: cursor check_deprn_flag is

Line 403: from fa_formulas f, fa_methods mth

399: and bks_life_years * 12 + bks_life_months = mth.life_in_months;
400:
401: cursor check_deprn_flag is
402: select 'Y'
403: from fa_formulas f, fa_methods mth
404: where mth.method_code = bks_deprn_method_code
405: and mth.method_id = f.method_id (+)
406: and ((mth.rate_source_rule = 'PRODUCTION') or
407: ((mth.rate_source_rule = 'FORMULA') and

Line 515: FROM fa_formulas f, fa_methods m

511: elsif bks_rate_source_rule = 'FORMULA' then
512:
513: SELECT f.formula_actual
514: INTO h_formula_actual
515: FROM fa_formulas f, fa_methods m
516: WHERE m.method_id = f.method_id
517: AND m.method_code = bks_deprn_method_code
518: AND rownum = 1
519: ORDER BY m.method_id;