[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:	HRI.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 Type

A Business Intelligence System view

This view shows all grades and their corresponding grade rates
if the grade does not have grade rates then null values are shown.
The view uses business group security on the grade business group id.

[View Source]

Columns

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

HR_BIS - show dependent code

HR_GENERAL - show dependent code

PAY_GRADE_RULES_F

PAY_RATES

PER_GRADES

PER_PAY_BASES

APPS.HRIFV_GRADE_RATES_BG is not referenced by any database object