[Home] [Help]
View: HRILV_SUP_HRS_X
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ PER.PERSON_ID ID
, PER.FULL_NAME VALUE
, PER.EFFECTIVE_START_DATE DATE_FROM
, PER.EFFECTIVE_END_DATE DATE_TO /*PARENT IDS*/
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID /*OTHER IDS*/
, PER.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMP_OR_APL_FLAG CURRENT_EMP_OR_APL_FLAG
, PER.PERSON_TYPE_ID PERSON_TYPE_ID
, PER.COMMENT_ID COMMENT_ID
FROM PER_PEOPLE_X PER
WHERE /*JOINS*/ /*DATE*/ /*RESTRICTIONS*/ CURRENT_EMPLOYEE_FLAG = 'Y'
AND EXISTS ( SELECT -1
FROM PER_ALL_ASSIGNMENTS_F ASG
WHERE PER.PERSON_ID = ASG.SUPERVISOR_ID ) /*SECURITY*/
AND PER.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PER.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |
CURRENT_EMPLOYEE_FLAG |
CURRENT_APPLICANT_FLAG |
CURRENT_EMP_OR_APL_FLAG |
PERSON_TYPE_ID |
COMMENT_ID |