FND Design Data [Home] [Help]

View: PAYFV_BALANCE_VALUES

Product: PAY - Payroll
Description: copy of the view pay_balance_values_v
Implementation/DBA Data: ViewAPPS.PAYFV_BALANCE_VALUES
View Text

SELECT ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, PAYROLL_ACTION_ID
, EFFECTIVE_DATE
, PAYROLL_ID
, BALANCE_TYPE_ID
, BALANCE_NAME
, BALANCE_DIMENSION_ID
, DIMENSION_NAME
, DATABASE_ITEM_SUFFIX
, DIMENSION_DESCRIPTION
, DEFINED_BALANCE_ID
, ROUTE_ID
, VALUE
, TAX_GROUP
, JURISDICTION
, SOURCE_ID
, BUSINESS_GROUP_ID
FROM PAY_BALANCE_VALUES_V

Columns

Name
ASSIGNMENT_ACTION_ID
ASSIGNMENT_ID
PAYROLL_ACTION_ID
EFFECTIVE_DATE
PAYROLL_ID
BALANCE_TYPE_ID
BALANCE_NAME
BALANCE_DIMENSION_ID
DIMENSION_NAME
DATABASE_ITEM_SUFFIX
DIMENSION_DESCRIPTION
DEFINED_BALANCE_ID
ROUTE_ID
VALUE
TAX_GROUP
JURISDICTION
SOURCE_ID
BUSINESS_GROUP_ID