APPS.INVPROFL SQL Statements

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

Line: 26

           SELECT  opt.profile_option_id,
                   level_id,
                   level_value,
                   substrb(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 */
                      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;