[Home] [Help]
View: PAY_RUN_RESULT_VALUES_V3
Product: | PAY - Payroll |
Description: | Used to show all the result values in a sparse matrix solution. |
Implementation/DBA Data: |
APPS.PAY_RUN_RESULT_VALUES_V3
|
View Text
SELECT PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID
, PAY_RUN_RESULT_PKG.GET_RESULT_VALUE(PRR.RUN_RESULT_ID
, PIV.INPUT_VALUE_ID
, PIV.NAME
, PRR.JURISDICTION_CODE
, PPA.BUSINESS_GROUP_ID ) RESULT_VALUE
FROM PAY_RUN_RESULTS PRR
, PAY_INPUT_VALUES_F PIV
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PRR.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.EFFECTIVE_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
Columns
Name |
RUN_RESULT_ID |
INPUT_VALUE_ID |
RESULT_VALUE |