DBA Data[Home] [Help]

APPS.FA_FAS443_XMLP_PKG dependencies on FA_METHODS

Line 211: l_method_code fa_methods.method_code%TYPE;

207: l_date_retired_year number;
208: previous_y_end number;
209: previous_p_cl_end number;
210: previous_end_date date;
211: l_method_code fa_methods.method_code%TYPE;
212: l_rate_source_rule fa_methods.rate_source_rule%TYPE;
213: cursor c_rsr is
214: select rate_source_rule
215: from fa_methods

Line 212: l_rate_source_rule fa_methods.rate_source_rule%TYPE;

208: previous_y_end number;
209: previous_p_cl_end number;
210: previous_end_date date;
211: l_method_code fa_methods.method_code%TYPE;
212: l_rate_source_rule fa_methods.rate_source_rule%TYPE;
213: cursor c_rsr is
214: select rate_source_rule
215: from fa_methods
216: where method_code = l_method_code;

Line 215: from fa_methods

211: l_method_code fa_methods.method_code%TYPE;
212: l_rate_source_rule fa_methods.rate_source_rule%TYPE;
213: cursor c_rsr is
214: select rate_source_rule
215: from fa_methods
216: where method_code = l_method_code;
217: l_start_date date;
218: l_fiscal_year_name fa_fiscal_year.fiscal_year_name%type;
219: cursor c_end is

Line 271: fa_methods mt,

267: ret.date_retired,
268: to_number(to_char(ret.date_retired,'YYYY')),
269: th.transaction_type_code
270: FROM fa_ceiling_types ceilt,
271: fa_methods mt,
272: fa_category_books cb,
273: fa_books bk,
274: fa_retirements ret,
275: fa_transaction_headers th,