VIEW: APPS.PAY_KR_SEP_TAX_V

Source

View Text - Preformatted

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_eligible_for_ptax, 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, sep.sep_pay_overseas_tax_break, sep.non_stat_sep_overseas_tax_brk, sep.stat_sep_pay_post_tax_deduc, sep.non_stat_sep_post_tax_deduc 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)

View Text - HTML Formatted

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_ELIGIBLE_FOR_PTAX
, 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
, SEP.SEP_PAY_OVERSEAS_TAX_BREAK
, SEP.NON_STAT_SEP_OVERSEAS_TAX_BRK
, SEP.STAT_SEP_PAY_POST_TAX_DEDUC
, SEP.NON_STAT_SEP_POST_TAX_DEDUC
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)