APPS.FA_MASSADD_PKG dependencies on FA_CATEGORIES

Line 2013: l_new_desc_category fa_categories.description%TYPE;

2009: mprec c_fy_add%ROWTYPE;
2010:
2011: l_new_dpis date;
2012: l_new_desc_year varchar2(4);
2013: l_new_desc_category fa_categories.description%TYPE;
2014: l_new_start_date date;
2015: l_new_end_date date;
2016:
2017: l_mp_found boolean;

Line 2170: fa_categories cat

2166: l_new_start_date,
2167: l_new_end_date
2168: From fa_fiscal_year fy,
2169: fa_book_controls bc,
2170: fa_categories cat
2171: Where px_date_placed_in_service_tbl(i) between fy.start_date and fy.end_date
2172: And fy.fiscal_year_name = bc.fiscal_year_name
2173: And bc.book_type_code = p_book_type_code
2174: And cat.category_id = p_asset_category_id_tbl(i);