APPS.GME_TRANSFORM_BATCH dependencies on FND_PROFILE_OPTIONS

Line 77: FROM fnd_profile_options fpo,

73: FUNCTION get_profile_value (v_profile_name IN VARCHAR2, v_appl_id IN NUMBER)
74: RETURN VARCHAR2 IS
75: CURSOR c_get_profile_value(c_profile_name IN VARCHAR2, c_appl_id IN NUMBER) IS
76: SELECT fpov.profile_option_value
77: FROM fnd_profile_options fpo,
78: fnd_profile_option_values fpov
79: WHERE fpo.application_id = c_appl_id
80: AND fpo.profile_option_name = c_profile_name
81: AND fpo.profile_option_id = fpov.profile_option_id

Line 90: bug 13086505:As the profiles below have been disabled in the fnd_profile_options table,

86:
87: l_profile_value NUMBER;
88: BEGIN
89: /*
90: bug 13086505:As the profiles below have been disabled in the fnd_profile_options table,
91: These profile values can't retrieve using fnd_profile.value() function,It need to query
92: from fnd_profile_options ignore end_date_active criteria.
93: */
94: OPEN c_get_profile_value(v_profile_name,v_appl_id);

Line 92: from fnd_profile_options ignore end_date_active criteria.

88: BEGIN
89: /*
90: bug 13086505:As the profiles below have been disabled in the fnd_profile_options table,
91: These profile values can't retrieve using fnd_profile.value() function,It need to query
92: from fnd_profile_options ignore end_date_active criteria.
93: */
94: OPEN c_get_profile_value(v_profile_name,v_appl_id);
95: FETCH c_get_profile_value INTO l_profile_value;
96: CLOSE c_get_profile_value;