DBA Data[Home] [Help]

APPS.IGI_CIS_GET_PROFILE SQL Statements

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

Line: 8

        SELECT profile_option_value
        INTO   l_profile_option_value
        FROM   fnd_profile_option_values fpov
              ,fnd_profile_options       fpo
        WHERE  UPPER(fpo.profile_option_name) = 'IGI_CIS_TAX_CODE'
        AND    fpov.profile_option_id = fpo.profile_option_id
        AND    fpov.level_id = 10001;
Line: 34

        SELECT profile_option_value
        INTO   l_profile_option_value
        FROM   fnd_profile_option_values fpov
              ,fnd_profile_options       fpo
        WHERE  UPPER(fpo.profile_option_name) = 'IGI_CIS_TAX_GROUP'
        AND    fpov.profile_option_id = fpo.profile_option_id
        AND    fpov.level_id = 10001;