DBA Data[Home] [Help]

APPS.FA_FAS443_XMLP_PKG dependencies on FA_FISCAL_YEAR

Line 184: h_fy_name fa_fiscal_year.fiscal_year_name%type;

180: ret boolean;
181: before_1962 boolean := true;
182: no_errors boolean := true;
183: h_calendar_type varchar2(30);
184: h_fy_name fa_fiscal_year.fiscal_year_name%type;
185: h_prorate_fy number;
186: h_cur_per_num number;
187: h_num_per_fy number;
188: h_cur_fy number;

Line 218: l_fiscal_year_name fa_fiscal_year.fiscal_year_name%type;

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
220: select period_num, cp.start_date, fiscal_year_name
221: from fa_calendar_periods cp,
222: fa_book_controls bc

Line 427: from fa_fiscal_year

423: fetch c_end into dpr_in.p_cl_begin, l_start_date, l_fiscal_year_name;
424: close c_end;
425: select fiscal_year
426: into dpr_in.y_begin
427: from fa_fiscal_year
428: where fiscal_year_name = l_fiscal_year_name
429: and l_start_date between start_date and end_date;
430: if l_date_retired > to_date('19611231','YYYYMMDD') then
431: dpr_in.y_end := 1961;