APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_CATEGORIES

Line 412: from fa_categories

408: l_cat_segment(4),
409: l_cat_segment(5),
410: l_cat_segment(6),
411: l_cat_segment(7)
412: from fa_categories
413: where category_id = l_mass_add_rec.asset_category_id;
414:
415: l_major_category := l_cat_segment(l_major_cat_seg_index);
416:

Line 459: from fa_categories

455:
456: begin
457: select category_id
458: into l_cat_id
459: from fa_categories
460: where decode(l_cat_segment(1), null,'-1', segment1) =
461: decode(l_cat_segment(1), null, '-1', l_cat_segment(1))
462: and decode(l_cat_segment(2), null, '-1', segment2) =
463: decode(l_cat_segment(2), null, '-1', l_cat_segment(2))