Performance Rating Calculation based on Business Unit

Summary:

Content (required):

Hi Experts,

We have a requirement where weight is determined by the Business Unit. Hence we have used below code.

/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/

Default for HRA_EVAL_GOAL_SECTION_RATING_FC_CALCULATED_SCORE is 0

DEFAULT_DATA_VALUE for ORA_HWM_PERSON_ASSIGNMENT_BUSINESS_UNIT_NAME is 'Default-Section'

ln_weight = 0

If(ORA_HWM_PERSON_ASSIGNMENT_BUSINESS_UNIT_NAME[1] = 'HBKU')

THEN

(

ln_weight = 0.8

)

else if(ORA_HWM_PERSON_ASSIGNMENT_BUSINESS_UNIT_NAME[1] = 'PUE')

THEN

(

ln_weight = 0.6

)

else if(ORA_HWM_PERSON_ASSIGNMENT_BUSINESS_UNIT_NAME[1] = 'Qatar Foundation')

THEN

(

ln_weight = 0.7

)

l_log = ess_log_write('ln_weight :'||TO_CHAR(ln_weight))