[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;
APPS
FND_DATE
- show dependent code
HR_GENERAL
- show dependent code
HR_PERSON_NAME
- show dependent code
HR_SECURITY
- show dependent code
PAY_ASSIGNMENT_ACTIONS
PAY_ELEMENT_TYPES_F
PAY_INPUT_VALUES_F
PAY_PAYROLL_ACTIONS
PAY_RUN_RESULTS
PAY_RUN_RESULT_VALUES
PER_ASSIGNMENTS_F
PER_PEOPLE_F
PER_PERIODS_OF_SERVICE
APPS.PAY_HK_MPF_REMITTANCE_V is not referenced by any database object
|
|
|
|