APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_PROFILE_OPTION_VALUES

Line 821: from FND_PROFILE_OPTION_VALUES

817: --
818:
819: if (p_level = '10003') then
820: select 'Y' into found
821: from FND_PROFILE_OPTION_VALUES
822: where PROFILE_OPTION_ID = profo_id
823: and APPLICATION_ID = app_id
824: and LEVEL_ID = 10003
825: and LEVEL_VALUE_APPLICATION_ID = lapp_id

Line 830: from FND_PROFILE_OPTION_VALUES

826: and LEVEL_VALUE = levval_id;
827: hr_utility.trace('Found Record..' || lapp_id || ' ' || levval_id);
828: else
829: select 'Y' into found
830: from FND_PROFILE_OPTION_VALUES
831: where PROFILE_OPTION_ID = profo_id
832: and APPLICATION_ID = app_id
833: and LEVEL_ID = to_number(p_level)
834: and LEVEL_VALUE = levval_id;

Line 838: update fnd_profile_option_values

834: and LEVEL_VALUE = levval_id;
835: end if;
836:
837: if (p_custom_mode = 'FORCE') then
838: update fnd_profile_option_values
839: set profile_option_value = p_profile_option_value,
840: last_update_date = f_ludate,
841: last_updated_by = f_luby,
842: last_update_login = 0

Line 853: insert into fnd_profile_option_values (

849: end if;
850: exception
851: when no_data_found then
852: hr_utility.trace('Creating Profile Option Value..');
853: insert into fnd_profile_option_values (
854: application_id,
855: profile_option_id,
856: level_id,
857: level_value,