View: PA_REP_RES_MGR_V

Product:	PA - Projects
Description:	PA_REP_RES_MGR_V is a view that list all direct and indirect managers in HR for a given application user
Implementation/DBA Data:	APPS.PA_REP_RES_MGR_V

View Text

SELECT DISTINCT(MANAGER_ID)
, MANAGER_NAME
FROM PA_RESOURCES_DENORM
WHERE SYSDATE BETWEEN RESOURCE_EFFECTIVE_START_DATE
AND RESOURCE_EFFECTIVE_END_DATE START WITH MANAGER_ID = PA_RESOURCE_UTILS.GET_RESOURCE_MANAGER_ID(FND_GLOBAL.USER_ID) CONNECT BY PRIOR PERSON_ID = MANAGER_ID
AND PERSON_ID <> PRIOR MANAGER_ID
AND SYSDATE BETWEEN RESOURCE_EFFECTIVE_START_DATE
AND RESOURCE_EFFECTIVE_END_DATE

Columns