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

VIEW: APPS.PER_BF_BALANCES_V

Object Details
Object Name: PER_BF_BALANCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_BF_BALANCES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BALANCE_VALUE_ID NUMBER (15) Yes
BALANCE_TYPE_ID NUMBER (15) Yes
PROCESSED_ASSIGNMENT_ID NUMBER (15) Yes
ASSIGNMENT_ID NUMBER (15) Yes
PAYROLL_RUN_ID NUMBER (15) Yes
PAYROLL_ID NUMBER (9) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
BALANCE_NAME VARCHAR2 (30) Yes
UOM VARCHAR2 (30)
CATEGORY VARCHAR2 (30)
YTD_AMOUNT NUMBER

FYTD_AMOUNT NUMBER

PTD_AMOUNT NUMBER

MTD_AMOUNT NUMBER

QTD_AMOUNT NUMBER

RUN_AMOUNT NUMBER

PAYROLL_IDENTIFIER VARCHAR2 (30) Yes
PERIOD_START_DATE DATE

PERIOD_END_DATE DATE

PROCESSING_DATE DATE

Query Text

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


SELECT BALANCE_VALUE_ID
,      BALANCE_TYPE_ID
,      PROCESSED_ASSIGNMENT_ID
,      ASSIGNMENT_ID
,      PAYROLL_RUN_ID
,      PAYROLL_ID
,      BUSINESS_GROUP_ID
,      BALANCE_NAME
,      UOM
,      CATEGORY
,      YTD_AMOUNT
,      FYTD_AMOUNT
,      PTD_AMOUNT
,      MTD_AMOUNT
,      QTD_AMOUNT
,      RUN_AMOUNT
,      PAYROLL_IDENTIFIER
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      PROCESSING_DATE
FROM APPS.PER_BF_BALANCES_V;

Dependencies

[top of page]

APPS.PER_BF_BALANCES_V references the following:

SchemaAPPS
SynonymPER_BF_BALANCE_AMOUNTS
SynonymPER_BF_BALANCE_TYPES
SynonymPER_BF_PAYROLL_RUNS
SynonymPER_BF_PROCESSED_ASSIGNMENTS

APPS.PER_BF_BALANCES_V is not referenced by any database object