DBI to pick Manager salary — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DBI to pick Manager salary

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 4 comments

Summary

Written the following formula to pick the manager salary, giving no value. Seems I am using the wrong DBI.

Content

/*=========== DATABASE ITEM DEFAULTS BEGIN ==============*/
DEFAULT FOR L_MGR_NUMBER IS ' '
DEFAULT FOR PER_ASG_PERSON_NUMBER IS ' '
DEFAULT FOR CMP_ASSIGNMENT_SALARY_AMOUNT IS 0
DEFAULT FOR PER_ASG_MGR_MANAGER_ID IS 0
/*=========== DATABASE ITEM DEFAULTS END ================*/
/*=========== INPUT SECTION BEGIN ==============*/
INPUTS ARE CMP_IV_PLAN_ID (number)
/*=========== INPUT SECTION ENDS ==============*/
/*=========== FORMULA SECTION BEGIN =====================*/
L_MGR_NUMBER = to_char(PER_ASG_MGR_MANAGER_ID)
CHANGE_CONTEXTS(PERSON_ID = TO_NUMBER(L_MGR_NUMBER))
(
RULE_VALUE = CMP_ASSIGNMENT_SALARY_AMOUNT

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!