[Home] [Help] [Dependency Information]
Object Name: | PAY_CA_LEGISLATION_INFO |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_CA_LEGISLATION_INFO |
Subobject Name: | |
Status: | VALID |
Keeps legislation specific data for Canada
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (80) | Lookup Type | |
LOOKUP_CODE | VARCHAR2 | (80) | Lookup Code | |
JURISDICTION_CODE | VARCHAR2 | (80) | Jurisdiction Code | |
INFORMATION_TYPE | VARCHAR2 | (80) | Information Type | |
INFORMATION_VALUE | VARCHAR2 | (80) | Value for the information type | |
START_DATE | DATE | Start date of the record | ||
END_DATE | DATE | End date of the record |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, JURISDICTION_CODE
, INFORMATION_TYPE
, INFORMATION_VALUE
, START_DATE
, END_DATE
FROM HR.PAY_CA_LEGISLATION_INFO;
HR.PAY_CA_LEGISLATION_INFO does not reference any database object
HR.PAY_CA_LEGISLATION_INFO is referenced by following:
|
|
|