[Home] [Help] [Dependency Information]
Object Name: | HRIFV_GRADE_RATES_BG |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HRIFV_GRADE_RATES_BG |
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 |
---|---|---|---|---|
GRADE_NAME | VARCHAR2 | (240) | ||
GRADE_DATE_FROM | DATE | Yes | ||
GRADE_DATE_TO | DATE | |||
GRADE_RULE_START_DATE | DATE | |||
GRADE_RULE_END_DATE | DATE | |||
GRADE_RATE_NAME | VARCHAR2 | (80) | ||
UNIT_OF_MEASURE | VARCHAR2 | (4000) | ||
GRADE_MAXIMUM | VARCHAR2 | (20) | ||
GRADE_MID_VALUE | VARCHAR2 | (20) | ||
GRADE_MINIMUM | VARCHAR2 | (20) | ||
GRADE_RATE_VALUE | VARCHAR2 | (20) | ||
GRADE_ANNUALIZATION_FACTOR | NUMBER | |||
PAY_BASIS_NAME | VARCHAR2 | (30) | Yes | |
_DF | CHAR | (21) | ||
GRADE_RULE_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | Yes | |
GRADE_DEFINITION_ID | NUMBER | (15) | Yes | |
GRADE_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_RATE_ID | NUMBER | (15) | ||
GRADE_OR_SPINAL_POINT_ID | NUMBER | (15) | ||
PAY_BASIS_ID | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT GRADE_NAME
, GRADE_DATE_FROM
, GRADE_DATE_TO
, GRADE_RULE_START_DATE
, GRADE_RULE_END_DATE
, GRADE_RATE_NAME
, UNIT_OF_MEASURE
, GRADE_MAXIMUM
, GRADE_MID_VALUE
, GRADE_MINIMUM
, GRADE_RATE_VALUE
, GRADE_ANNUALIZATION_FACTOR
, PAY_BASIS_NAME
, _DF
, GRADE_RULE_ID
, GRADE_ID
, GRADE_DEFINITION_ID
, GRADE_BUSINESS_GROUP_ID
, GRADE_RATE_ID
, GRADE_OR_SPINAL_POINT_ID
, PAY_BASIS_ID
FROM APPS.HRIFV_GRADE_RATES_BG;
|
|
|