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

VIEW: APPS.HRBV_PAY_BASES_V

Object Details
Object Name: HRBV_PAY_BASES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Pay bases (from PER_PAY_BASES table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Yes Pay base name.
PAY_BASIS VARCHAR2 (30) Yes (Lookup code based on lookup type PAY_BASIS).
PAY_BASIS_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PAY_BASIS).
COMMENTS CLOB (4000)
Comments.
RATE_BASIS VARCHAR2 (30)
(Lookup code based on lookup type RATE_BASIS).
RATE_BASIS_M VARCHAR2 (4000)
(Lookup meaning based on lookup type RATE_BASIS).
ANNUALIZED_HOURS NUMBER

Annualized hours.
PAY_ANNUALIZATION_FACTOR NUMBER

Pay annualization factor.
GRADE_ANNUALIZATION_FACTOR NUMBER

Grade annualization factor.
INFORMATION_CATEGORY VARCHAR2 (150)
Information category.
INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
_DF:PPB CHAR (25)
PAY_BASIS_ID NUMBER (9) Yes Primary key for PER_PAY_BASES.
INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES_F.
RATE_ID NUMBER (15)
Foreign key to PAY_RATES.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
BG_SECURITY_FLAG_CODE CHAR (1)
Business group security flag code.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      PAY_BASIS
,      PAY_BASIS_M
,      COMMENTS
,      RATE_BASIS
,      RATE_BASIS_M
,      ANNUALIZED_HOURS
,      PAY_ANNUALIZATION_FACTOR
,      GRADE_ANNUALIZATION_FACTOR
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      _DF:PPB
,      PAY_BASIS_ID
,      INPUT_VALUE_ID
,      RATE_ID
,      BUSINESS_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_PAY_BASES_V;

Dependencies

[top of page]

APPS.HRBV_PAY_BASES_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_PAY_BASES

APPS.HRBV_PAY_BASES_V is not referenced by any database object