[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 |