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 860: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));

856: second_digit := substrb(lpad(to_char(trunc(spded_value)),2,'0'),2,1);
857: --
858: --
859: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
860: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
861: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else

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

857: --
858: --
859: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
860: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
861: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));

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

858: --
859: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
860: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
861: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));

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

859: if isdf_employer_c.effective_date < c_st_upd_date_2007 then
860: l_c13 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
861: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
867: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));

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

861: l_c14 := to_char(to_number(isdf_calc_c.nonlife_short_ins_prem),fnd_currency.get_format_mask('JPY',40));
862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
867: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
868: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
869: end if;

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

862: l_c15 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
867: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
868: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
869: end if;
870: --

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

863: l_c16 := to_char(to_number(isdf_calc_c.nonlife_short_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
867: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
868: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
869: end if;
870: --
871: IF isdf_employer_c.effective_date >= c_st_upd_date_2012 then

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

864: else
865: l_c13 := to_char(to_number(isdf_calc_c.earthquake_ins_prem),fnd_currency.get_format_mask('JPY',40));
866: l_c14 := to_char(to_number(isdf_calc_c.nonlife_long_ins_prem),fnd_currency.get_format_mask('JPY',40));
867: l_c15 := to_char(to_number(isdf_calc_c.earthquake_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
868: l_c16 := to_char(to_number(isdf_calc_c.nonlife_long_ins_calc_prem),fnd_currency.get_format_mask('JPY',40));
869: end if;
870: --
871: IF isdf_employer_c.effective_date >= c_st_upd_date_2012 then
872: l_c32 := nvl(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),0);

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

889: '' ||htmlspchar(cnv_str(isdf_employer_c.salary_payer_address)) ||'' ||EOL|| --employer_address
890: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
891: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
892: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
893: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

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

890: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
891: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
892: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
893: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem

Line 895: ''||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

891: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
892: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
893: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem

Line 896: ''||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

892: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
893: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1

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

893: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2

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

894: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL|| --life_pens_ins_prem
895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem

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

895: ''||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
896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem

Line 900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1

896: ''||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
897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem

Line 901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2

897: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem

Line 902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem

898: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1

Line 903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem

899: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2

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

900: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
908: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem

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

901: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
908: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
909: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem

Line 906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1

902: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
908: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
909: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
910: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem

Line 907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2

903: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
904: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
905: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
906: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
907: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
908: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
909: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
910: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
911: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem

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

908: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
909: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
910: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
911: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
912: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
913: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
914: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
915: ''||isdf_employer_c.year ||'';
916: --

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

909: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
910: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
911: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
912: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
913: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
914: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
915: ''||isdf_employer_c.year ||'';
916: --
917: --Parameter support for print Employee No option --

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

910: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
911: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
912: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
913: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
914: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
915: ''||isdf_employer_c.year ||'';
916: --
917: --Parameter support for print Employee No option --
918: --

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

936: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name_kana)||''||cnv_str(isdf_emp_c.first_name_kana)) ||'' ||EOL|| --kana_name
937: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
938: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
939: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
940: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction

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

937: '' ||htmlspchar(cnv_str(isdf_emp_c.last_name)||''||cnv_str(isdf_emp_c.first_name)) ||'' ||EOL|| --name
938: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
939: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
940: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem

Line 942: ''||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

938: '' ||htmlspchar(cnv_str(isdf_emp_c.address)) ||'' ||EOL|| --address
939: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
940: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem

Line 943: ''||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

939: ''||htmlspchar(l_emp_no) ||''||EOL|| -- employee number
940: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1

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

940: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_gen_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_gen_ins_prem
941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2

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

941: '' ||htmlspchar(to_char(to_number(isdf_calc_c.life_pens_ins_prem),fnd_currency.get_format_mask('JPY',40))) ||'' ||EOL|| --life_pens_ins_prem
942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem

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

942: ''||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
943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem

Line 947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1

943: ''||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
944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem

Line 948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2

944: ''||to_char(to_number(isdf_calc_c.life_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_ins_deduction
945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem

Line 949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem

945: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_new_ins_prem
946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1

Line 950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem

946: ''||to_char(to_number(isdf_calc_c.life_gen_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_gen_new_ins_calc_prem
947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2

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

947: ''||to_char(l_c33,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_1
948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
955: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem

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

948: ''||to_char(l_c34,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_gen_total_ded_2
949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
955: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
956: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem

Line 953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1

949: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --care_med_new_ins_prem
950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
955: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
956: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
957: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem

Line 954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2

950: ''||to_char(to_number(isdf_calc_new_c.care_med_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --care_med_new_ins_calc_prem
951: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_new_ins_prem
952: ''||to_char(to_number(isdf_calc_c.life_pens_new_ins_calc_prem),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --life_pens_new_ins_calc_prem
953: ''||to_char(l_c39,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_1
954: ''||to_char(l_c40,fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --life_pens_total_ded_2
955: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
956: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
957: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
958: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem

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

955: ''||l_c13 ||''||EOL|| --nonlife_long_ins_prem
956: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
957: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
958: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
959: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
960: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
961: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit

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

956: ''||l_c14 ||''||EOL|| --nonlife_short_ins_prem
957: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
958: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
959: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
960: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
961: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit

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

957: ''||l_c15 ||''||EOL|| --nonlife_long_ins_calc_prem
958: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
959: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
960: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
961: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit
965: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem

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

958: ''||l_c16 ||''||EOL|| --nonlife_short_ins_calc_prem
959: ''||to_char(to_number(isdf_calc_c.nonlife_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --nonlife_ins_deduction
960: ''||to_char(to_number(isdf_calc_c.social_ins_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --social_ins_deduction
961: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit
965: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
966: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem

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

961: ''||to_char(to_number(isdf_calc_c.mutual_aid_deduction),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --mutual_aid_deduction
962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit
965: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
966: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
967: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
968: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
969: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name

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

962: ''||to_char(to_number(isdf_calc_c.spouse_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --spouse_income
963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit
965: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
966: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
967: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
968: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
969: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
970: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address

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

963: ''||first_digit ||''||EOL|| --first_digit
964: ''||second_digit ||''||EOL|| --second_digit
965: ''||to_char(to_number(isdf_mutual_c.enterprise_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --enterprise_contract_prem
966: ''||to_char(to_number(isdf_mutual_c.pension_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --pension_prem
967: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
968: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
969: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
970: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
971: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income

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

967: ''||to_char(to_number(isdf_mutual_c.disable_sup_contract_prem),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --disable_sup_contract_prem
968: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name_kana)) ||''||EOL|| --sp_full_name_kana
969: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
970: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
971: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
972: ''||isdf_employer_c.year ||''||EOL|| --year
973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc

Line 973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012

969: ''||htmlspchar(cnv_str(isdf_spouse_c.full_name)) ||''||EOL|| --sp_full_name
970: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
971: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
972: ''||isdf_employer_c.year ||''||EOL|| --year
973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc

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

970: ''||htmlspchar(cnv_str(isdf_spouse_c.address)) ||''||EOL|| --sp_address
971: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
972: ''||isdf_employer_c.year ||''||EOL|| --year
973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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 975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc

971: ''||to_char(to_number(isdf_spouse_c.emp_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_emp_income
972: ''||isdf_employer_c.year ||''||EOL|| --year
973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc

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

972: ''||isdf_employer_c.year ||''||EOL|| --year
973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc

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

973: ''||to_char(to_number(isdf_calc_c.spouse_deduction ),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --Spouse Deduction from 2012
974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc

Line 978: '' ||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

974: '' ||to_char(to_number(isdf_calc_c.sp_earned_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income_calc
975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income

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

975: '' ||to_char(to_number(isdf_calc_c.sp_business_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_business_income_calc
976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income

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

976: '' ||to_char(to_number(isdf_calc_c.sp_miscellaneous_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_miscellaneous_income_calc
977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||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 981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc

977: '' ||to_char(to_number(isdf_calc_c.sp_dividend_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_dividend_income_calc
978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income

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

978: '' ||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
979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||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 983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income

979: '' ||to_char(to_number(isdf_calc_c.sp_retirement_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_retirement_income_calc
980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income

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

980: '' ||to_char(to_number(isdf_calc_c.sp_other_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_other_income_calc
981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||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 985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income

981: '' ||to_char(to_number(isdf_calc_c.sp_income_calc),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_income_calc
982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||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 986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp

982: '' ||to_char(to_number(isdf_spouse_inc_c.sp_earned_income),fnd_currency.get_format_mask('JPY',40)) ||'' ||EOL|| --sp_earned_income
983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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 987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income

983: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income
984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income

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

984: ''||to_char(to_number(isdf_spouse_inc_c.sp_business_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_business_income_exp
985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||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 989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income

985: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_miscellaneous_income
986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income

Line 990: ''||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

986: ''||to_char(to_number(isdf_spouse_inc_c.sp_miscellaneous_income_exp),fnd_currency.get_format_mask('JPY',40))||''||EOL|| --sp_misc_income_exp
987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||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 991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income

987: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income
988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
995: ''||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 992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp

988: ''||to_char(to_number(isdf_spouse_inc_c.sp_dividend_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_dividend_income_exp
989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
995: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
996: --

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

989: ''||to_char(to_number(isdf_spouse_inc_c.sp_real_estate_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_real_estate_income
990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
995: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
996: --
997: -- Code to determine the number of pages start.

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

990: ''||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
991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
995: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
996: --
997: -- Code to determine the number of pages start.
998: --

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

991: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income
992: ''||to_char(to_number(isdf_spouse_inc_c.sp_retirement_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_retirement_income_exp
993: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income
994: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp),fnd_currency.get_format_mask('JPY',40)) ||''||EOL|| --sp_other_income_exp
995: ''||to_char(to_number(isdf_spouse_inc_c.sp_other_income_exp_dct),fnd_currency.get_format_mask('JPY',40)) ||''; --sp_include_special_deduction
996: --
997: -- Code to determine the number of pages start.
998: --
999: SELECT count(DISTINCT(action_information_id))

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

1242: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(a))) ||''||EOL; --beneficiary_name_lg1
1243: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(a)))||''||EOL; --beneficiary_relship_lg1
1244: l_xml := l_xml|| ''||l_t131a ||''||EOL; --class_new_old_lg1
1245: l_xml := l_xml|| ''||l_t131b ||''||EOL; --class_new_old_lg1
1246: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(a)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_lg1
1247: --
1248: ELSE
1249: --
1250: l_xml := ''||' '||''||EOL; --ins_company_name_lg1

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

1277: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(b))) ||''||EOL; --beneficiary_name_lg2
1278: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(b)))||''||EOL; --beneficiary_relship_lg2
1279: l_xml := l_xml|| ''||l_t132a ||''||EOL; --class_new_old_lg2
1280: l_xml := l_xml|| ''||l_t132b ||''||EOL; --class_new_old_lg2
1281: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(b)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg2
1282: --
1283: ELSE
1284: --
1285: l_xml := l_xml||'' ||' '||'' ||EOL; --ins_company_name_lg2

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

1312: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(c))) ||''||EOL; --beneficiary_name_lg3
1313: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(c)))||''||EOL; --beneficiary_relship_lg3
1314: l_xml := l_xml|| ''||l_t133a ||''||EOL; --class_new_old_lg3
1315: l_xml := l_xml|| ''||l_t133b ||''||EOL; --class_new_old_lg3
1316: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(c)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg3
1317: --
1318: ELSE
1319: --
1320: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lg3

Line 1352: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(f)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg4

1348: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lg(f))) ||''||EOL; --beneficiary_name_lg4
1349: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lg(f)))||''||EOL; --beneficiary_relship_lg4
1350: l_xml := l_xml|| ''||l_t134a ||''||EOL; --class_new_old_lg4
1351: l_xml := l_xml|| ''||l_t134b ||''||EOL; --class_new_old_lg4
1352: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lg(f)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lg4
1353: --
1354: ELSE
1355: --
1356: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lg4

Line 1377: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lcm(d)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lcm1

1373: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lcm(d))) ||''||EOL; --ins_period_lcm1
1374: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lcm(d))) ||''||EOL; --contractor_name_lcm1
1375: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lcm(d))) ||''||EOL; --beneficiary_name_lcm1
1376: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lcm(d)))||''||EOL; --beneficiary_relship_lcm1
1377: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lcm(d)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lcm1
1378: --
1379: ELSE
1380: --
1381: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lcm1

Line 1400: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lcm(e)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lcm2

1396: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lcm(e))) ||''||EOL; --ins_period_lcm2
1397: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lcm(e))) ||''||EOL; --contractor_name_lcm2
1398: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lcm(e))) ||''||EOL; --beneficiary_name_lcm2
1399: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lcm(e)))||''||EOL; --beneficiary_relship_lcm2
1400: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lcm(e)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lcm2
1401: --
1402: ELSE
1403: --
1404: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lcm2

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

1430: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lp(d))) ||''||EOL; --ins_period_lp1
1431: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lp(d))) ||''||EOL; --contractor_name_lp1
1432: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(d))) ||''||EOL; --beneficiary_name_lp1
1433: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(d)))||''||EOL; --beneficiary_relship_lp1
1434: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(d)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp1
1435: --
1436: ELSE
1437: --
1438: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp1

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

1464: l_xml := l_xml||''||htmlspchar(cnv_str(ins_period_lp(e))) ||''||EOL; --ins_period_lp2
1465: l_xml := l_xml||''||htmlspchar(cnv_str(contractor_name_lp(e))) ||''||EOL; --contractor_name_lp2
1466: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(e))) ||''||EOL; --beneficiary_name_lp2
1467: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(e)))||''||EOL; --beneficiary_relship_lp2
1468: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(e)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp2
1469: --
1470: ELSE
1471: --
1472: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp2

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

1509: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(g))) ||''||EOL; --beneficiary_name_lp1
1510: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(g)))||''||EOL; --beneficiary_relship_lp1
1511: l_xml := l_xml||''||l_t135a ||''||EOL; --class_new_old_lp1
1512: l_xml := l_xml||''||l_t135b ||''||EOL; --class_new_old_lp1
1513: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(g)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp1
1514: --
1515: ELSE
1516: --
1517: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp1

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

1557: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(h))) ||''||EOL; --beneficiary_name_lp2
1558: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(h)))||''||EOL; --beneficiary_relship_lp2
1559: l_xml := l_xml||''||l_t136a ||''||EOL; --class_new_old_lp2
1560: l_xml := l_xml||''||l_t136b ||''||EOL; --class_new_old_lp2
1561: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(h)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp2
1562: --
1563: ELSE
1564: --
1565: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp2

Line 1609: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(j)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp3

1605: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_name_lp(j))) ||''||EOL; --beneficiary_name_lp3
1606: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_lp(j)))||''||EOL; --beneficiary_relship_lp3
1607: l_xml := l_xml||''||l_t137a ||''||EOL; --class_new_old_lp3
1608: l_xml := l_xml||''||l_t137b ||''||EOL; --class_new_old_lp3
1609: l_xml := l_xml||''||htmlspchar(to_char(to_number(annual_prem_lp(j)),fnd_currency.get_format_mask('JPY',40)))||''||EOL; --annual_prem_lp3
1610: --
1611: ELSE
1612: --
1613: l_xml := l_xml||''||' '||''||EOL; --ins_company_name_lp3

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

1659: l_xml := l_xml||'' ||htmlspchar(cnv_str(beneficiary_relship_nl(d)))||'' ||EOL; --beneficiary_relship_nl1
1660: l_xml := l_xml||'' ||htmlspchar(l_t48) ||'' ||EOL; --maturity_repayment_nl1
1661: l_xml := l_xml||''||l_t48a ||''||EOL; --nonlife_ins_term_type_nl1
1662: l_xml := l_xml||''||l_t48b ||''||EOL; --nonlife_ins_term_type_nl1
1663: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(d)), fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl1
1664: --
1665: ELSE
1666: --
1667: l_xml := '' ||' '||'' ||EOL; --ins_company_name_nl1

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

1705: l_xml := l_xml||'' ||htmlspchar(cnv_str(beneficiary_relship_nl(e)))||'' ||EOL; --beneficiary_relship_nl2
1706: l_xml := l_xml||'' ||htmlspchar(l_t56) ||'' ||EOL; --maturity_repayment_nl2
1707: l_xml := l_xml||''||l_t56a ||''||EOL; --nonlife_ins_term_type_nl2
1708: l_xml := l_xml||''||l_t56b ||''||EOL; --nonlife_ins_term_type_nl2
1709: l_xml := l_xml||'' ||htmlspchar(to_char(to_number(annual_prem_nl(e)),fnd_currency.get_format_mask('JPY',40)))||'' ||EOL; --annual_prem_nl2
1710: --
1711: ELSE
1712: --
1713: l_xml := l_xml||'' ||' '||'' ||EOL; --ins_company_name_nl2

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

1729: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(a))) ||''||EOL; --ins_type_s1
1730: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(a))) ||''||EOL; --ins_payee_name_s1
1731: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(a))) ||''||EOL; --debtor_name_s1
1732: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(a)))||''||EOL; --beneficiary_relship_s1
1733: l_xml := l_xml||''||to_char(to_number(annual_prem_s(a)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s1
1734: --
1735: ELSE
1736: --
1737: l_xml := l_xml||''||' '||''||EOL; --ins_type_s1

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

1747: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(b))) ||''||EOL; --ins_type_s2
1748: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(b))) ||''||EOL; --ins_payee_name_s2
1749: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(b))) ||''||EOL; --debtor_name_s2
1750: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(b)))||''||EOL; --beneficiary_relship_s2
1751: l_xml := l_xml||''||to_char(to_number(annual_prem_s(b)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s2
1752: --
1753: ELSE
1754: --
1755: l_xml := l_xml||''||' '||''||EOL; --ins_type_s2

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

1765: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(c))) ||''||EOL; --ins_type_s3
1766: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(c))) ||''||EOL; --ins_payee_name_s3
1767: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(c))) ||''||EOL; --debtor_name_s3
1768: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(c)))||''||EOL; --beneficiary_relship_s3
1769: l_xml := l_xml||''||to_char(to_number(annual_prem_s(c)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s3
1770: --
1771: ELSE
1772: --
1773: l_xml := l_xml||''||' '||''||EOL; --ins_type_s3

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

1784: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(d))) ||''||EOL; --ins_type_s1
1785: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(d))) ||''||EOL; --ins_payee_name_s1
1786: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(d))) ||''||EOL; --debtor_name_s1
1787: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(d)))||''||EOL; --beneficiary_relship_s1
1788: l_xml := l_xml||''||to_char(to_number(annual_prem_s(d)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s1
1789: --
1790: ELSE
1791: --
1792: l_xml := l_xml||''||' '||''||EOL; --ins_type_s1

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

1802: l_xml := l_xml||''||htmlspchar(cnv_str(ins_type_s(e))) ||''||EOL; --ins_type_s2
1803: l_xml := l_xml||''||htmlspchar(cnv_str(ins_payee_name_s(e))) ||''||EOL; --ins_payee_name_s2
1804: l_xml := l_xml||''||htmlspchar(cnv_str(debtor_name_s(e))) ||''||EOL; --debtor_name_s2
1805: l_xml := l_xml||''||htmlspchar(cnv_str(beneficiary_relship_s(e)))||''||EOL; --beneficiary_relship_s2
1806: l_xml := l_xml||''||to_char(to_number(annual_prem_s(e)),fnd_currency.get_format_mask('JPY',40))||''||EOL; --annual_prem_s2
1807: --
1808: ELSE
1809: --
1810: l_xml := l_xml||''||' '||''||EOL; --ins_type_s2