FND Design Data [Home] [Help]

View: PAYFV_US_BALANCE_VALUES

Product: PAY - Payroll
Description: copy of view pay_us_balance_values_v for BIS team with their naming convention
Implementation/DBA Data: ViewAPPS.PAYFV_US_BALANCE_VALUES
View Text

SELECT ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, PAYROLL_ACTION_ID
, EFFECTIVE_DATE
, BALANCE_TYPE_ID
, BALANCE_NAME
, BALANCE_DIMENSION_ID
, DIMENSION_NAME
, DATABASE_ITEM_SUFFIX
, DIMENSION_DESCRIPTION
, DEFINED_BALANCE_ID
, ROUTE_ID
, VALUE
, JURISDICTION_CODE
, TAX_GROUP
FROM PAY_US_BALANCE_VALUES_V

Columns

Name
ASSIGNMENT_ACTION_ID
ASSIGNMENT_ID
PAYROLL_ACTION_ID
EFFECTIVE_DATE
BALANCE_TYPE_ID
BALANCE_NAME
BALANCE_DIMENSION_ID
DIMENSION_NAME
DATABASE_ITEM_SUFFIX
DIMENSION_DESCRIPTION
DEFINED_BALANCE_ID
ROUTE_ID
VALUE
JURISDICTION_CODE
TAX_GROUP