APPS.HR_COMP_PROFILE_SS dependencies on DUAL

Line 2239: from dual;

2235: begin
2236: hr_utility.set_location(' Entering:' || l_proc,5);
2237: select upper(rtrim(ltrim(p_competence_name))), upper(rtrim(ltrim(p_competence_alias)))
2238: into p_competence_name, p_competence_alias
2239: from dual;
2240: --
2241: select name,competence_alias,competence_id into p_competence_name,p_competence_alias,p_competence_id
2242: from per_competences_vl
2243: where upper(name) = p_competence_name or upper(competence_alias) = p_competence_alias

Line 2702: from dual;

2698: hr_utility.set_location(' Entering:' || l_proc,5);
2699: l_count := 0;
2700: select rtrim(ltrim(p_competence_name)), rtrim(ltrim(p_competence_alias)), rtrim(ltrim(p_competence_id)), rtrim(ltrim(p_step_value))
2701: into p_competence_name, p_competence_alias, p_competence_id, p_step_value
2702: from dual;
2703: If p_competence_id is not null and p_competence_name is null Then
2704: hr_utility.set_location(l_proc,10);
2705: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2706: p_error_message => p_error_message,