[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_HK_IR56_EMPLOYEE_V

Object Details

Object Name:	PAY_HK_IR56_EMPLOYEE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_HK_IR56_EMPLOYEE_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT PERSON_ID
,      ASSIGNMENT_ID
,      EMPLOYER_RETURN_FILE_NO
,      DESIGNATION
,      DESIGNATION_NAME
,      EMPLOYER_RETURN_LAST_8
,      EMPLOYER_NAME
,      EMPLOYER_ADDRESS
,      TITLE
,      FULL_NAME
,      LAST_NAME
,      MAIDEN_NAME
,      EMPLOYEE_TAX_FILE_NO
,      HK_ID_CARD_NO
,      PASSPORT_NUMBER
,      SEX
,      MARITAL_STATUS
,      SPOUSE_NAME
,      SPOUSE_HK_ID_CARD_NO
,      SPOUSE_PASSPORT_NUMBER
,      RESIDENTIAL_ADDRESS
,      RESIDENTIAL_TEL_NUMBER
,      CORRESPONDENCE_ADDRESS
,      CORRESPONDENCE_TEL_NUMBER
,      CAPACITY_EMPLOYED
,      LEGAL_EMPLOYER_ID
,      PRINCIPAL_EMPLOYER_NAME
,      EXPECTED_CESSATION_DATE
,      EMPLOYMENT_PERIOD
,      LEAVING_REASON
,      NEW_EMPLOYER_NAME_ADDRESS
,      FUTURE_CORRESPONDENCE_ADDRESS
,      DEPARTURE_DATE
,      DEPARTURE_REASON
,      DEPARTURE_REASON_SELECT
,      RETURN_TO_HK
,      PROBABLE_RETURN_DATE
,      SALARIES_TAX_BORNE_BY_EMPLOYER
,      COUNTRY_RETURNING_TO
,      SECONDED_TO
,      MONIES_HELD_SECTION52
,      AMOUNT_MONIES_HELD_SECTION52
,      REASON_NO_HOLD_SECTION52
,      SERVICE_DATE_START
,      SERVICE_TERMINATION_DATE
,      FINAL_PROCESS_DATE
,      SERVICE_TAX_REPORTING_YEAR
FROM APPS.PAY_HK_IR56_EMPLOYEE_V;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

FND_TERRITORIES_VL

HR_API - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS

HR_LOOKUPS

HR_ORGANIZATION_INFORMATION

HR_ORGANIZATION_UNITS

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

HR_SOFT_CODING_KEYFLEX

PAY_HK_IR56_SPOUSE_DETAILS_V

PER_ADDRESSES

PER_ASSIGNMENTS_F

PER_ASSIGNMENT_EXTRA_INFO

PER_PEOPLE_F

PER_PERIODS_OF_SERVICE

APPS.PAY_HK_IR56_EMPLOYEE_V is not referenced by any database object