APPS.PER_COMPETENCE_DATA_PUMP dependencies on PER_COMPETENCES_VL

Line 215: FROM per_competences_vl

211: IF p_business_group_id is null THEN
212:
213: SELECT competence_id
214: INTO l_competence_id
215: FROM per_competences_vl
216: WHERE name = p_competence_name
217: AND business_group_id is null;
218:
219: ELSE

Line 223: FROM per_competences_vl

219: ELSE
220:
221: SELECT competence_id
222: INTO l_competence_id
223: FROM per_competences_vl
224: WHERE name = p_competence_name
225: AND business_group_id = p_business_group_id;
226:
227: END IF;

Line 269: FROM per_competences_vl

265: IF p_business_group_id is null THEN
266:
267: SELECT object_version_number
268: INTO l_cpn_ovn
269: FROM per_competences_vl
270: WHERE name = p_competence_name
271: AND business_group_id is null;
272:
273: ELSE

Line 277: FROM per_competences_vl

273: ELSE
274:
275: SELECT object_version_number
276: INTO l_cpn_ovn
277: FROM per_competences_vl
278: WHERE name = p_competence_name
279: AND business_group_id = p_business_group_id;
280:
281: END IF;

Line 496: FROM per_competences_vl cpn , per_rating_levels rtl

492: ELSIF ( p_competence_name is not null AND p_rating_scale_name is null ) THEN
493:
494: SELECT rtl.rating_level_id
495: INTO l_rating_level_id
496: FROM per_competences_vl cpn , per_rating_levels rtl
497: WHERE rtl.name = p_old_rating_level_name
498: AND cpn.competence_id = rtl.competence_id
499: AND cpn.name = p_competence_name
500: AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)

Line 559: FROM per_competences_vl cpn , per_rating_levels rtl

555: ELSIF ( p_competence_name is not null AND p_rating_scale_name is null ) THEN
556:
557: SELECT rtl.rating_level_id
558: INTO l_rating_level_id
559: FROM per_competences_vl cpn , per_rating_levels rtl
560: WHERE rtl.name = p_rating_level_name
561: AND cpn.competence_id = rtl.competence_id
562: AND cpn.name = p_competence_name
563: AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)

Line 623: FROM per_competences_vl cpn , per_rating_levels rtl

619: ELSIF ( p_competence_name is not null AND p_rating_scale_name is null ) THEN
620:
621: SELECT rtl.object_version_number
622: INTO l_rtl_ovn
623: FROM per_competences_vl cpn , per_rating_levels rtl
624: WHERE rtl.name = p_old_rating_level_name
625: AND cpn.competence_id = rtl.competence_id
626: AND cpn.name = p_competence_name
627: AND NVL(cpn.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)