DBA Data[Home] [Help]

APPS.PAY_PAYJPWTM_XMLP_PKG dependencies on FND_NUMBER

Line 359: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TAXABLE_INCOME),

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),

Line 360: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.NET_TAXABLE_INCOME),

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),

Line 361: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.TOTAL_INCOME_EXEMPT),

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),

Line 362: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.WITHHOLDING_ITAX),

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),

Line 363: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_SPECIAL_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),

Line 364: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SOCIAL_INSURANCE_PREMIUM),

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),

Line 365: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.MUTUAL_AID_PREMIUM),

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),

Line 366: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LIFE_INSURANCE_PREMIUM_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),
370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),

Line 367: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DAMAGE_INSURANCE_PREMIUM_EXEM),

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),

Line 368: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_TAX_REDUCTION),

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),

Line 369: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PRIVATE_PENSION_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),
373: OTHER.DEPENDENT_SPOUSE_EXISTS_KOU,

Line 370: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.SPOUSE_NET_TAXABLE_INCOME),

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,

Line 371: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.LONG_DAMAGE_INSURANCE_PREMIUM),

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,

Line 372: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.DISASTER_TAX_REDUCTION),

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,

Line 378: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_KOU),

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),

Line 379: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIFIEDS_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),

Line 380: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGED_PARENTS_PARTIAL),

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),

Line 381: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_KOU),

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),

Line 382: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_AGEDS_OTSU),

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),

Line 383: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_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),
387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),

Line 384: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DEPENDENTS_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),
388: OTHER.HUSBAND_EXISTS,

Line 385: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS_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,
389: OTHER.MINOR,

Line 386: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_SPECIAL_DISABLEDS),

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,

Line 387: FND_NUMBER.CANONICAL_TO_NUMBER(OTHER.NUM_DISABLEDS),

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,

Line 410: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TAXABLE_INCOME),

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),

Line 411: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_ITAX),

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),

Line 412: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_SI_PREM),

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),

Line 413: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_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),

Line 414: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_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),

Line 415: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.PREV_JOB_TERMINATION_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

Line 416: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_YEAR),

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'

Line 417: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_MONTH),

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

Line 418: FND_NUMBER.CANONICAL_TO_NUMBER(TAX.HOUSING_RESIDENCE_DAY),

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)