DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRIFV_GRADE_RATES_BG

Object Details
Object Name: HRIFV_GRADE_RATES_BG
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHRI.HRIFV_GRADE_RATES_BG
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.HRIFV_GRADE_RATES_BG references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPAY_GRADE_RULES_F
SynonymPAY_RATES
SynonymPER_GRADES
SynonymPER_PAY_BASES
APPS.HRIFV_GRADE_RATES_BG is referenced by following:

SchemaPUBLIC
SynonymHRIFV_GRADE_RATES_BG