How to extract assignment category if employee has multiple active assignments

Summary

employee has two active assignments, how to extract both assignment categories in fast formula

Content

Hi All

Employee A has multiple active assignments, when submitting absence for this employee, there's one option to select for which assignment/job/ID it's submitting for. But when it comes to absence entry valdiation fast formula, its assignment contexts is always the second assignment. Is there a way to extract the first assignment id / assignment category as well? Thanks in advance.

The DBI I used is PER_ASG_EMPLOYMENT_CATEGORY. 

Version

20C (11.13.20.07.0)

Code Snippet

DEFAULT for PER_ASG_EMPLOYMENT_CATEGORY is 'None'

l_asg_category_code = PER_ASG_EMPLOYMENT_CATEGORY
return l_asg_category_code