APPS.GCS_ICM_INTG_PROF_PKG dependencies on FND_FLEX_VALUE_SETS

Line 108: FROM fnd_flex_value_sets

104: END IF;
105:
106: SELECT to_char(flex_value_set_id)
107: INTO l_vs_id
108: FROM fnd_flex_value_sets
109: WHERE flex_value_set_name = 'FCH_ICM_ENTITY_VALUE_SET';
110:
111: set_single_option_value('AMW_FIN_IMPORT_FROM_FSG', 'N', 'Y');
112: set_single_option_value('AMW_SUBSIDIARY_AUDIT_UNIT', l_vs_id, 'N');

Line 147: FROM fnd_flex_value_sets ffv

143: l_request_id NUMBER;
144:
145: CURSOR amw_value_set_c IS
146: SELECT flex_value_set_name
147: FROM fnd_flex_value_sets ffv
148: WHERE ffv.flex_value_set_id = to_number(fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT'));
149:
150: l_vs_name VARCHAR2(100);
151: BEGIN