APPS.FARX_C_WD dependencies on FA_METHODS

Line 441: from fa_methods

437:
438:
439: h_count := 0;
440: select count(*) into h_count
441: from fa_methods
442: where method_code = argument11 and rownum < 2;
443:
444: if h_count = 0 then
445: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');

Line 465: select count(*) into h_count from fa_methods

461: h_value_error := argument12;
462: h_param_error := 'LIFE';
463:
464: h_count := 0;
465: select count(*) into h_count from fa_methods
466: where method_code = argument11
467: and rate_source_rule in ('TABLE','CALCULATED','FORMULA')
468: and rownum < 2;
469:

Line 483: select count(*) into h_count from fa_methods

479: return;
480: end if;
481:
482: h_count := 0;
483: select count(*) into h_count from fa_methods
484: where method_code = argument11 and life_in_months = to_number(argument12)
485: and rownum < 2;
486:
487: if h_count = 0 then

Line 515: select count(*) into h_count from fa_methods m

511: h_param_error := 'RATE';
512:
513:
514: h_count := 0;
515: select count(*) into h_count from fa_methods m
516: where m.method_code = argument11
517: and m.rate_source_rule = 'FLAT' and rownum < 2;
518:
519: if h_count > 0 then -- this is a rate-based method

Line 533: select count(*) into h_count from fa_methods m, fa_flat_rates r

529:
530: h_adj_rate := to_number(argument13) / 100;
531:
532: h_count := 0;
533: select count(*) into h_count from fa_methods m, fa_flat_rates r
534: where m.method_code = argument11
535: and m.method_id = r.method_id
536: and r.adjusted_rate = h_adj_rate and rownum < 2;
537: