[Home] [Help]
View: HRILV_EMP_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' /*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 |