APPS.OTA_TRAINING_SS dependencies on PER_COMPETENCES

Line 3164: per_competences ce,

3160: CURSOR get_min_step_value IS
3161: select
3162: min(rl.step_value)
3163: from
3164: per_competences ce,
3165: per_rating_levels rl
3166: where
3167: ce.competence_id = to_number(p_comp_id) and
3168: rl.rating_scale_id = ce.rating_scale_id;

Line 3189: per_competences ce,

3185: CURSOR get_max_step_value IS
3186: select
3187: max(rl.step_value)
3188: from
3189: per_competences ce,
3190: per_rating_levels rl
3191: where
3192: ce.competence_id = to_number(p_comp_id) and
3193: rl.rating_scale_id = ce.rating_scale_id;