12.2 - How to find grade ladder program id to save via hr_assignment_api
I'm working on an interface to import new hire information into the People and Assignment screens from an external hiring website, and I can't figure out how to find the list of valid Grade Ladders as shown on the Assignment screen's Grade Ladder tab. I can't find any Lookup Table entry that supplies this drop-down list of grade ladders.
Is the Assignment screen going into the actual grade ladder setup that's done via Total Compensation Wizard to supply that list to the user maintaining info on the Assignment screen?
I was trying to come up with a query that would supply the valid list of Grade Ladders so I could find and save the p_grade_ladder_pgm_id into the assignment via the API hr_assignment_api.update_emp_asg_criteria. I can't seem to find any source for the grade ladder program ID.