APPS.FA_MASSADD_PKG dependencies on FA_CATEGORIES

Line 1920: l_new_desc_category fa_categories.description%TYPE;

1916: mprec c_fy_add%ROWTYPE;
1917:
1918: l_new_dpis date;
1919: l_new_desc_year varchar2(4);
1920: l_new_desc_category fa_categories.description%TYPE;
1921: l_new_start_date date;
1922: l_new_end_date date;
1923:
1924: l_mp_found boolean;

Line 2097: fa_categories cat

2093: l_new_start_date,
2094: l_new_end_date
2095: From fa_fiscal_year fy,
2096: fa_book_controls bc,
2097: fa_categories cat
2098: Where px_date_placed_in_service_tbl(i) between fy.start_date and fy.end_date
2099: And fy.fiscal_year_name = bc.fiscal_year_name
2100: And bc.book_type_code = p_book_type_code
2101: And cat.category_id = p_asset_category_id_tbl(i);