DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRFV_CONTACTS

Object Details
Object Name: HRFV_CONTACTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_CONTACTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows dependents, beneficiaries, relations, emergency
contacts etc. for people in your enterprise.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
PERSON_NAME VARCHAR2 (240)

CONTACT_PERSON_NAME VARCHAR2 (240)

PRIMARY_CONTACT VARCHAR2 (4000)

CONTACT_TYPE VARCHAR2 (4000)

DEPENDENT_FLAG VARCHAR2 (4000)

THIRD_PARTY_PAY VARCHAR2 (4000)

BENEFICIARY VARCHAR2 (4000)

BOND_HOLDER VARCHAR2 (4000)

EMPLOYEE_NUMBER VARCHAR2 (30)

_DF CHAR (24)

BUSINESS_GROUP_ID NUMBER (15) Yes
CONTACT_PERSON_ID NUMBER (10) Yes
PERSON_ID NUMBER (10) Yes
PEO_LAST_UPDATE_DATE DATE

Last Update Date WHO column from per_all_people_f for the employee
CPER_LAST_UPDATE_DATE DATE

Last Update Date WHO column from per_all_people_f for the contact
CON_LAST_UPDATE_DATE DATE

Last Update Date WHO column from per_contact_relationships
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      CONTACT_PERSON_NAME
,      PRIMARY_CONTACT
,      CONTACT_TYPE
,      DEPENDENT_FLAG
,      THIRD_PARTY_PAY
,      BENEFICIARY
,      BOND_HOLDER
,      EMPLOYEE_NUMBER
,      _DF
,      BUSINESS_GROUP_ID
,      CONTACT_PERSON_ID
,      PERSON_ID
,      PEO_LAST_UPDATE_DATE
,      CPER_LAST_UPDATE_DATE
,      CON_LAST_UPDATE_DATE
FROM APPS.HRFV_CONTACTS;

Dependencies

[top of page]

APPS.HRFV_CONTACTS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
SynonymPER_CONTACT_RELATIONSHIPS
ViewPER_PEOPLE_X

APPS.HRFV_CONTACTS is not referenced by any database object