DBA Data[Home] [Help]

APPS.OTA_CPR_UTILITY dependencies on PER_COMPETENCES

Line 115: ,per_competences pce

111: */
112: select MAX(step_value)
113: from
114: per_rating_levels prl
115: ,per_competences pce
116: where (prl.rating_scale_id = pce.rating_scale_id
117: OR pce.competence_id = prl.competence_id)
118: AND pce.competence_id = p_comp_id;
119:

Line 129: ,per_competences pce

125: */
126: select MIN(step_value)
127: from
128: per_rating_levels prl
129: ,per_competences pce
130: where (prl.rating_scale_id = pce.rating_scale_id
131: OR pce.competence_id = prl.competence_id)
132: AND pce.competence_id = p_comp_id;
133: