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_ISDF_RPT dependencies on FND_CURRENCY

Line 772: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));

768: second_digit := substrb(lpad(to_char(trunc(spded_value)),2,'0'),2,1);
769: --
770: --
771: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
772: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else

Line 773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));

769: --
770: --
771: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
772: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));

Line 774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

770: --
771: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
772: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));

Line 775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

771: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
772: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

Line 777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));

773: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
780: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
781: end if;

Line 778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));

774: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
780: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
781: end if;
782: --

Line 779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

775: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
780: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
781: end if;
782: --
783: -- Creating xml string for pages after first page (repeating page for over lines of printing data records)

Line 780: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

776: else
777: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
778: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
779: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
780: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
781: end if;
782: --
783: -- Creating xml string for pages after first page (repeating page for over lines of printing data records)
784: l_common_xml :=

Line 792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem

788: '' ||htmlspchar(cnv_str(isdf_employer_c.salary_payer_address)) ||'' ||EOL|| --employer_address
789: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
790: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
791: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

Line 793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem

789: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
790: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
791: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
797: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem

Line 794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem

790: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
791: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
797: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
798: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem

Line 795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem

791: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
797: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
798: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
799: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem

Line 796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

792: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
793: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
794: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
795: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
796: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
797: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
798: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
799: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
800: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem

Line 801: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction

797: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
798: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
799: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
800: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
801: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
802: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
803: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
804: ''||isdf_employer_c.year ||'';
805: --

Line 802: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction

798: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
799: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
800: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
801: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
802: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
803: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
804: ''||isdf_employer_c.year ||'';
805: --
806: --Parameter support for print Employee No option --

Line 803: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction

799: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
800: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
801: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
802: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
803: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
804: ''||isdf_employer_c.year ||'';
805: --
806: --Parameter support for print Employee No option --
807: --

Line 829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem

825: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
826: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
827: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
828: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

Line 830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem

826: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
827: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
828: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
834: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem

Line 831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem

827: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
828: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
834: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
835: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem

Line 832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem

828: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
834: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
835: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
836: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem

Line 833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

829: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
830: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
831: ''||to_char(to_number(isdf_calc_c.life_gen_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_ins_calc_prem
832: ''||to_char(to_number(isdf_calc_c.life_pens_ins_calc_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_ins_calc_prem
833: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
834: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
835: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
836: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
837: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem

Line 838: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction

834: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
835: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
836: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
837: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
838: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
839: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit

Line 839: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction

835: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
836: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
837: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
838: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
839: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit

Line 840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction

836: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
837: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
838: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
839: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit
844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem

Line 841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income

837: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
838: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
839: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit
844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
845: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem

Line 844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem

840: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit
844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
845: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
846: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
847: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
848: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name

Line 845: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem

841: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit
844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
845: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
846: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
847: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
848: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
849: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address

Line 846: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem

842: ''||first_digit ||''||EOL|| --first_digit
843: ''||second_digit ||''||EOL|| --second_digit
844: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
845: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
846: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
847: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
848: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
849: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income

Line 850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income

846: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
847: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
848: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
849: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
851: ''||isdf_employer_c.year ||''||EOL|| --year
852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc

Line 852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc

848: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
849: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
851: ''||isdf_employer_c.year ||''||EOL|| --year
852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc

Line 853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc

849: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
851: ''||isdf_employer_c.year ||''||EOL|| --year
852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc

Line 854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc

850: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
851: ''||isdf_employer_c.year ||''||EOL|| --year
852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc

Line 855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc

851: ''||isdf_employer_c.year ||''||EOL|| --year
852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc

Line 856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc

852: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income

Line 857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc

853: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income

Line 858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc

854: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp

Line 859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc

855: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income

Line 860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income

856: '' ||to_char(to_number(isdf_calc_c.sp_real_estate_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_real_estate_income_calc
857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp

Line 861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income

857: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income

Line 862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp

858: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp

Line 863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income

859: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income

Line 864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp

860: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp

Line 865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income

861: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income

Line 866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp

862: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp

Line 867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income

863: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income

Line 868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp

864: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp

Line 869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income

865: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction

Line 870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp

866: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
874: --

Line 871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income

867: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
874: --
875: -- Code to determine the number of pages start.

Line 872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp

868: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income_exp
869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
874: --
875: -- Code to determine the number of pages start.
876: --

Line 873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction

869: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
870: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
871: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
872: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
873: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
874: --
875: -- Code to determine the number of pages start.
876: --
877: SELECT count(DISTINCT(action_information_id))

Line 1012: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(a)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_lg1

1008: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lg(a))) ||''||EOL; --ins_period_lg1
1009: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lg(a))) ||''||EOL; --contractor_name_lg1
1010: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(a))) ||''||EOL; --beneficiary_name_lg1
1011: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(a)))||''||EOL; --beneficiary_relship_lg1
1012: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(a)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_lg1
1013: --
1014: ELSE
1015: --
1016: l_xml := ''||' '||''||EOL; --ins_company_name_lg1

Line 1034: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(b)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg2

1030: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lg(b))) ||''||EOL; --ins_period_lg2
1031: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lg(b))) ||''||EOL; --contractor_name_lg2
1032: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(b))) ||''||EOL; --beneficiary_name_lg2
1033: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(b)))||''||EOL; --beneficiary_relship_lg2
1034: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(b)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg2
1035: --
1036: ELSE
1037: --
1038: l_xml := l_xml||'' ||' '||'' ||EOL; --ins_company_name_lg2

Line 1056: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(c)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg3

1052: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lg(c))) ||''||EOL; --ins_period_lg3
1053: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lg(c))) ||''||EOL; --contractor_name_lg3
1054: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(c))) ||''||EOL; --beneficiary_name_lg3
1055: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(c)))||''||EOL; --beneficiary_relship_lg3
1056: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(c)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg3
1057: --
1058: ELSE
1059: --
1060: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lg3

Line 1088: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(d)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp1

1084: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lp(d))) ||''||EOL; --ins_period_lp1
1085: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lp(d))) ||''||EOL; --contractor_name_lp1
1086: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(d))) ||''||EOL; --beneficiary_name_lp1
1087: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(d)))||''||EOL; --beneficiary_relship_lp1
1088: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(d)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp1
1089: --
1090: ELSE
1091: --
1092: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp1

Line 1122: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(e)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp2

1118: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lp(e))) ||''||EOL; --ins_period_lp2
1119: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lp(e))) ||''||EOL; --contractor_name_lp2
1120: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(e))) ||''||EOL; --beneficiary_name_lp2
1121: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(e)))||''||EOL; --beneficiary_relship_lp2
1122: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(e)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp2
1123: --
1124: ELSE
1125: --
1126: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp2

Line 1172: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(d)), fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl1

1168: l_xml := l_xml||'' ||htmlspchar(cnv_str(beneficiary_relship_nl(d)))||'' ||EOL; --beneficiary_relship_nl1
1169: l_xml := l_xml||'' ||htmlspchar(l_t48) ||'' ||EOL; --maturity_repayment_nl1
1170: l_xml := l_xml||''||l_t48a ||''||EOL; --nonlife_ins_term_type_nl1
1171: l_xml := l_xml||''||l_t48b ||''||EOL; --nonlife_ins_term_type_nl1
1172: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(d)), fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl1
1173: --
1174: ELSE
1175: --
1176: l_xml := '' ||' '||'' ||EOL; --ins_company_name_nl1

Line 1218: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(e)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl2

1214: l_xml := l_xml||'' ||htmlspchar(cnv_str(beneficiary_relship_nl(e)))||'' ||EOL; --beneficiary_relship_nl2
1215: l_xml := l_xml||'' ||htmlspchar(l_t56) ||'' ||EOL; --maturity_repayment_nl2
1216: l_xml := l_xml||''||l_t56a ||''||EOL; --nonlife_ins_term_type_nl2
1217: l_xml := l_xml||''||l_t56b ||''||EOL; --nonlife_ins_term_type_nl2
1218: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(e)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl2
1219: --
1220: ELSE
1221: --
1222: l_xml := l_xml||'' ||' '||'' ||EOL; --ins_company_name_nl2

Line 1241: l_xml := l_xml||''||to_char(to_number(annual_prem_s(a)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s1

1237: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(a))) ||''||EOL; --ins_type_s1
1238: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(a))) ||''||EOL; --ins_payee_name_s1
1239: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(a))) ||''||EOL; --debtor_name_s1
1240: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(a)))||''||EOL; --beneficiary_relship_s1
1241: l_xml := l_xml||''||to_char(to_number(annual_prem_s(a)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s1
1242: --
1243: ELSE
1244: --
1245: l_xml := l_xml||''||' '||''||EOL; --ins_type_s1

Line 1259: l_xml := l_xml||''||to_char(to_number(annual_prem_s(b)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s2

1255: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(b))) ||''||EOL; --ins_type_s2
1256: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(b))) ||''||EOL; --ins_payee_name_s2
1257: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(b))) ||''||EOL; --debtor_name_s2
1258: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(b)))||''||EOL; --beneficiary_relship_s2
1259: l_xml := l_xml||''||to_char(to_number(annual_prem_s(b)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s2
1260: --
1261: ELSE
1262: --
1263: l_xml := l_xml||''||' '||''||EOL; --ins_type_s2

Line 1277: l_xml := l_xml||''||to_char(to_number(annual_prem_s(c)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s3

1273: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(c))) ||''||EOL; --ins_type_s3
1274: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(c))) ||''||EOL; --ins_payee_name_s3
1275: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(c))) ||''||EOL; --debtor_name_s3
1276: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(c)))||''||EOL; --beneficiary_relship_s3
1277: l_xml := l_xml||''||to_char(to_number(annual_prem_s(c)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s3
1278: --
1279: ELSE
1280: --
1281: l_xml := l_xml||''||' '||''||EOL; --ins_type_s3