VIEW: APPS.PAY_KR_TAX_EXEM_V

Source

View Text - Preformatted

SELECT aei.rowid ROW_ID, aei.assignment_extra_info_id, aei.assignment_id, aei.information_type, aei.aei_information_category, aei.object_version_number, fnd_date.canonical_to_date(aei.aei_information1) EFFECTIVE_DATE, fnd_number.canonical_to_number(aei.aei_information2) NP_PREM, fnd_number.canonical_to_number(aei.aei_information3) PERS_PENSION_PREM, fnd_number.canonical_to_number(aei.aei_information4) PERS_PENSION_SAVING, fnd_number.canonical_to_number(aei.aei_information5) INVEST_PARTNERSHIP_FIN1, fnd_number.canonical_to_number(aei.aei_information6) INVEST_PARTNERSHIP_FIN2, fnd_number.canonical_to_number(aei.aei_information7) CREDIT_CARD_EXP from per_assignment_extra_info aei, fnd_sessions fnd where aei.information_type = 'KR_YEA_TAX_EXEM_INFO' and fnd.session_id = userenv('sessionid') and substr(to_char(fnd.effective_date,'DD-MON-YYYY'),8,4) = substr(aei.aei_information1,1,4)

View Text - HTML Formatted

SELECT AEI.ROWID ROW_ID
, AEI.ASSIGNMENT_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID
, AEI.INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION1) EFFECTIVE_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION2) NP_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION3) PERS_PENSION_PREM
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION4) PERS_PENSION_SAVING
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION5) INVEST_PARTNERSHIP_FIN1
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION6) INVEST_PARTNERSHIP_FIN2
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION7) CREDIT_CARD_EXP
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, FND_SESSIONS FND
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_TAX_EXEM_INFO'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND SUBSTR(TO_CHAR(FND.EFFECTIVE_DATE
, 'DD-MON-YYYY')
, 8
, 4) = SUBSTR(AEI.AEI_INFORMATION1
, 1
, 4)