eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_SPR_EFILE_PKG dependencies on FND_NUMBER

Line 462: decode(sign(fnd_number.canonical_to_number(pjit.taxable_income) - to_number(''i_valid_term_taxable_amt'')),1,0,1))) spr_term_valid';

458: pjia.assignment_id,
459: pjia.assignment_action_id,
460: pjia.effective_date,
461: to_number(decode(to_char(pjip.actual_termination_date,''YYYY/MM/DD''),null,0,
462: decode(sign(fnd_number.canonical_to_number(pjit.taxable_income) - to_number(''i_valid_term_taxable_amt'')),1,0,1))) spr_term_valid';
463: --
464: c_proc_arch_from_clause varchar2(32767)
465: := 'pay_payroll_actions ppa,
466: pay_assignment_actions paa,

Line 783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,

779: null itax_org_name_kana,
780: pjia.employer_telephone_number itax_org_phone,
781: pjia.reference_number1 itax_org_serial1,
782: pjia.reference_number2 itax_org_serial2,
783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

Line 784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,

780: pjia.employer_telephone_number itax_org_phone,
781: pjia.reference_number1 itax_org_serial1,
782: pjia.reference_number2 itax_org_serial2,
783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

Line 785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,

781: pjia.reference_number1 itax_org_serial1,
782: pjia.reference_number2 itax_org_serial2,
783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

Line 786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,

782: pjia.reference_number2 itax_org_serial2,
783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

Line 787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

783: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

Line 788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

784: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

Line 789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

785: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

Line 790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

786: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

Line 791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

787: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

Line 792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

788: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

Line 793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

789: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
797: pjio.dependent_spouse_exists_kou,

Line 794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

790: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
797: pjio.dependent_spouse_exists_kou,
798: pjio.dependent_spouse_no_exist_kou,

Line 795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

791: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
797: pjio.dependent_spouse_exists_kou,
798: pjio.dependent_spouse_no_exist_kou,
799: pjio.dependent_spouse_exists_otsu,

Line 796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

792: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
793: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
794: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
795: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
796: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
797: pjio.dependent_spouse_exists_kou,
798: pjio.dependent_spouse_no_exist_kou,
799: pjio.dependent_spouse_exists_otsu,
800: pjio.dependent_spouse_no_exist_otsu,

Line 802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,

798: pjio.dependent_spouse_no_exist_kou,
799: pjio.dependent_spouse_exists_otsu,
800: pjio.dependent_spouse_no_exist_otsu,
801: pjio.aged_spouse_exists,
802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

Line 803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,

799: pjio.dependent_spouse_exists_otsu,
800: pjio.dependent_spouse_no_exist_otsu,
801: pjio.aged_spouse_exists,
802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

Line 804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,

800: pjio.dependent_spouse_no_exist_otsu,
801: pjio.aged_spouse_exists,
802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

Line 805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,

801: pjio.aged_spouse_exists,
802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

Line 806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

802: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

Line 807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

803: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

Line 808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

804: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
812: pjio.husband_exists,

Line 809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

805: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
812: pjio.husband_exists,
813: pjio.minor,

Line 810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

806: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
812: pjio.husband_exists,
813: pjio.minor,
814: pjio.otsu,

Line 811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

807: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
808: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
809: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
810: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
811: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
812: pjio.husband_exists,
813: pjio.minor,
814: pjio.otsu,
815: pjio.special_disabled,

Line 830: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,

826: pjit.prev_job_employer_name_kana,
827: pjit.prev_job_employer_add_kanji prev_job_employer_add,
828: pjit.prev_job_employer_add_kana,
829: pjit.prev_job_foreign_address,
830: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

Line 831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,

827: pjit.prev_job_employer_add_kanji prev_job_employer_add,
828: pjit.prev_job_employer_add_kana,
829: pjit.prev_job_foreign_address,
830: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

Line 832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,

828: pjit.prev_job_employer_add_kana,
829: pjit.prev_job_foreign_address,
830: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

Line 834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

830: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,

Line 835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

831: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,
839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,

Line 836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

832: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
833: null prev_job_termination_date,
834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,
839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,
840: fnd_number.canonical_to_number(pjit.housing_residence_day) hld_residence_date_1_day,

Line 838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,

834: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,
839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,
840: fnd_number.canonical_to_number(pjit.housing_residence_day) hld_residence_date_1_day,
841: null hld_loan_count,
842: null hld_payable_loan,

Line 839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,

835: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,
839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,
840: fnd_number.canonical_to_number(pjit.housing_residence_day) hld_residence_date_1_day,
841: null hld_loan_count,
842: null hld_payable_loan,
843: null hld_loan_type_1,

Line 840: fnd_number.canonical_to_number(pjit.housing_residence_day) hld_residence_date_1_day,

836: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
837: null hld_residence_date_1_date,
838: fnd_number.canonical_to_number(pjit.housing_residence_year) hld_residence_date_1_year,
839: fnd_number.canonical_to_number(pjit.housing_residence_month) hld_residence_date_1_month,
840: fnd_number.canonical_to_number(pjit.housing_residence_day) hld_residence_date_1_day,
841: null hld_loan_count,
842: null hld_payable_loan,
843: null hld_loan_type_1,
844: null hld_loan_balance_1,

Line 961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,

957: null itax_org_name_kana,
958: pjia.employer_telephone_number itax_org_phone,
959: pjia.reference_number1 itax_org_serial1,
960: pjia.reference_number2 itax_org_serial2,
961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

Line 962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,

958: pjia.employer_telephone_number itax_org_phone,
959: pjia.reference_number1 itax_org_serial1,
960: pjia.reference_number2 itax_org_serial2,
961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

Line 963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,

959: pjia.reference_number1 itax_org_serial1,
960: pjia.reference_number2 itax_org_serial2,
961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

Line 964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,

960: pjia.reference_number2 itax_org_serial2,
961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

Line 965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

961: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

Line 966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

962: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

Line 967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

963: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

Line 968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

964: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

Line 969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

965: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

Line 970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

966: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

Line 971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

967: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
975: pjio.dependent_spouse_exists_kou,

Line 972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

968: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
975: pjio.dependent_spouse_exists_kou,
976: pjio.dependent_spouse_no_exist_kou,

Line 973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

969: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
975: pjio.dependent_spouse_exists_kou,
976: pjio.dependent_spouse_no_exist_kou,
977: pjio.dependent_spouse_exists_otsu,

Line 974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

970: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
971: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
972: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
973: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
974: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
975: pjio.dependent_spouse_exists_kou,
976: pjio.dependent_spouse_no_exist_kou,
977: pjio.dependent_spouse_exists_otsu,
978: pjio.dependent_spouse_no_exist_otsu,

Line 980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,

976: pjio.dependent_spouse_no_exist_kou,
977: pjio.dependent_spouse_exists_otsu,
978: pjio.dependent_spouse_no_exist_otsu,
979: pjio.aged_spouse_exists,
980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

Line 981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,

977: pjio.dependent_spouse_exists_otsu,
978: pjio.dependent_spouse_no_exist_otsu,
979: pjio.aged_spouse_exists,
980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

Line 982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,

978: pjio.dependent_spouse_no_exist_otsu,
979: pjio.aged_spouse_exists,
980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

Line 983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,

979: pjio.aged_spouse_exists,
980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

Line 984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

980: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

Line 985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

981: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

Line 986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

982: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
990: pjio.husband_exists,

Line 987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

983: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
990: pjio.husband_exists,
991: pjio.minor,

Line 988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

984: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
990: pjio.husband_exists,
991: pjio.minor,
992: pjio.otsu,

Line 989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

985: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
986: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
987: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
988: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
989: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
990: pjio.husband_exists,
991: pjio.minor,
992: pjio.otsu,
993: pjio.special_disabled,

Line 1008: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,

1004: pjit.prev_job_employer_name_kana,
1005: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1006: pjit.prev_job_employer_add_kana,
1007: pjit.prev_job_foreign_address,
1008: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

Line 1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,

1005: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1006: pjit.prev_job_employer_add_kana,
1007: pjit.prev_job_foreign_address,
1008: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

Line 1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,

1006: pjit.prev_job_employer_add_kana,
1007: pjit.prev_job_foreign_address,
1008: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1014: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

Line 1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

1008: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1014: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1015: pjih.residence_date_1 hld_residence_date_1_date,
1016: null hld_residence_date_1_year,

Line 1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

1009: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1014: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1015: pjih.residence_date_1 hld_residence_date_1_date,
1016: null hld_residence_date_1_year,
1017: null hld_residence_date_1_month,

Line 1014: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

1010: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1011: null prev_job_termination_date,
1012: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1013: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1014: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1015: pjih.residence_date_1 hld_residence_date_1_date,
1016: null hld_residence_date_1_year,
1017: null hld_residence_date_1_month,
1018: null hld_residence_date_1_day,

Line 1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,

1132: null itax_org_name_kana,
1133: pjia.employer_telephone_number itax_org_phone,
1134: pjia.reference_number1 itax_org_serial1,
1135: pjia.reference_number2 itax_org_serial2,
1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

Line 1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,

1133: pjia.employer_telephone_number itax_org_phone,
1134: pjia.reference_number1 itax_org_serial1,
1135: pjia.reference_number2 itax_org_serial2,
1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

Line 1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,

1134: pjia.reference_number1 itax_org_serial1,
1135: pjia.reference_number2 itax_org_serial2,
1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

Line 1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,

1135: pjia.reference_number2 itax_org_serial2,
1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

Line 1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

1136: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

Line 1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

1137: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

Line 1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

1138: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

Line 1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

1139: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

Line 1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

1140: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

Line 1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

1141: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

Line 1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

1142: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1150: pjio.dependent_spouse_exists_kou,

Line 1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

1143: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1150: pjio.dependent_spouse_exists_kou,
1151: pjio.dependent_spouse_no_exist_kou,

Line 1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

1144: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1150: pjio.dependent_spouse_exists_kou,
1151: pjio.dependent_spouse_no_exist_kou,
1152: pjio.dependent_spouse_exists_otsu,

Line 1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

1145: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1146: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1147: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1148: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1149: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1150: pjio.dependent_spouse_exists_kou,
1151: pjio.dependent_spouse_no_exist_kou,
1152: pjio.dependent_spouse_exists_otsu,
1153: pjio.dependent_spouse_no_exist_otsu,

Line 1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,

1151: pjio.dependent_spouse_no_exist_kou,
1152: pjio.dependent_spouse_exists_otsu,
1153: pjio.dependent_spouse_no_exist_otsu,
1154: pjio.aged_spouse_exists,
1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

Line 1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,

1152: pjio.dependent_spouse_exists_otsu,
1153: pjio.dependent_spouse_no_exist_otsu,
1154: pjio.aged_spouse_exists,
1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

Line 1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,

1153: pjio.dependent_spouse_no_exist_otsu,
1154: pjio.aged_spouse_exists,
1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

Line 1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,

1154: pjio.aged_spouse_exists,
1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

Line 1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

1155: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

Line 1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

1156: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

Line 1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

1157: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1165: pjio.husband_exists,

Line 1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

1158: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1165: pjio.husband_exists,
1166: pjio.minor,

Line 1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

1159: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1165: pjio.husband_exists,
1166: pjio.minor,
1167: pjio.otsu,

Line 1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

1160: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1161: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1162: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1163: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1164: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1165: pjio.husband_exists,
1166: pjio.minor,
1167: pjio.otsu,
1168: pjio.special_disabled,

Line 1183: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,

1179: pjit.prev_job_employer_name_kana,
1180: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1181: pjit.prev_job_employer_add_kana,
1182: pjit.prev_job_foreign_address,
1183: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

Line 1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,

1180: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1181: pjit.prev_job_employer_add_kana,
1182: pjit.prev_job_foreign_address,
1183: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

Line 1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,

1181: pjit.prev_job_employer_add_kana,
1182: pjit.prev_job_foreign_address,
1183: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1189: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

Line 1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

1183: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1189: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1190: pjih.residence_date_1 hld_residence_date_1_date,
1191: null hld_residence_date_1_year,

Line 1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

1184: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1189: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1190: pjih.residence_date_1 hld_residence_date_1_date,
1191: null hld_residence_date_1_year,
1192: null hld_residence_date_1_month,

Line 1189: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

1185: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1186: null prev_job_termination_date,
1187: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1188: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1189: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1190: pjih.residence_date_1 hld_residence_date_1_date,
1191: null hld_residence_date_1_year,
1192: null hld_residence_date_1_month,
1193: null hld_residence_date_1_day,

Line 1210: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,

1206: pjio2.wtm_system_desc_kanji wtm_system_desc,
1207: pjio2.wtm_system_desc_kana,
1208: pjio2.wtm_user_desc_kanji wtm_user_desc,
1209: pjio2.wtm_user_desc_kana,
1210: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1211: null new_life_ins_prem,
1212: null old_life_ins_prem,
1213: null new_care_med_prem,
1214: null new_pens_ins_prem';

Line 1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,

1310: null itax_org_name_kana,
1311: pjia.employer_telephone_number itax_org_phone,
1312: pjia.reference_number1 itax_org_serial1,
1313: pjia.reference_number2 itax_org_serial2,
1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

Line 1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,

1311: pjia.employer_telephone_number itax_org_phone,
1312: pjia.reference_number1 itax_org_serial1,
1313: pjia.reference_number2 itax_org_serial2,
1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

Line 1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,

1312: pjia.reference_number1 itax_org_serial1,
1313: pjia.reference_number2 itax_org_serial2,
1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

Line 1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,

1313: pjia.reference_number2 itax_org_serial2,
1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

Line 1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,

1314: fnd_number.canonical_to_number(pjit.taxable_income) taxable_income,
1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

Line 1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,

1315: fnd_number.canonical_to_number(pjit.net_taxable_income) net_taxable_income,
1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

Line 1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,

1316: fnd_number.canonical_to_number(pjit.total_income_exempt) total_income_exempt,
1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

Line 1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,

1317: fnd_number.canonical_to_number(pjit.withholding_itax) withholding_itax,
1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

Line 1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,

1318: fnd_number.canonical_to_number(pjit.spouse_special_exempt) spouse_special_exempt,
1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

Line 1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,

1319: fnd_number.canonical_to_number(pjit.social_insurance_premium) social_insurance_premium,
1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

Line 1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,

1320: fnd_number.canonical_to_number(pjit.mutual_aid_premium) mutual_aid_premium,
1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1328: pjio.dependent_spouse_exists_kou,

Line 1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,

1321: fnd_number.canonical_to_number(pjit.life_insurance_premium_exempt) life_insurance_premium_exempt,
1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1328: pjio.dependent_spouse_exists_kou,
1329: pjio.dependent_spouse_no_exist_kou,

Line 1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,

1322: fnd_number.canonical_to_number(pjit.damage_insurance_premium_exem) damage_insurance_premium_exem,
1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1328: pjio.dependent_spouse_exists_kou,
1329: pjio.dependent_spouse_no_exist_kou,
1330: pjio.dependent_spouse_exists_otsu,

Line 1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,

1323: fnd_number.canonical_to_number(pjit.housing_tax_reduction) housing_tax_reduction,
1324: fnd_number.canonical_to_number(pjit.private_pension_premium) private_pension_premium,
1325: fnd_number.canonical_to_number(pjit.spouse_net_taxable_income) spouse_net_taxable_income,
1326: fnd_number.canonical_to_number(pjit.long_damage_insurance_premium) long_damage_insurance_premium,
1327: fnd_number.canonical_to_number(pjit.disaster_tax_reduction) disaster_tax_reduction,
1328: pjio.dependent_spouse_exists_kou,
1329: pjio.dependent_spouse_no_exist_kou,
1330: pjio.dependent_spouse_exists_otsu,
1331: pjio.dependent_spouse_no_exist_otsu,

Line 1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,

1329: pjio.dependent_spouse_no_exist_kou,
1330: pjio.dependent_spouse_exists_otsu,
1331: pjio.dependent_spouse_no_exist_otsu,
1332: pjio.aged_spouse_exists,
1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

Line 1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,

1330: pjio.dependent_spouse_exists_otsu,
1331: pjio.dependent_spouse_no_exist_otsu,
1332: pjio.aged_spouse_exists,
1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

Line 1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,

1331: pjio.dependent_spouse_no_exist_otsu,
1332: pjio.aged_spouse_exists,
1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

Line 1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,

1332: pjio.aged_spouse_exists,
1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

Line 1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,

1333: fnd_number.canonical_to_number(pjio.num_specifieds_kou) num_specifieds_kou,
1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

Line 1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,

1334: fnd_number.canonical_to_number(pjio.num_specifieds_otsu) num_specifieds_otsu,
1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

Line 1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,

1335: fnd_number.canonical_to_number(pjio.num_aged_parents_partial) num_aged_parents_partial,
1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1343: pjio.husband_exists,

Line 1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,

1336: fnd_number.canonical_to_number(pjio.num_ageds_kou) num_ageds_kou,
1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1343: pjio.husband_exists,
1344: pjio.minor,

Line 1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,

1337: fnd_number.canonical_to_number(pjio.num_ageds_otsu) num_ageds_otsu,
1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1343: pjio.husband_exists,
1344: pjio.minor,
1345: pjio.otsu,

Line 1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,

1338: fnd_number.canonical_to_number(pjio.num_dependents_kou) num_dependents_kou,
1339: fnd_number.canonical_to_number(pjio.num_dependents_otsu) num_dependents_otsu,
1340: fnd_number.canonical_to_number(pjio.num_special_disableds_partial) num_special_disableds_partial,
1341: fnd_number.canonical_to_number(pjio.num_special_disableds) num_special_disableds,
1342: fnd_number.canonical_to_number(pjio.num_disableds) num_disableds,
1343: pjio.husband_exists,
1344: pjio.minor,
1345: pjio.otsu,
1346: pjio.special_disabled,

Line 1361: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,

1357: pjit.prev_job_employer_name_kana,
1358: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1359: pjit.prev_job_employer_add_kana,
1360: pjit.prev_job_foreign_address,
1361: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

Line 1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,

1358: pjit.prev_job_employer_add_kanji prev_job_employer_add,
1359: pjit.prev_job_employer_add_kana,
1360: pjit.prev_job_foreign_address,
1361: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

Line 1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,

1359: pjit.prev_job_employer_add_kana,
1360: pjit.prev_job_foreign_address,
1361: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1367: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

Line 1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,

1361: fnd_number.canonical_to_number(pjit.prev_job_taxable_income) prev_job_taxable_income,
1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1367: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1368: pjih.residence_date_1 hld_residence_date_1_date,
1369: null hld_residence_date_1_year,

Line 1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,

1362: fnd_number.canonical_to_number(pjit.prev_job_itax) prev_job_itax,
1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1367: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1368: pjih.residence_date_1 hld_residence_date_1_date,
1369: null hld_residence_date_1_year,
1370: null hld_residence_date_1_month,

Line 1367: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,

1363: fnd_number.canonical_to_number(pjit.prev_job_si_prem) prev_job_si_prem,
1364: null prev_job_termination_date,
1365: fnd_number.canonical_to_number(pjit.prev_job_termination_year) prev_job_termination_year,
1366: fnd_number.canonical_to_number(pjit.prev_job_termination_month) prev_job_termination_month,
1367: fnd_number.canonical_to_number(pjit.prev_job_termination_day) prev_job_termination_day,
1368: pjih.residence_date_1 hld_residence_date_1_date,
1369: null hld_residence_date_1_year,
1370: null hld_residence_date_1_month,
1371: null hld_residence_date_1_day,

Line 1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,

1384: pjio2.wtm_system_desc_kanji wtm_system_desc,
1385: pjio2.wtm_system_desc_kana,
1386: pjio2.wtm_user_desc_kanji wtm_user_desc,
1387: pjio2.wtm_user_desc_kana,
1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,
1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';

Line 1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,

1385: pjio2.wtm_system_desc_kana,
1386: pjio2.wtm_user_desc_kanji wtm_user_desc,
1387: pjio2.wtm_user_desc_kana,
1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,
1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';
1393: --

Line 1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,

1386: pjio2.wtm_user_desc_kanji wtm_user_desc,
1387: pjio2.wtm_user_desc_kana,
1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,
1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';
1393: --
1394: c_data_arch_from_clause_2012 varchar2(32767)

Line 1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,

1387: pjio2.wtm_user_desc_kana,
1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,
1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';
1393: --
1394: c_data_arch_from_clause_2012 varchar2(32767)
1395: := 'pay_payroll_actions ppa,

Line 1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';

1388: fnd_number.canonical_to_number(pjid.num_junior_deps) num_junior_deps,
1389: fnd_number.canonical_to_number(tax1.new_life_ins_prem) new_life_ins_prem,
1390: fnd_number.canonical_to_number(tax1.old_life_ins_prem) old_life_ins_prem,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';
1393: --
1394: c_data_arch_from_clause_2012 varchar2(32767)
1395: := 'pay_payroll_actions ppa,
1396: pay_assignment_actions paa,

Line 1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));

1733: g_effective_yyyy := to_number(to_char(g_effective_soy,'YYYY'));
1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;
1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);
1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);

Line 1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));

1734: g_business_group_id := l_csr_action.business_group_id;
1735: g_legislation_code := l_csr_action.legislation_code;
1736: g_district_code := pay_core_utils.get_parameter('DISTRICT_CODE',l_csr_action.legislative_parameters);
1737: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID',l_csr_action.legislative_parameters));
1738: g_assignment_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',l_csr_action.legislative_parameters));
1739: --g_request_id := fnd_global.conc_request_id;
1740: g_request_id := l_csr_action.request_id;
1741: g_file_split := pay_core_utils.get_parameter('FILE_SPLIT',l_csr_action.legislative_parameters);
1742: g_use_arch := pay_core_utils.get_parameter('USE_ARCH',l_csr_action.legislative_parameters);