[Home] [Help]
View: HR_SUP_BASE_V
Product: | PER - Human Resources |
Description: | Used to support user interface. |
Implementation/DBA Data: |
APPS.HR_SUP_BASE_V
|
View Text
SELECT DISTINCT FULL_NAME
, LAST_NAME
, FIRST_NAME
, ORDER_NAME
, TO_CHAR(PERSON_ID) PERSON_ID
, TO_CHAR(BUSINESS_GROUP_ID) BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DECODE (HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F'
, PERSON_ID
, PERSON_TYPE_ID
, EMPLOYEE_NUMBER
, APPLICANT_NUMBER)) INSIDE_PROFILE
FROM PER_ALL_PEOPLE_F
WHERE CURRENT_EMPLOYEE_FLAG = 'Y'
Columns
Name |
FULL_NAME |
LAST_NAME |
FIRST_NAME |
ORDER_NAME |
PERSON_ID |
BUSINESS_GROUP_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
INSIDE_PROFILE |