SELECT SUPH.SUP_PERSON_ID MGRH0_SUP_PERSON_FK, SUPH.SUP_LEVEL MGRH0_SUP_LEVEL, SUPH.SUB_MNGRSC_FK MGRH0_MNGRSC_FK, SUPH.SUP_PERSON_ID MGRH0_PERSON_FK, SUPH.SUB_LEVEL MGRH0_LEVEL, SUPH.SUB_RELATIVE_LEVEL MGRH0_RELATIVE_LEVEL, SUPH.EFFECTIVE_START_DATE MGRH0_DATE_START, SUPH.EFFECTIVE_END_DATE MGRH0_DATE_END FROM HRI_CS_SUPH SUPH WHERE SUPH.SUB_RELATIVE_LEVEL = 0
SELECT SUPH.SUP_PERSON_ID MGRH0_SUP_PERSON_FK
, SUPH.SUP_LEVEL MGRH0_SUP_LEVEL
, SUPH.SUB_MNGRSC_FK MGRH0_MNGRSC_FK
, SUPH.SUP_PERSON_ID MGRH0_PERSON_FK
, SUPH.SUB_LEVEL MGRH0_LEVEL
, SUPH.SUB_RELATIVE_LEVEL MGRH0_RELATIVE_LEVEL
, SUPH.EFFECTIVE_START_DATE MGRH0_DATE_START
, SUPH.EFFECTIVE_END_DATE MGRH0_DATE_END
FROM HRI_CS_SUPH SUPH
WHERE SUPH.SUB_RELATIVE_LEVEL = 0
|
|
|