Compensation Hierarchy Determination Rule

Summary:

Content (required):

Hi Experts,

We have a requirement that the worksheet should follow below approval route:

Immediate Line Manager -> Center Head (defined by AOR in that org hierarchy) -> Division Head (defined by AOR in that org hierarchy) -> HR admin (defined by AOR)

I have written below given formula for the same. But it's not returning any value.

How can I achieve this?

Thanks in advance,

Pooja

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

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

INPUTS ARE CMP_IV_ASSIGNMENT_ID (number),