DBA Data[Home] [Help]

APPS.GMA_GET_PROFILE dependencies on FND_APPLICATION

Line 7: fnd_application appl,

3: FUNCTION get_profile_value(appl_short_name IN VARCHAR2,profile_name IN VARCHAR2) RETURN VARCHAR2 IS
4: CURSOR get_profile_cursor(c_appl_short_name VARCHAR2,c_profile_name VARCHAR2) IS
5: SELECT substr(profile_option_value,1,30)
6: FROM fnd_profile_options opt,
7: fnd_application appl,
8: fnd_profile_option_values val
9: WHERE opt.application_id = val.application_id
10: AND opt.profile_option_id = val.profile_option_id
11: AND opt.application_id = appl.application_id