View: PAY_KR_SEP_RESULT_NET_V

Product:	PAY - Payroll
Description:	This view returns Result Value of Separation Net Pay Process based on assignment_action_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_RESULT_NET_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
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'TOTAL_TAXABLE_EARNINGS'
, '_ASG_RUN') TOTAL_TAXABLE_EARNINGS
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'ITAX'
, '_ASG_RUN') ITAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'RTAX'
, '_ASG_RUN') RTAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'STAX'
, '_ASG_RUN') STAX
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'NP_PREM_FUND_REIMB'
, '_ASG_ITD') NP_PREM_FUND_REIMB
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'NET_PAY'
, '_ASG_RUN') NET_PAY
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'VOL_DEDUCTIONS'
, '_ASG_RUN') VOL_DEDUCTIONS
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'INVOL_DEDUCTIONS'
, '_ASG_RUN') INVOL_DEDUCTIONS
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_ITAX_ADJ') LAST_IYEA_ITAX_ADJ
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_RTAX_ADJ') LAST_IYEA_RTAX_ADJ
, PAY_KR_REPORT_PKG.GET_DBITEM_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'KR_LIYEA_STAX_ADJ') LAST_IYEA_STAX_ADJ
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'HEALTH INS SEP ADJ EMPLOYEE CHARGE'
, '_ASG_YTD') LAST_IHIA_PREM_EE_ADJ
, PAY_KR_REPORT_PKG.GET_BALANCE_VALUE(PAA.ASSIGNMENT_ACTION_ID
, 'HEALTH INS SEP ADJ EMPLOYER CHARGE'
, '_ASG_YTD') LAST_IHIA_PREM_ER_ADJ
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 PRT.RUN_TYPE_NAME <> 'SEP_L')
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID

Columns