[Home] [Help]
View: PAY_KR_SEP_RESULT_RRV_V
Product: | PAY - Payroll |
Description: | This view returns Result Value of Separation Pay Process based on both assignment_action_id and run_result_id. |
Implementation/DBA Data: |
APPS.PAY_KR_SEP_RESULT_RRV_V
|
View Text
SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PPA.EFFECTIVE_DATE EFFECTIVE_DATE
, PPA.DATE_EARNED DATE_EARNED
, PAA.RUN_TYPE_ID RUN_TYPE_ID
, PRR.RUN_RESULT_ID RUN_RESULT_ID
, PIV.INPUT_VALUE_ID INPUT_VALUE_ID
, PIV.NAME NAME
, PIV.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
, PIV.HOT_DEFAULT_FLAG HOT_DEFAULT_FLAG
, PIV.DEFAULT_VALUE IDEFAULT_VALUE
, PIV.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, PIVT.NAME UNAME
, PRRV.RESULT_VALUE RESULT_VALUE
FROM PAY_INPUT_VALUES_F_TL PIVT
, PAY_INPUT_VALUES_F PIV
, PAY_RUN_RESULT_VALUES PRRV
, PAY_RUN_RESULTS PRR
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PRR.ASSIGNMENT_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND PRRV.RUN_RESULT_ID = PRR.RUN_RESULT_ID
AND PIV.INPUT_VALUE_ID = PRRV.INPUT_VALUE_ID
AND PPA.DATE_EARNED BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND PIVT.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIVT.LANGUAGE = USERENV('LANG')
Columns
Name |
ASSIGNMENT_ACTION_ID |
ASSIGNMENT_ID |
EFFECTIVE_DATE |
DATE_EARNED |
RUN_TYPE_ID |
RUN_RESULT_ID |
INPUT_VALUE_ID |
NAME |
DISPLAY_SEQUENCE |
HOT_DEFAULT_FLAG |
IDEFAULT_VALUE |
ELEMENT_TYPE_ID |
UNAME |
RESULT_VALUE |