[Home] [Help] [Dependency Information]
Object Name: | PAY_ZA_BALANCES_MATRIX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_ZA_BALANCES_MATRIX_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
PAY_ZA_BALANCES_MATRIX_V gives you a list of balance dimensions for the appropriate balance per assignment and assignment action ID in a matrix format.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | (10) | Assignment ID | |
BALANCE_NAME | VARCHAR2 | (80) | Balance Name | |
ASG_RUN_BAL | NUMBER | Amount contained in ASG_RUN dimension | ||
ASG_TAX_PTD_BAL | NUMBER | Amount contained in ASG_TAX_PTD dimension | ||
ASG_TAX_MTD_BAL | NUMBER | Amount contained in ASG_TAX_MTD dimension | ||
ASG_TAX_QTD_BAL | NUMBER | Amount contained in ASG_TAX_QTD dimension | ||
ASG_TAX_YTD_BAL | NUMBER | Amount contained in ASG_TAX_YTD dimension | ||
ASG_CAL_YTD_BAL | NUMBER | Amount contained in ASG_CAL_YTD dimension | ||
ASG_ITD_BAL | NUMBER | Amount contained in ASG_ITD dimension | ||
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | Assignment Action ID |
BALANCE_TYPE_ID | NUMBER | (9) | Yes | Balance Type ID |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | Payroll Action ID |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, BALANCE_NAME
, ASG_RUN_BAL
, ASG_TAX_PTD_BAL
, ASG_TAX_MTD_BAL
, ASG_TAX_QTD_BAL
, ASG_TAX_YTD_BAL
, ASG_CAL_YTD_BAL
, ASG_ITD_BAL
, ASSIGNMENT_ACTION_ID
, BALANCE_TYPE_ID
, PAYROLL_ACTION_ID
FROM APPS.PAY_ZA_BALANCES_MATRIX_V;
|
|
|