APPS.PER_COMPETENCE_DATA_PUMP dependencies on PER_RATING_LEVELS

Line 485: FROM per_rating_scales rsc , per_rating_levels rtl

481: IF ( p_competence_name is null AND p_rating_scale_name is not null ) THEN
482:
483: SELECT rtl.rating_level_id
484: INTO l_rating_level_id
485: FROM per_rating_scales rsc , per_rating_levels rtl
486: WHERE rtl.name = p_old_rating_level_name
487: AND rsc.rating_scale_id = rtl.rating_scale_id
488: AND rsc.name = p_rating_scale_name
489: AND NVL(rsc.business_group_id,hr_api_g_number) = NVL(rtl.business_group_id,hr_api_g_number)

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 548: FROM per_rating_scales rsc , per_rating_levels rtl

544: IF ( p_competence_name is null AND p_rating_scale_name is not null ) THEN
545:
546: SELECT rtl.rating_level_id
547: INTO l_rating_level_id
548: FROM per_rating_scales rsc , per_rating_levels rtl
549: WHERE rtl.name = p_rating_level_name
550: AND rsc.rating_scale_id = rtl.rating_scale_id
551: AND rsc.name = p_rating_scale_name
552: AND NVL(rsc.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 595: l_rtl_ovn per_rating_levels.object_version_number%TYPE;

591: ,p_old_rating_level_name IN VARCHAR2
592: ,p_business_group_id IN NUMBER)
593: RETURN BINARY_INTEGER
594: IS
595: l_rtl_ovn per_rating_levels.object_version_number%TYPE;
596: BEGIN
597:
598: IF p_old_rating_level_name is NULL then
599:

Line 612: FROM per_rating_scales rsc , per_rating_levels rtl

608: IF ( p_competence_name is null AND p_rating_scale_name is not null ) THEN
609:
610: SELECT rtl.object_version_number
611: INTO l_rtl_ovn
612: FROM per_rating_scales rsc , per_rating_levels rtl
613: WHERE rtl.name = p_old_rating_level_name
614: AND rsc.rating_scale_id = rtl.rating_scale_id
615: AND rsc.name = p_rating_scale_name
616: AND NVL(rsc.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)