DBA Data[Home] [Help]

APPS.GMA_GET_PROFILE dependencies on FND_PROFILE_OPTIONS

Line 6: FROM fnd_profile_options opt,

2: /* $Header: GMAPROFB.pls 115.0 99/07/16 02:46:53 porting shi $ */
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