View: PAY_KR_SEP_RESULT_SLIP_V

Product:	PAY - Payroll
Description:	This view returns Result Value of Separation Pay Slip based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_SLIP_V

View Text

SELECT /*+RULE*/ 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
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'H_DATE') HIRING_DATE
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'L_DATE') LEAVING_DATE
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_CHAR(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'WKPD'
, 'WKPD') WORKING_PERIOD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'WKPD_SEP_PAY'
, '_ASG_RUN') WKPD_SEP_PAY
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_1ST_STD') ME_1ST_STD
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_1ST_EDD') ME_1ST_EDD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_1ST_WKD'
, '_ASG_RUN') ME_1ST_WKD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_1ST_SUBJ_AVG'
, '_ASG_RUN') ME_1ST_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_2ND_STD') ME_2ND_STD
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_2ND_EDD') ME_2ND_EDD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_2ND_WKD'
, '_ASG_RUN') ME_2ND_WKD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_2ND_SUBJ_AVG'
, '_ASG_RUN') ME_2ND_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_3RD_STD') ME_3RD_STD
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG'
, 'ME_3RD_EDD') ME_3RD_EDD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_3RD_WKD'
, '_ASG_RUN') ME_3RD_WKD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_3RD_SUBJ_AVG'
, '_ASG_RUN') ME_3RD_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG_ADD'
, 'ME_4TH_STD') ME_4TH_STD
, PAY_KR_REPORT_PKG.GET_RESULT_VALUE_DATE(PAA.ASSIGNMENT_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, 'ME_SUBJ_AVG_ADD'
, 'ME_4TH_EDD') ME_4TH_EDD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_4TH_WKD'
, '_ASG_RUN') ME_4TH_WKD
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ME_4TH_SUBJ_AVG'
, '_ASG_RUN') ME_4TH_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ALR_SUBJ_AVG'
, '_ASG_RUN') ALR_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'YBON_SUBJ_AVG'
, '_ASG_RUN') YBON_SUBJ_AVG
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_ME'
, '_ASG_RUN') AVG_SAL_ME
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_ALR'
, '_ASG_RUN') AVG_SAL_ALR
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY_YBON'
, '_ASG_RUN') AVG_SAL_YBON
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'AVERAGE_SALARY'
, '_ASG_RUN') AVG_SAL
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'SEP_PAY'
, '_ASG_RUN') SEP_PAY
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LMTH_REGULAR_SALARY') LAST_MTH_REGULAR_SALARY
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE NOT EXISTS( SELECT NULL
FROM PAY_RUN_TYPES_F PRT
, PAY_PAYROLL_ACTIONS SPPA
, PAY_ASSIGNMENT_ACTIONS SPAA
, PAY_ACTION_INTERLOCKS PAI
WHERE PAI.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
AND SPAA.ASSIGNMENT_ACTION_ID = PAI.LOCKED_ACTION_ID
AND SPPA.PAYROLL_ACTION_ID = SPAA.PAYROLL_ACTION_ID
AND PRT.RUN_TYPE_ID = SPAA.RUN_TYPE_ID
AND SPPA.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND PRT.RUN_TYPE_NAME LIKE 'SEP%')
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID

Columns