APPS.BOMPRFIL SQL Statements

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

Line: 24

        SELECT  opt.profile_option_id,
                level_id,
                level_value,
                substrb(profile_option_value,1,10)
        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 */
                 OR
                 (val.level_id = 10002        /* Application */
                  and val.level_value = c_resp_appl_id

                 )
                 OR
                 (val.level_id = 10003        /* Responsibility */
                  and val.level_value_application_id = c_resp_appl_id
                  and val.level_value = c_resp_id
                 )
                 OR
                 (val.level_id = 10004        /* User */
                  and val.level_value = c_user_id
                 )
                )
        ORDER BY opt.profile_option_id, level_id desc;