APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_ASSET_KEYWORDS

Line 384: FROM fa_asset_keywords

380: l_akey_segment(7),
381: l_akey_segment(8),
382: l_akey_segment(9),
383: l_akey_segment(10)
384: FROM fa_asset_keywords
385: WHERE code_combination_id = l_akey_ccid;
386:
387: l_here_key_seg_val := l_akey_segment(l_here_key_seg_index);
388:

Line 422: from fa_asset_keywords

418: l_akey_segment(l_akey_grp_seg_index) := l_akey_grp_seg_val;
419: begin
420: select code_combination_id
421: into l_akey_ccid
422: from fa_asset_keywords
423: where decode(l_akey_segment(1), null, '-1', segment1) =
424: decode(l_akey_segment(1), null, '-1', l_akey_segment(1))
425: and decode(l_akey_segment(2), null, '-1', segment2) =
426: decode(l_akey_segment(2), null, '-1', l_akey_segment(2))