Performance Rating Fast formula - Template base evaluations

Summary

Performance Rating Fast formula

Content

Hi Expert,

I need to get DBIs behind this query.

 

select  her.CALCULATED_RATING

 

from  hra_tmpl_sections   hts,

  hra_eval_sections  hes ,

  hra_eval_ratings  her,

  hra_evaluations he 

where 1=1

and hts.SECTION_ID = hes.tmpl_section_id

AND he.business_group_id = hts.business_group_id

AND he.template_defn_id = hts.template_defn_id

and he.evaluation_id = her.evaluation_id

AND her.reference_id = hes.eval_section_id

and her.REFERENCE_TYPE = 'SECTION'

and hts.section_type_code = 'REG'

and her.ROLE_TYPE_CODE = 'MANAGER'   /* only manger feedback value */

and hts.template_defn_id = 300006259540837