APPS.GCS_ICM_INTG_PROF_PKG dependencies on FND_PROFILE

Line 31: FROM fnd_profile_options

27: SELECT application_id,
28: profile_option_id
29: INTO l_application_id,
30: l_profile_option_id
31: FROM fnd_profile_options
32: WHERE profile_option_name = p_option_name;
33:
34: MERGE INTO fnd_profile_option_values pov
35: USING (SELECT 1 FROM DUAL) src

Line 34: MERGE INTO fnd_profile_option_values pov

30: l_profile_option_id
31: FROM fnd_profile_options
32: WHERE profile_option_name = p_option_name;
33:
34: MERGE INTO fnd_profile_option_values pov
35: USING (SELECT 1 FROM DUAL) src
36: ON (pov.application_id = l_application_id AND
37: pov.profile_option_id = l_profile_option_id AND
38: pov.level_id = 10001)

Line 148: WHERE ffv.flex_value_set_id = to_number(fnd_profile.value('AMW_SUBSIDIARY_AUDIT_UNIT'));

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
152: OPEN amw_value_set_c;