[Home] [Help]
[Dependency Information]
| Object Name: | HR_H2PI_PAY_BASES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PER.HR_H2PI_PAY_BASES_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPD_DATE | DATE | Last update date. | ||
| PAY_BASIS_ID | NUMBER | (9) | Yes | System-generated primary key column. |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
| NAME | VARCHAR2 | (30) | Yes | Name of the pay basis. |
| PAY_BASIS | VARCHAR2 | (30) | Yes | Time basis for recording actual salary values, for example, annual, monthly, hourly. |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPD_DATE
, PAY_BASIS_ID
, BUSINESS_GROUP_ID
, NAME
, PAY_BASIS
FROM APPS.HR_H2PI_PAY_BASES_V;
APPS
PER_PAY_BASES
APPS
HR_H2PI_MAPPING_SETUP
- show dependent code
HR_H2PI_VALIDATE
- show dependent code
|
|
|
|