PL/SQL (MOSC)

MOSC Banner

Finding the connection between a person and their payroll elements

in PL/SQL (MOSC) 1 commentAnswered

I'm trying to make a connection between a person, and all the payroll elements they qualify for based on their groups.

The closest I've found is under the Human Resources book 21a in Global Payroll.

There's a view called pay_payroll_assignments which contains payroll_assignment_id and person_id.

How can I connect that person_id to tables like pay_element_types_f?

and to clarify, I want to be able to see all payroll elements a person CAN have on their payroll. It's not helpful to see entries because that doesn't tell me if someone COULD qualify for overtime for example.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center