[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: |
APPS.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 |