APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 133: FND_FLEX_VALUE_NORM_HIERARCHY val_norm,

129: ad.asset_key_ccid
130: FROM fa_additions ad,
131: fa_categories cat,
132: fa_categories cat1,
133: FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
134: fnd_flex_value_sets val_set,
135: fa_asset_keywords ak
136: WHERE ad.ASSET_CATEGORY_ID = cat.CATEGORY_ID
137: AND cat.SEGMENT2 = l_cat_value

Line 622: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,

618: l_here_key_seg_val := l_akey_segment (l_here_key_seg_index);
619:
620: SELECT DISTINCT val_norm.parent_flex_value
621: INTO l_group_akey_segment1
622: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
623: fnd_flex_value_sets val_set
624: WHERE val_norm.flex_value_set_id = val_set.flex_value_set_id
625: AND val_set.flex_value_set_name = l_value_set_name
626: AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low

Line 765: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,

761:
762:
763: SELECT DISTINCT ak.code_combination_id
764: INTO l_akey_ccid
765: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
766: fnd_flex_value_sets val_set,
767: fa_asset_keywords ak
768: WHERE val_norm.flex_value_set_id =
769: val_set.flex_value_set_id

Line 798: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,

794: l_debug_str := 'Get the Asset Key';
795:
796: SELECT DISTINCT val_norm.parent_flex_value
797: INTO l_group_akey_segment1
798: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
799: fnd_flex_value_sets val_set
800: WHERE val_norm.flex_value_set_id =
801: val_set.flex_value_set_id
802: AND val_set.flex_value_set_name =