19: ,cmpe.effective_date_from
20: ,cmpe.effective_date_to
21: ,cmpe.certification_date
22: ,cmpe.certification_method
23: ,hr_general.decode_lookup ('CERTIFICATION_METHOD' ,cmpe.certification_method) certification_method_desc
24: ,cmpe.next_certification_date
25: ,cmpe.source_of_proficiency_level
26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc
27: ,cmpe.comments
22: ,cmpe.certification_method
23: ,hr_general.decode_lookup ('CERTIFICATION_METHOD' ,cmpe.certification_method) certification_method_desc
24: ,cmpe.next_certification_date
25: ,cmpe.source_of_proficiency_level
26: ,hr_general.decode_lookup ('PROFICIENCY_SOURCE' ,cmpe.source_of_proficiency_level) src_proficiency_lvl_desc
27: ,cmpe.comments
28: ,cvl.competence_alias
29: ,cmpe.status -- added for Competnce Qualification link enahncement
30: from per_rating_levels ratl