[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_GB_PERSONAL_DETAILS

Object Details

Object Name:	HRFV_GB_PERSONAL_DETAILS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_GB_PERSONAL_DETAILS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows UK specific information about UK people. Use
PERSONAL DETAILS to see generic information about all people.
The information shown is current as of today.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      PREFIX
,      SUFFIX
,      FIRST_NAME
,      LAST_NAME
,      PREFERRED_NAME
,      MIDDLE_NAMES
,      TITLE
,      NI_NUMBER
,      ETHNIC_ORIGIN
,      DIRECTOR
,      PENSIONER
,      WORK_PERMIT_NUMBER
,      ADDL_PENSIONABLE_YEARS
,      ADDL_PENSIONABLE_MONTHS
,      ADDL_PENSIONABLE_DAYS
,      NI_MULTIPLE_ASSIGNMENTS
,      _DF
,      BUSINESS_GROUP_ID
,      PERSON_ID
FROM APPS.HRFV_GB_PERSONAL_DETAILS;

Dependencies

[top of page]

APPS

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_BUSINESS_GROUPS

PER_PEOPLE_X

PUBLIC

HRFV_GB_PERSONAL_DETAILS