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

VIEW: APPS.HRBV_ACCRUAL_PLANS_V

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

View Type

A Business Intelligence System view


Accrual plans (from PAY_ACCRUAL_PLANS table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCRUAL_PLAN_NAME VARCHAR2 (80) Yes Accrual plan name.
ACCRUAL_CATEGORY VARCHAR2 (30) Yes (Lookup code based on lookup type US_PTO_ACCRUAL).
ACCRUAL_CATEGORY_M VARCHAR2 (4000)
(Lookup meaning based on lookup type US_PTO_ACCRUAL).
ACCRUAL_START VARCHAR2 (30)
(Lookup code based on lookup type US_ACCRUAL_START_TYPE).
ACCRUAL_START_M VARCHAR2 (4000)
(Lookup meaning based on lookup type US_ACCRUAL_START_TYPE).
ACCRUAL_UNITS_OF_MEASURE VARCHAR2 (30) Yes (Lookup code based on lookup type HOURS_OR_DAYS).
ACCRUAL_UNITS_OF_MEASURE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type HOURS_OR_DAYS).
INELIGIBLE_PERIOD_LENGTH NUMBER (22)
Period of ineligiblity length.
INELIGIBLE_PERIOD_TYPE VARCHAR2 (30)
(Lookup code based on lookup type PROC_PERIOD_TYPE).
INELIGIBLE_PERIOD_TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PROC_PERIOD_TYPE).
DESCRIPTION VARCHAR2 (240)
Description.
INFORMATION_CATEGORY VARCHAR2 (30)
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 (240)
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 (240)
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.
INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
LEGISLATION_CODE VARCHAR2 (4000)
Legislation code.
ACCRUAL_PLAN_ID NUMBER (9) Yes Primary key for PAY_ACCRUAL_PLANS.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS.
ACCRUAL_PLAN_ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_TYPES.
PTO_INPUT_VALUE_ID NUMBER (9)
Foreign key to PAY_INPUT_VALUES.
CO_FORMULA_ID NUMBER (9)
Foreign key to FF_FORMULAS_F.
CO_INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES.
CO_DATE_INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES_F.
CO_EXP_DATE_INPUT_VALUE_ID NUMBER (9)
Foreign key to PAY_INPUT_VALUES_F.
RESIDUAL_INPUT_VALUE_ID NUMBER (9) Yes Residual Input Value Id.
RESIDUAL_DATE_INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES_F.
ACCRUAL_FORMULA_ID NUMBER (9)
Foreign key to FF_FORMULAS_F.
INELIGIBILITY_FORMULA_ID NUMBER (9)
Foreign key to FF_FORMULAS_F.
PAYROLL_FORMULA_ID NUMBER (15)
Foreign key to FF_FORMULAS_F.
DEFINED_BALANCE_ID NUMBER (15)
Foreign key to PAY_DEFINED_BALANCES.
TAGGING_ELEMENT_TYPE_ID NUMBER (15)
Foreign key to PAY_ELEMENT_TYPES.
BALANCE_ELEMENT_TYPE_ID NUMBER (15)
Foreign key to PAY_ELEMENT_TYPES.
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 ACCRUAL_PLAN_NAME
,      ACCRUAL_CATEGORY
,      ACCRUAL_CATEGORY_M
,      ACCRUAL_START
,      ACCRUAL_START_M
,      ACCRUAL_UNITS_OF_MEASURE
,      ACCRUAL_UNITS_OF_MEASURE_M
,      INELIGIBLE_PERIOD_LENGTH
,      INELIGIBLE_PERIOD_TYPE
,      INELIGIBLE_PERIOD_TYPE_M
,      DESCRIPTION
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      LEGISLATION_CODE
,      ACCRUAL_PLAN_ID
,      BUSINESS_GROUP_ID
,      ACCRUAL_PLAN_ELEMENT_TYPE_ID
,      PTO_INPUT_VALUE_ID
,      CO_FORMULA_ID
,      CO_INPUT_VALUE_ID
,      CO_DATE_INPUT_VALUE_ID
,      CO_EXP_DATE_INPUT_VALUE_ID
,      RESIDUAL_INPUT_VALUE_ID
,      RESIDUAL_DATE_INPUT_VALUE_ID
,      ACCRUAL_FORMULA_ID
,      INELIGIBILITY_FORMULA_ID
,      PAYROLL_FORMULA_ID
,      DEFINED_BALANCE_ID
,      TAGGING_ELEMENT_TYPE_ID
,      BALANCE_ELEMENT_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ACCRUAL_PLANS_V;

Dependencies

[top of page]

APPS.HRBV_ACCRUAL_PLANS_V references the following:

SchemaAPPS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_BIS - show dependent code
SynonymPAY_ACCRUAL_PLANS

APPS.HRBV_ACCRUAL_PLANS_V is not referenced by any database object