APPS.MSC_GET_PROFILE SQL Statements

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

Line: 35

        select profile_option_id,
               application_id
        from   fnd_profile_options
        where  profile_option_name = upper(name_z)
        and    start_date_active  <= sysdate
        and    nvl(end_date_active, sysdate) >= sysdate;

Line: 47

        select profile_option_value
        from   fnd_profile_option_values
        where  profile_option_id = pid
        and    application_id    = aid
        and    level_id          = lid
        and    level_value       = lval;

Line: 59

        select profile_option_value
        from   fnd_profile_option_values
        where  profile_option_id = pid
        and    application_id = aid
        and    level_id = 10003
        and    level_value = lval
        and    level_value_application_id = laid;

Line: 152

    select PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL
    WHERE START_DATE_ACTIVE <= SYSDATE and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
    AND (SITE_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y')
    AND UPPER(USER_PROFILE_OPTION_NAME) LIKE prod||'%';

Line: 158

       select nvl(substr(value,1,instr(value,',')-1),value) from v$parameter where name = 'utl_file_dir';

Line: 192

   select user_id into usr_id from fnd_user where user_name=usr_name;

Line: 196

   select application_id into appl_id from fnd_application where application_short_name=application_name;

Line: 200

   select responsibility_id into resp_id from fnd_responsibility_vl where responsibility_name=resp_name and   application_id=appl_id;