[Home] [Help] [Dependency Information]
Object Name: | HR_LEGISLATION_SUBGROUPS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.HR_LEGISLATION_SUBGROUPS |
Subobject Name: | |
Status: | VALID |
HR_LEGISLATION_SUBGROUPS holds details of the legislative subgroups in
a specific legislation. For example, each state in the USA is a
distinct legislative subgroup. These subgroups are used when startup
data must to be delivered at different levels within a single
legislation.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_LEGISLATION_SUBGROUPS_PK | NORMAL | UNIQUE | APPS_TS_SEED |
LEGISLATION_CODE
LEGISLATION_SUBGROUP |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGISLATION_CODE | VARCHAR2 | (30) | Yes | The legislation to which the subgroup belongs. |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Yes | Lookup code of the legislation subgroup. |
ACTIVE_INACTIVE_FLAG | VARCHAR2 | (30) | Yes | Indicates whether the legislation subgroup can be used. |
LEGISLATION_SUBGROUP_NAME | VARCHAR2 | (80) | Yes | The lookup meaning of the legislation subgroup. |
Cut, paste (and edit) the following text to query this object:
SELECT LEGISLATION_CODE
, LEGISLATION_SUBGROUP
, ACTIVE_INACTIVE_FLAG
, LEGISLATION_SUBGROUP_NAME
FROM HR.HR_LEGISLATION_SUBGROUPS;
HR.HR_LEGISLATION_SUBGROUPS does not reference any database object
HR.HR_LEGISLATION_SUBGROUPS is referenced by following:
|
|
|