Product: | HRI - Human Resources Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HRIBV_SUPV_HRCHY_ROLLUP_X |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ BGRT.NAME SUPERVISOR_BUSINESS_GROUP
, PER.FULL_NAME SUPERVISOR_PERSON_NAME
, SVL.SUPV_LEVEL SUPERVISOR_LEVEL
, PER2.FULL_NAME SUBORDINATE_PERSON_NAME
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, SVL.SUB_PRIMARY_ASG_FLAG) SUBORDINATE_PRIMARY_ASG_FLAG
, SVL.SUB_PRIMARY_ASG_FLAG SUBORD_PRIMARY_ASG_FLAG_CODE
, SVL.SUB_LEVEL SUBORDINATE_LEVEL
, SSVL.SUB_LEVEL SUB_RO_LEVEL /* IDS */
, SVL.SUPV_BUSINESS_GROUP_ID SUPERVISOR_BUSINESS_GROUP_ID
, SVL.SUPV_PERSON_ID SUPERVISOR_PERSON_ID
, SVL.SUPV_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, SVL.SUB_BUSINESS_GROUP_ID SUBORDINATE_BUSINESS_GROUP_ID
, SVL.SUB_PERSON_ID SUBORDINATE_PERSON_ID
, SVL.SUB_ASSIGNMENT_ID SUBORDINATE_ASSIGNMENT_ID
, SSVL.SUB_BUSINESS_GROUP_ID SUB_RO_BUSINESS_GROUP_ID
, SSVL.SUB_PERSON_ID SUB_RO_PERSON_ID
, SSVL.SUB_ASSIGNMENT_ID SUB_RO_ASSIGNMENT_ID
FROM HRI_SUPV_HRCHY_SUMMARY SVL
, HRI_SUPV_HRCHY_SUMMARY SSVL
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PER
, PER_PEOPLE_X PER2
WHERE SVL.SUB_PERSON_ID = SSVL.SUPV_PERSON_ID
AND SVL.SUPV_BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID (+)
AND BGRT.LANGUAGE (+) = USERENV('LANG')
AND SVL.SUPV_PERSON_ID = PER.PERSON_ID
AND SVL.SUB_PERSON_ID = PER2.PERSON_ID WITH READ ONLY