P 2 K_PU.FIRST_MGR

Derived First Manager#

Functionality:#

This function retrieves the P2K_HR_IDENTITIES ID for the derived first manager for the assignment detail identified, following the derived first manager logic

Parameters:#

EASD_ID The actual ID for the assignment detail you are looking at
AS_OF optional The as-of date you want to find the manager for. If not provided, the current date is used.

Returns: #

Number The EID_ID of the derived first manager

Notes:#

If the as of date provided is not within the effective - expiry range of the assignment detail identified by the first parameter, then whichever of effective or expiry that is closest to the as of date is used.

Errors: #

None

Example: #

P2K_PU.FIRST_MGR(~)

Will return the EID_ID for the employee's first manager.

P2K_PU.EID(P2K_PU.FIRST_MGR(~),'NAME')

Will return the name from P2K_PU.EID for the first manager, using the ID returned by this function


Notes#

Click to create a new notes page