DBA Data[Home] [Help]

APPS.GMA_GET_PROFILE dependencies on FND_PROFILE_OPTION_VALUES

Line 8: fnd_profile_option_values val

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
12: AND appl.application_short_name = c_appl_short_name