[Home] [Help] [Dependency Information]
Object Name: | PAY_HK_MPF_REMITTANCE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_HK_MPF_REMITTANCE_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (10) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
TAX_UNIT_ID | NUMBER | (15) | ||
EFFECTIVE_DATE | DATE | Yes | ||
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | |
RUN_RESULT_ID | NUMBER | (15) | Yes | |
FULL_NAME | VARCHAR2 | (302) | ||
PERIOD_OF_SERVICE_ID | NUMBER | (9) | Yes | |
DATE_START | DATE | Yes | ||
ACTUAL_TERMINATION_DATE | DATE | |||
ELEMENT_NAME | VARCHAR2 | (80) | Yes | |
VALUE | NUMBER | |||
SCHEME_ID | NUMBER | |||
MEMBERSHIP_NUMBER | VARCHAR2 | (60) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
ASSESSED_RI | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, ASSIGNMENT_ID
, PAYROLL_ACTION_ID
, ASSIGNMENT_ACTION_ID
, TAX_UNIT_ID
, EFFECTIVE_DATE
, ELEMENT_TYPE_ID
, RUN_RESULT_ID
, FULL_NAME
, PERIOD_OF_SERVICE_ID
, DATE_START
, ACTUAL_TERMINATION_DATE
, ELEMENT_NAME
, VALUE
, SCHEME_ID
, MEMBERSHIP_NUMBER
, PERIOD_START_DATE
, PERIOD_END_DATE
, ASSESSED_RI
FROM APPS.PAY_HK_MPF_REMITTANCE_V;
|
|
|