APPS.IGIRX_IAC_PROJ dependencies on FA_CATEGORIES

Line 57: fa_categories fc

53: dp.deprn_ytd,
54: substr(dp.asset_exception,1,30) exception_code
55: FROM igi_iac_proj_details dp,
56: fa_additions fad,
57: fa_categories fc
58: WHERE dp.projection_id = n_proj_id
59: AND fad.asset_id = dp.asset_id
60: AND dp.category_id = fc.category_id
61: ORDER BY dp.asset_id, dp.period_counter;

Line 287: ' FROM fa_categories cat

283: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Minor category segment: '||l_min_cat);
284:
285: IF (l_min_cat IS NOT NULL) THEN
286: l_sql := 'SELECT ' ||l_min_cat||
287: ' FROM fa_categories cat
288: WHERE cat.category_id = :1';
289: /* Bug 3448431 */
290: execute immediate l_sql into l_rxi_proj_rec.minor_category(l_count) USING l_proj_data.category_id;
291: ELSE