355: ELSE
356: L_YES := '*';
357:
358: SELECT
359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
356: L_YES := '*';
357:
358: SELECT
359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
357:
358: SELECT
359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
358: SELECT
359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_EXEMPT),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),
365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),
373: OTHER.DEPENDENT_SPOUSE_EXISTS_KOU,
366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_EXEMPT),
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),
373: OTHER.DEPENDENT_SPOUSE_EXISTS_KOU,
374: OTHER.DEPENDENT_SPOUSE_NO_EXIST_KOU,
367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),
373: OTHER.DEPENDENT_SPOUSE_EXISTS_KOU,
374: OTHER.DEPENDENT_SPOUSE_NO_EXIST_KOU,
375: OTHER.DEPENDENT_SPOUSE_EXISTS_OTSU,
368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),
369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_PREMIUM),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),
371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),
372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),
373: OTHER.DEPENDENT_SPOUSE_EXISTS_KOU,
374: OTHER.DEPENDENT_SPOUSE_NO_EXIST_KOU,
375: OTHER.DEPENDENT_SPOUSE_EXISTS_OTSU,
376: OTHER.DEPENDENT_SPOUSE_NO_EXIST_OTSU,
374: OTHER.DEPENDENT_SPOUSE_NO_EXIST_KOU,
375: OTHER.DEPENDENT_SPOUSE_EXISTS_OTSU,
376: OTHER.DEPENDENT_SPOUSE_NO_EXIST_OTSU,
377: OTHER.AGED_SPOUSE_EXISTS,
378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
375: OTHER.DEPENDENT_SPOUSE_EXISTS_OTSU,
376: OTHER.DEPENDENT_SPOUSE_NO_EXIST_OTSU,
377: OTHER.AGED_SPOUSE_EXISTS,
378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
376: OTHER.DEPENDENT_SPOUSE_NO_EXIST_OTSU,
377: OTHER.AGED_SPOUSE_EXISTS,
378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
377: OTHER.AGED_SPOUSE_EXISTS,
378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_OTSU),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),
380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),
388: OTHER.HUSBAND_EXISTS,
381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),
388: OTHER.HUSBAND_EXISTS,
389: OTHER.MINOR,
382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),
388: OTHER.HUSBAND_EXISTS,
389: OTHER.MINOR,
390: OTHER.OTSU,
383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_KOU),
384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_OTSU),
385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_PARTIAL),
386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),
388: OTHER.HUSBAND_EXISTS,
389: OTHER.MINOR,
390: OTHER.OTSU,
391: OTHER.SPECIAL_DISABLED,
406: ,'Y'
407: ,TAX.PREV_JOB_EMPLOYER_ADD_KANJI
408: ,TAX.PREV_JOB_EMPLOYER_ADD_KANA),
409: TAX.PREV_JOB_FOREIGN_ADDRESS,
410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
407: ,TAX.PREV_JOB_EMPLOYER_ADD_KANJI
408: ,TAX.PREV_JOB_EMPLOYER_ADD_KANA),
409: TAX.PREV_JOB_FOREIGN_ADDRESS,
410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
408: ,TAX.PREV_JOB_EMPLOYER_ADD_KANA),
409: TAX.PREV_JOB_FOREIGN_ADDRESS,
410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
409: TAX.PREV_JOB_FOREIGN_ADDRESS,
410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),
411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),
419: RTRIM(SUBSTRB(DECODE(P_KANJI_FLAG
412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),
419: RTRIM(SUBSTRB(DECODE(P_KANJI_FLAG
420: ,'Y'
413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_YEAR),
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),
419: RTRIM(SUBSTRB(DECODE(P_KANJI_FLAG
420: ,'Y'
421: ,WTM_SYSTEM_DESC_KANJI
414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_MONTH),
415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_DAY),
416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),
417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),
418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),
419: RTRIM(SUBSTRB(DECODE(P_KANJI_FLAG
420: ,'Y'
421: ,WTM_SYSTEM_DESC_KANJI
422: ,WTM_SYSTEM_DESC_KANA)