APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FND_FLEX_VALUE_SETS

Line 134: fnd_flex_value_sets val_set,

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
138: AND cat1.category_id = l_category_id

Line 623: fnd_flex_value_sets val_set

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
627: AND val_norm.child_flex_value_high;

Line 766: fnd_flex_value_sets val_set,

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
770: AND val_set.flex_value_set_name = l_value_set_name

Line 799: fnd_flex_value_sets val_set

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 =
803: l_value_set_name