VIEW: APPS.PA_REP_RES_MGR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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