APPS.FA_CAPITALIZE_CIP_PKG1 dependencies on FA_METHODS

Line 18: FROM FA_METHODS

14: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
15: )IS
16: CURSOR RATE_DEF IS
17: SELECT DISTINCT RATE_SOURCE_RULE
18: FROM FA_METHODS
19: WHERE METHOD_CODE = h_deprn_method;
20:
21: h_rate_source_rule varchar2(10);
22:

Line 37: h_method_name fa_methods.name%type;

33:
34: h_cat_bk_lim number;
35: h_min_life_in_months number;
36: h_sub_life_rule varchar2(13);
37: h_method_name fa_methods.name%type;
38:
39: CURSOR LIFE1_DEF IS
40: select nvl(life_in_months,0), nvl(life_in_months,0),
41: prorate_date

Line 246: from fa_methods

242: if (h_rate_source_rule NOT IN ('FLAT', 'PRODUCTION')) then
243:
244: select name
245: into h_method_name
246: from fa_methods
247: where method_code = h_deprn_method
248: and life_in_months = h_parent_life ;
249:
250: end if;

Line 309: from fa_methods

305: rate_source_rule,
306: deprn_basis_rule,
307: stl_method_flag,
308: exclude_salvage_value_flag
309: from fa_methods
310: where method_code = p_deprn_method
311: and nvl(life_in_months,0) = p_lim;
312:
313: CURSOR CHECK_METHOD_EXISTS IS

Line 315: from fa_methods

311: and nvl(life_in_months,0) = p_lim;
312:
313: CURSOR CHECK_METHOD_EXISTS IS
314: select method_code, life_in_months
315: from fa_methods
316: where method_code = h_deprn_method
317: and nvl(life_in_months,0) = h_lim;
318:
319: -- bug 1147151

Line 322: from fa_methods

318:
319: -- bug 1147151
320: CURSOR methodname IS
321: select name
322: from fa_methods
323: where method_code = h_deprn_method
324: order by created_by desc;
325:
326: CURSOR C_FORMULA (p_method_id number) IS

Line 340: h_methodname fa_methods.name%type;

336: h_deprn_basis_rule varchar2(4);
337: h_rowid rowid;
338: h_dummy1 varchar2(12);
339: h_dummy2 number(4);
340: h_methodname fa_methods.name%type;
341:
342: h_method_id_old number;
343: h_stl_method_flag varchar2(3);
344: h_exclude_sal_flag varchar2(3);

Line 371: select FA_METHODS_S.NEXTVAL

367: end if;
368:
369: else /* if not 'TABLE' */
370:
371: select FA_METHODS_S.NEXTVAL
372: into h_method_id
373: from sys.dual;
374:
375: -- need to derive more values to distinguish between

Line 406: FA_METHODS_PKG.Insert_Row(

402: else
403: CLOSE MD_DEF;
404: end if;
405:
406: FA_METHODS_PKG.Insert_Row(
407: X_Rowid => h_rowid,
408: X_Method_Id => h_method_id,
409: X_Method_Code => h_deprn_method,
410: X_Life_In_Months => h_lim,