Human Capital Management - EBS (MOSC)

MOSC Banner

SQL to find division for employee

edited Mar 16, 2010 1:02AM in Human Capital Management - EBS (MOSC) 6 commentsAnswered
 Hi

I'm trying to build a piece of sql which will track an employee's organization chart through the levels of organization.

For example, I can find the 'Sub Team' on the Employee's Assignment form - but if I want to work up the organization hierarchy to find out which 'Division' that 'Sub Team' is in - is there an easy way to go about doing this?

Many thanks

Martin

Tagged:

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