[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;
APPS
HR_BIS
- show dependent code
HR_GENERAL
- show dependent code
PAY_GRADE_RULES_F
PAY_RATES
PER_GRADES
PER_PAY_BASES
PUBLIC
HRIFV_GRADE_RATES_BG
|
|
|
|