APPS.GMA_GET_PROFILE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

        SELECT  substr(profile_option_value,1,30)
        FROM    fnd_profile_options opt,
                fnd_application appl,
                fnd_profile_option_values val
        WHERE   opt.application_id = val.application_id
        AND     opt.profile_option_id = val.profile_option_id
        AND     opt.application_id = appl.application_id
        AND     appl.application_short_name = c_appl_short_name
        AND     opt.profile_option_name = c_profile_name
        AND     val.level_id = 10001        /* Site */
        ORDER BY opt.profile_option_id, level_id desc;