APPS.PER_COMPETENCE_DATA_PUMP dependencies on PER_RATING_SCALES

Line 38: FROM per_rating_scales

34: IF p_business_group_id is null THEN
35:
36: SELECT rating_scale_id
37: INTO l_rating_scale_id
38: FROM per_rating_scales
39: WHERE name = p_old_rating_scale_name
40: AND business_group_id is null;
41:
42: ELSE

Line 46: FROM per_rating_scales

42: ELSE
43:
44: SELECT rating_scale_id
45: INTO l_rating_scale_id
46: FROM per_rating_scales
47: WHERE name = p_old_rating_scale_name
48: AND business_group_id = p_business_group_id;
49:
50: END IF;

Line 89: FROM per_rating_scales

85: IF p_business_group_id is null THEN
86:
87: SELECT rating_scale_id
88: INTO l_rating_scale_id
89: FROM per_rating_scales
90: WHERE name = p_rating_scale_name
91: AND business_group_id is null;
92:
93: ELSE

Line 97: FROM per_rating_scales

93: ELSE
94:
95: SELECT rating_scale_id
96: INTO l_rating_scale_id
97: FROM per_rating_scales
98: WHERE name = p_rating_scale_name
99: AND business_group_id = p_business_group_id;
100:
101: END IF;

Line 127: l_rsc_ovn per_rating_scales.object_version_number%TYPE;

123: ,p_business_group_id IN NUMBER)
124: RETURN BINARY_INTEGER
125: IS
126:
127: l_rsc_ovn per_rating_scales.object_version_number%TYPE;
128:
129: BEGIN
130:
131: IF p_old_rating_scale_name is NULL then

Line 145: FROM per_rating_scales

141: IF p_business_group_id is null THEN
142:
143: SELECT object_version_number
144: INTO l_rsc_ovn
145: FROM per_rating_scales
146: WHERE name = p_old_rating_scale_name
147: AND business_group_id is null;
148:
149: ELSE

Line 153: FROM per_rating_scales

149: ELSE
150:
151: SELECT object_version_number
152: INTO l_rsc_ovn
153: FROM per_rating_scales
154: WHERE name = p_old_rating_scale_name
155: AND business_group_id = p_business_group_id;
156:
157: END IF;

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 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 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)