APPS.OTA_TRB_API_PROCEDURES dependencies on PER_RATING_LEVELS

Line 2073: FROM per_competence_elements pce, per_rating_levels rat

2069: IS
2070: SELECT pce.competence_id ,
2071: nvl(pce.proficiency_level_id,0) proficiency_level_id ,
2072: nvl(rat.step_value,0) step_value
2073: FROM per_competence_elements pce, per_rating_levels rat
2074: WHERE nvl(pce.effective_date_from, p_required_date_from ) <= p_required_date_from --bug 3332972
2075: AND nvl(pce.effective_date_to,p_required_date_to) >= p_required_date_to --bug 3332972
2076: AND rat.rating_level_id = pce.proficiency_level_id
2077: AND pce.type = 'OTA_OFFERING' --bug 3494404

Line 2108: per_rating_levels rat

2104: Select ocl.competence_id,
2105: nvl(ocl.min_proficiency_level_id,0) min_proficiency_level_id,
2106: nvl(rat.step_value,0) step_value
2107: From ota_competence_languages ocl,
2108: per_rating_levels rat
2109: Where
2110: ocl.language_code = p_language_code and
2111: ocl.business_group_id = ota_general.get_business_group_id and
2112: nvl(rat.rating_level_id,0) = nvl(ocl.min_proficiency_level_id,0);

Line 2161: ' per_rating_levels rat '||

2157: For b in c_trainer_comp(l_event_id)
2158: LOOP
2159: if l_competence is null then
2160: l_competence := ' select pce.person_id from per_competence_elements pce ,' ||
2161: ' per_rating_levels rat '||
2162: ' where ' ||
2163: ' pce.competence_id = '||b.competence_id ||
2164: ' and rat.rating_level_id = pce.proficiency_level_id ' ||
2165: ' and pce.person_id = :person_id ' ||

Line 2175: ' per_rating_levels rat ' ||

2171:
2172: l_competence := l_competence || ' AND ' ||
2173: ' pce.person_id in ('||
2174: ' select pce.person_id from per_competence_elements pce , '||
2175: ' per_rating_levels rat ' ||
2176: ' where' ||
2177: ' pce.competence_id = '||b.competence_id ||
2178: ' and pce.effective_date_from <= '''||p_required_date_from||
2179: ''' and NVL(pce.effective_date_to,'''||p_end_of_time||''') >= '''||p_required_date_to||

Line 2194: ' per_rating_levels rat ' ||

2190: For lang_comp in c_comp_lang(l_language_code)
2191: LOOP
2192: if l_competence is null then
2193: l_competence := ' select pce.person_id from per_competence_elements pce, '||
2194: ' per_rating_levels rat ' ||
2195: ' where' ||
2196: ' pce.competence_id = '||lang_comp.competence_id ||
2197: ' and pce.effective_date_from <= '''||p_required_date_from||
2198: ''' and NVL(pce.effective_date_to,'''||p_end_of_time||''') >= '''||p_required_date_to||

Line 2209: ' per_rating_levels rat ' ||

2205:
2206: l_competence := l_competence || ' AND ' ||
2207: ' pce.person_id in ('||
2208: ' select person_id from per_competence_elements pce , '||
2209: ' per_rating_levels rat ' ||
2210: ' where' ||
2211: ' pce.competence_id = '||lang_comp.competence_id ||
2212: ' and pce.effective_date_from <= '''||p_required_date_from||
2213: ''' and NVL(pce.effective_date_to,'''||p_end_of_time||''') >= '''||p_required_date_to||