View: PAY_KR_SEP_TAX_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_KR_SEP_TAX_V

View Text

SELECT SEP.BUSINESS_GROUP_ID
, SEP.PAYROLL_ID
, SEP.ASSIGNMENT_ID
, SEP.ASSIGNMENT_ACTION_ID
, SEP.PAYROLL_ACTION_ID
, SEP.EFFECTIVE_DATE
, SEP.DATE_EARNED
, SEP.XEFFECTIVE_DATE
, SEP.RUN_TYPE_ID
, SEP.RUN_TYPE_NAME
, SEP.TAX_UNIT_ID
, SEP.XASSIGNMENT_ACTION_ID
, SEP.XPAYROLL_ACTION_ID
, SEP.PREV_ELEMENT_ENTRY_ID
, SEP.PREV_BP_NUMBER
, SEP.PREV_BP_NAME
, SEP.PREV_SEP_PAY
, SEP.PREV_SEP_INS
, SEP.PREV_SP_SEP_ALW
, SEP.PREV_SP_NON_TAX_AMT
, SEP.BP_NUMBER
, SEP.CORP_NAME
, SEP.CORP_REPRESENTATIVE_NAME
, SEP.CORP_NUMBER
, SEP.BP_ADDRESS
, SEP.TAX_OFFICE_NAME
, SEP.LAST_NAME
, SEP.FIRST_NAME
, SEP.NATIONAL_IDENTIFIER
, PAY_KR_SEP_FORM_PKG.GET_KR_D_ADDRESS_LINE1(PAD.ADD_INFORMATION17)||' '||PAD.ADDRESS_LINE2 PERSON_ADDRESS
, SEP.NATIONALITY
, SEP.HIRING_DATE
, SEP.LEAVING_DATE
, SEP.PREV_FIRST_HIRING_DATE
, SEP.PREV_LAST_LEAVING_DATE
, SEP.COUNTRY_CODE
, SEP.COUNTRY
, SEP.ACTUAL_TERMINATION_DATE
, SEP.PERSON_ID
FROM PAY_KR_SEP_TAX_WO_ADDR_V SEP
, PER_ADDRESSES PAD
WHERE PAD.PERSON_ID (+) = SEP.PERSON_ID
AND PAD.ADDRESS_TYPE (+) = 'KR_C'
AND PAD.STYLE (+) = 'KR'
AND SEP.EFFECTIVE_DATE BETWEEN PAD.DATE_FROM (+)
AND NVL(PAD.DATE_TO (+)
, SEP.EFFECTIVE_DATE)

Columns