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