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.BEN_RECN_REP dependencies on STANDARD

Line 790: l_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';

786: l_report(l_grp_header_pos).col3 := 'Payroll';
787: l_report(l_grp_header_pos).col4 := 'Coverage';
788: l_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
789: l_report(l_grp_header_pos).col6 := 'Payroll Frequency';
790: l_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
791: l_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
792: l_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
793: l_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
794: l_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';

Line 791: l_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';

787: l_report(l_grp_header_pos).col4 := 'Coverage';
788: l_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
789: l_report(l_grp_header_pos).col6 := 'Payroll Frequency';
790: l_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
791: l_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
792: l_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
793: l_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
794: l_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
795: l_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';

Line 792: l_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';

788: l_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
789: l_report(l_grp_header_pos).col6 := 'Payroll Frequency';
790: l_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
791: l_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
792: l_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
793: l_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
794: l_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
795: l_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';
796: l_report(l_grp_header_pos).col13 := 'Element Entry(per pay period) Employer Contribtion';

Line 793: l_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';

789: l_report(l_grp_header_pos).col6 := 'Payroll Frequency';
790: l_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
791: l_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
792: l_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
793: l_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
794: l_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
795: l_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';
796: l_report(l_grp_header_pos).col13 := 'Element Entry(per pay period) Employer Contribtion';
797: l_report(l_grp_header_pos).col14 := 'Element Entry(per pay period) Actual Total Contributions';

Line 817: l_report(l_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val_tot ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

813: l_report(l_rec_pointer).col3 := l_plan_recn.pl_pay_name ; -- 'Payroll'
814: l_report(l_rec_pointer).col4 := l_plan_recn.pl_bnft_amt ; -- 'Coverage'
815: l_report(l_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
816: l_report(l_rec_pointer).col6 := l_plan_recn.pl_perd_typ ; -- 'Payroll Frequency'
817: l_report(l_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val_tot ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
818: l_report(l_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val_tot ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
819: l_report(l_rec_pointer).col9 := l_plan_recn.er_rt_val_tot ; -- 'Standard Rate Amounts Employer Contribution'
820: l_report(l_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
821: l_report(l_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 818: l_report(l_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val_tot ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

814: l_report(l_rec_pointer).col4 := l_plan_recn.pl_bnft_amt ; -- 'Coverage'
815: l_report(l_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
816: l_report(l_rec_pointer).col6 := l_plan_recn.pl_perd_typ ; -- 'Payroll Frequency'
817: l_report(l_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val_tot ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
818: l_report(l_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val_tot ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
819: l_report(l_rec_pointer).col9 := l_plan_recn.er_rt_val_tot ; -- 'Standard Rate Amounts Employer Contribution'
820: l_report(l_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
821: l_report(l_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
822: l_report(l_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 819: l_report(l_rec_pointer).col9 := l_plan_recn.er_rt_val_tot ; -- 'Standard Rate Amounts Employer Contribution'

815: l_report(l_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
816: l_report(l_rec_pointer).col6 := l_plan_recn.pl_perd_typ ; -- 'Payroll Frequency'
817: l_report(l_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val_tot ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
818: l_report(l_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val_tot ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
819: l_report(l_rec_pointer).col9 := l_plan_recn.er_rt_val_tot ; -- 'Standard Rate Amounts Employer Contribution'
820: l_report(l_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
821: l_report(l_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
822: l_report(l_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
823: l_report(l_rec_pointer).col13 := l_plan_recn.er_elem_val_tot; -- 'Element Entry(per pay period) Employer Contribtion'

Line 820: l_report(l_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'

816: l_report(l_rec_pointer).col6 := l_plan_recn.pl_perd_typ ; -- 'Payroll Frequency'
817: l_report(l_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val_tot ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
818: l_report(l_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val_tot ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
819: l_report(l_rec_pointer).col9 := l_plan_recn.er_rt_val_tot ; -- 'Standard Rate Amounts Employer Contribution'
820: l_report(l_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
821: l_report(l_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
822: l_report(l_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val_tot ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
823: l_report(l_rec_pointer).col13 := l_plan_recn.er_elem_val_tot; -- 'Element Entry(per pay period) Employer Contribtion'
824: l_report(l_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 829: l_report(l_rec_pointer).col15 := 'Standard Rate and Premium';

825:
826: -- discrepency
827: if l_report(l_rec_pointer).col10 <> l_report(l_rec_pointer).col14 and
828: l_report(l_rec_pointer).col14 <> l_report(l_rec_pointer).col5 then
829: l_report(l_rec_pointer).col15 := 'Standard Rate and Premium';
830: elsif l_report(l_rec_pointer).col10 <> l_report(l_rec_pointer).col14 then
831: l_report(l_rec_pointer).col15 := 'Standard Rate';
832: elsif l_report(l_rec_pointer).col14 <> l_report(l_rec_pointer).col5 then
833: l_report(l_rec_pointer).col15 := 'Premium';

Line 831: l_report(l_rec_pointer).col15 := 'Standard Rate';

827: if l_report(l_rec_pointer).col10 <> l_report(l_rec_pointer).col14 and
828: l_report(l_rec_pointer).col14 <> l_report(l_rec_pointer).col5 then
829: l_report(l_rec_pointer).col15 := 'Standard Rate and Premium';
830: elsif l_report(l_rec_pointer).col10 <> l_report(l_rec_pointer).col14 then
831: l_report(l_rec_pointer).col15 := 'Standard Rate';
832: elsif l_report(l_rec_pointer).col14 <> l_report(l_rec_pointer).col5 then
833: l_report(l_rec_pointer).col15 := 'Premium';
834: end if;
835: --

Line 838: l_total_record.col7 := nvl(l_total_record.col7 ,0) + nvl(l_plan_recn.ee_ptax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

834: end if;
835: --
836: l_total_record.col1 := 'Total:'; -- 'Total'
837: l_total_record.col5 := nvl(l_total_record.col5 ,0) + nvl(l_plan_recn.pl_prem_val,0) ; -- 'Participant Monthly Premium'
838: l_total_record.col7 := nvl(l_total_record.col7 ,0) + nvl(l_plan_recn.ee_ptax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
839: l_total_record.col8 := nvl(l_total_record.col8 ,0) + nvl(l_plan_recn.ee_atax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
840: l_total_record.col9 := nvl(l_total_record.col9 ,0) + nvl(l_plan_recn.er_rt_val_tot,0) ; -- 'Standard Rate Amounts Employer Contribution'
841: l_total_record.col10 := nvl(l_total_record.col10,0) + nvl(l_plan_recn.pay_perd_total,0) ; -- 'Standard Rate Amounts Pay Period Total'
842: l_total_record.col11 := nvl(l_total_record.col11,0) + nvl(l_plan_recn.ee_ptax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 839: l_total_record.col8 := nvl(l_total_record.col8 ,0) + nvl(l_plan_recn.ee_atax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

835: --
836: l_total_record.col1 := 'Total:'; -- 'Total'
837: l_total_record.col5 := nvl(l_total_record.col5 ,0) + nvl(l_plan_recn.pl_prem_val,0) ; -- 'Participant Monthly Premium'
838: l_total_record.col7 := nvl(l_total_record.col7 ,0) + nvl(l_plan_recn.ee_ptax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
839: l_total_record.col8 := nvl(l_total_record.col8 ,0) + nvl(l_plan_recn.ee_atax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
840: l_total_record.col9 := nvl(l_total_record.col9 ,0) + nvl(l_plan_recn.er_rt_val_tot,0) ; -- 'Standard Rate Amounts Employer Contribution'
841: l_total_record.col10 := nvl(l_total_record.col10,0) + nvl(l_plan_recn.pay_perd_total,0) ; -- 'Standard Rate Amounts Pay Period Total'
842: l_total_record.col11 := nvl(l_total_record.col11,0) + nvl(l_plan_recn.ee_ptax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
843: l_total_record.col12 := nvl(l_total_record.col12,0) + nvl(l_plan_recn.ee_atax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 840: l_total_record.col9 := nvl(l_total_record.col9 ,0) + nvl(l_plan_recn.er_rt_val_tot,0) ; -- 'Standard Rate Amounts Employer Contribution'

836: l_total_record.col1 := 'Total:'; -- 'Total'
837: l_total_record.col5 := nvl(l_total_record.col5 ,0) + nvl(l_plan_recn.pl_prem_val,0) ; -- 'Participant Monthly Premium'
838: l_total_record.col7 := nvl(l_total_record.col7 ,0) + nvl(l_plan_recn.ee_ptax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
839: l_total_record.col8 := nvl(l_total_record.col8 ,0) + nvl(l_plan_recn.ee_atax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
840: l_total_record.col9 := nvl(l_total_record.col9 ,0) + nvl(l_plan_recn.er_rt_val_tot,0) ; -- 'Standard Rate Amounts Employer Contribution'
841: l_total_record.col10 := nvl(l_total_record.col10,0) + nvl(l_plan_recn.pay_perd_total,0) ; -- 'Standard Rate Amounts Pay Period Total'
842: l_total_record.col11 := nvl(l_total_record.col11,0) + nvl(l_plan_recn.ee_ptax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
843: l_total_record.col12 := nvl(l_total_record.col12,0) + nvl(l_plan_recn.ee_atax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
844: l_total_record.col13 := nvl(l_total_record.col13,0) + nvl(l_plan_recn.er_elem_val_tot,0); -- 'Element Entry(per pay period) Employer Contribtion'

Line 841: l_total_record.col10 := nvl(l_total_record.col10,0) + nvl(l_plan_recn.pay_perd_total,0) ; -- 'Standard Rate Amounts Pay Period Total'

837: l_total_record.col5 := nvl(l_total_record.col5 ,0) + nvl(l_plan_recn.pl_prem_val,0) ; -- 'Participant Monthly Premium'
838: l_total_record.col7 := nvl(l_total_record.col7 ,0) + nvl(l_plan_recn.ee_ptax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
839: l_total_record.col8 := nvl(l_total_record.col8 ,0) + nvl(l_plan_recn.ee_atax_rt_val_tot,0) ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
840: l_total_record.col9 := nvl(l_total_record.col9 ,0) + nvl(l_plan_recn.er_rt_val_tot,0) ; -- 'Standard Rate Amounts Employer Contribution'
841: l_total_record.col10 := nvl(l_total_record.col10,0) + nvl(l_plan_recn.pay_perd_total,0) ; -- 'Standard Rate Amounts Pay Period Total'
842: l_total_record.col11 := nvl(l_total_record.col11,0) + nvl(l_plan_recn.ee_ptax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
843: l_total_record.col12 := nvl(l_total_record.col12,0) + nvl(l_plan_recn.ee_atax_elem_val_tot,0) ; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
844: l_total_record.col13 := nvl(l_total_record.col13,0) + nvl(l_plan_recn.er_elem_val_tot,0); -- 'Element Entry(per pay period) Employer Contribtion'
845: l_total_record.col14 := nvl(l_total_record.col14,0) + nvl(l_plan_recn.actual_total,0) ; -- 'Element Entry(per pay period) Actual Total Contribu

Line 868: l_report(l_loop_count).col7 := to_char(to_number(l_report(l_loop_count).col7 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

864: if l_format_mask is not null then
865: for l_loop_count in (l_grp_header_pos + 1)..l_report.last loop
866: l_report(l_loop_count).col4 := to_char(to_number(l_report(l_loop_count).col4 ) ,l_format_mask); -- 'Coverage'
867: l_report(l_loop_count).col5 := to_char(to_number(l_report(l_loop_count).col5 ) ,l_format_mask); -- 'Participant Monthly Premium'
868: l_report(l_loop_count).col7 := to_char(to_number(l_report(l_loop_count).col7 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
869: l_report(l_loop_count).col8 := to_char(to_number(l_report(l_loop_count).col8 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Post-Tax Contribution'
870: l_report(l_loop_count).col9 := to_char(to_number(l_report(l_loop_count).col9 ) ,l_format_mask); -- 'Standard Rate Amounts Employer Contribution'
871: l_report(l_loop_count).col10 := to_char(to_number(l_report(l_loop_count).col10) ,l_format_mask); -- 'Standard Rate Amounts Pay Period Total'
872: l_report(l_loop_count).col11 := to_char(to_number(l_report(l_loop_count).col11) ,l_format_mask); -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 869: l_report(l_loop_count).col8 := to_char(to_number(l_report(l_loop_count).col8 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Post-Tax Contribution'

865: for l_loop_count in (l_grp_header_pos + 1)..l_report.last loop
866: l_report(l_loop_count).col4 := to_char(to_number(l_report(l_loop_count).col4 ) ,l_format_mask); -- 'Coverage'
867: l_report(l_loop_count).col5 := to_char(to_number(l_report(l_loop_count).col5 ) ,l_format_mask); -- 'Participant Monthly Premium'
868: l_report(l_loop_count).col7 := to_char(to_number(l_report(l_loop_count).col7 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
869: l_report(l_loop_count).col8 := to_char(to_number(l_report(l_loop_count).col8 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Post-Tax Contribution'
870: l_report(l_loop_count).col9 := to_char(to_number(l_report(l_loop_count).col9 ) ,l_format_mask); -- 'Standard Rate Amounts Employer Contribution'
871: l_report(l_loop_count).col10 := to_char(to_number(l_report(l_loop_count).col10) ,l_format_mask); -- 'Standard Rate Amounts Pay Period Total'
872: l_report(l_loop_count).col11 := to_char(to_number(l_report(l_loop_count).col11) ,l_format_mask); -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
873: l_report(l_loop_count).col12 := to_char(to_number(l_report(l_loop_count).col12) ,l_format_mask); -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 870: l_report(l_loop_count).col9 := to_char(to_number(l_report(l_loop_count).col9 ) ,l_format_mask); -- 'Standard Rate Amounts Employer Contribution'

866: l_report(l_loop_count).col4 := to_char(to_number(l_report(l_loop_count).col4 ) ,l_format_mask); -- 'Coverage'
867: l_report(l_loop_count).col5 := to_char(to_number(l_report(l_loop_count).col5 ) ,l_format_mask); -- 'Participant Monthly Premium'
868: l_report(l_loop_count).col7 := to_char(to_number(l_report(l_loop_count).col7 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
869: l_report(l_loop_count).col8 := to_char(to_number(l_report(l_loop_count).col8 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Post-Tax Contribution'
870: l_report(l_loop_count).col9 := to_char(to_number(l_report(l_loop_count).col9 ) ,l_format_mask); -- 'Standard Rate Amounts Employer Contribution'
871: l_report(l_loop_count).col10 := to_char(to_number(l_report(l_loop_count).col10) ,l_format_mask); -- 'Standard Rate Amounts Pay Period Total'
872: l_report(l_loop_count).col11 := to_char(to_number(l_report(l_loop_count).col11) ,l_format_mask); -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
873: l_report(l_loop_count).col12 := to_char(to_number(l_report(l_loop_count).col12) ,l_format_mask); -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
874: l_report(l_loop_count).col13 := to_char(to_number(l_report(l_loop_count).col13) ,l_format_mask); -- 'Element Entry(per pay period) Employer Contribtion'

Line 871: l_report(l_loop_count).col10 := to_char(to_number(l_report(l_loop_count).col10) ,l_format_mask); -- 'Standard Rate Amounts Pay Period Total'

867: l_report(l_loop_count).col5 := to_char(to_number(l_report(l_loop_count).col5 ) ,l_format_mask); -- 'Participant Monthly Premium'
868: l_report(l_loop_count).col7 := to_char(to_number(l_report(l_loop_count).col7 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
869: l_report(l_loop_count).col8 := to_char(to_number(l_report(l_loop_count).col8 ) ,l_format_mask); -- 'Standard Rate Amounts Employee Post-Tax Contribution'
870: l_report(l_loop_count).col9 := to_char(to_number(l_report(l_loop_count).col9 ) ,l_format_mask); -- 'Standard Rate Amounts Employer Contribution'
871: l_report(l_loop_count).col10 := to_char(to_number(l_report(l_loop_count).col10) ,l_format_mask); -- 'Standard Rate Amounts Pay Period Total'
872: l_report(l_loop_count).col11 := to_char(to_number(l_report(l_loop_count).col11) ,l_format_mask); -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
873: l_report(l_loop_count).col12 := to_char(to_number(l_report(l_loop_count).col12) ,l_format_mask); -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
874: l_report(l_loop_count).col13 := to_char(to_number(l_report(l_loop_count).col13) ,l_format_mask); -- 'Element Entry(per pay period) Employer Contribtion'
875: l_report(l_loop_count).col14 := to_char(to_number(l_report(l_loop_count).col14) ,l_format_mask); -- 'Element Entry(per pay period) Actual Total Contributions'

Line 903: l_disc_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';

899: l_disc_report(l_grp_header_pos).col3 := 'Payroll';
900: l_disc_report(l_grp_header_pos).col4 := 'Coverage';
901: l_disc_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
902: l_disc_report(l_grp_header_pos).col6 := 'Pay Period';
903: l_disc_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
904: l_disc_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
905: l_disc_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
906: l_disc_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
907: l_disc_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';

Line 904: l_disc_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';

900: l_disc_report(l_grp_header_pos).col4 := 'Coverage';
901: l_disc_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
902: l_disc_report(l_grp_header_pos).col6 := 'Pay Period';
903: l_disc_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
904: l_disc_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
905: l_disc_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
906: l_disc_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
907: l_disc_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
908: l_disc_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';

Line 905: l_disc_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';

901: l_disc_report(l_grp_header_pos).col5 := 'Participant Monthly Premium';
902: l_disc_report(l_grp_header_pos).col6 := 'Pay Period';
903: l_disc_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
904: l_disc_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
905: l_disc_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
906: l_disc_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
907: l_disc_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
908: l_disc_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';
909: l_disc_report(l_grp_header_pos).col13 := 'Element Entry(per pay period) Employer Contribtion';

Line 906: l_disc_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';

902: l_disc_report(l_grp_header_pos).col6 := 'Pay Period';
903: l_disc_report(l_grp_header_pos).col7 := 'Standard Rate Amounts Employee Pre-Tax Contribution';
904: l_disc_report(l_grp_header_pos).col8 := 'Standard Rate Amounts Employee Post-Tax Contribution';
905: l_disc_report(l_grp_header_pos).col9 := 'Standard Rate Amounts Employer Contribution';
906: l_disc_report(l_grp_header_pos).col10 := 'Standard Rate Amounts Pay Period Total';
907: l_disc_report(l_grp_header_pos).col11 := 'Element Entry(per pay period) Employee Pre-Tax Contribution';
908: l_disc_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';
909: l_disc_report(l_grp_header_pos).col13 := 'Element Entry(per pay period) Employer Contribtion';
910: l_disc_report(l_grp_header_pos).col14 := 'Element Entry(per pay period) Actual Total Contributions';

Line 912: l_disc_report(l_grp_header_pos).col16 := 'Standard Rate Discrepancy';

908: l_disc_report(l_grp_header_pos).col12 := 'Element Entry(per pay period) Employee Post-Tax Contribution';
909: l_disc_report(l_grp_header_pos).col13 := 'Element Entry(per pay period) Employer Contribtion';
910: l_disc_report(l_grp_header_pos).col14 := 'Element Entry(per pay period) Actual Total Contributions';
911: l_disc_report(l_grp_header_pos).col15 := 'Premium Discrepancy';
912: l_disc_report(l_grp_header_pos).col16 := 'Standard Rate Discrepancy';
913:
914: l_disc_rec_pointer := l_grp_header_pos;
915:
916: for l_plan_recn in c_plan_disc loop

Line 934: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

930: l_disc_report(l_disc_rec_pointer) := l_subtotal_record;
931:
932: -- Report Total
933: l_total_record.col1 := 'Total:';
934: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
935: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
936: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
937: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
938: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 935: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

931:
932: -- Report Total
933: l_total_record.col1 := 'Total:';
934: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
935: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
936: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
937: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
938: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
939: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 936: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'

932: -- Report Total
933: l_total_record.col1 := 'Total:';
934: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
935: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
936: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
937: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
938: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
939: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
940: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'

Line 937: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'

933: l_total_record.col1 := 'Total:';
934: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
935: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
936: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
937: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
938: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
939: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
940: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'
941: l_total_record.col14 := nvl(l_total_record.col14,0) + l_subtotal_record.col14; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 943: l_total_record.col16 := nvl(l_total_record.col16,0) + l_subtotal_record.col16; -- 'Standard Rate Discrepancy'

939: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
940: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'
941: l_total_record.col14 := nvl(l_total_record.col14,0) + l_subtotal_record.col14; -- 'Element Entry(per pay period) Actual Total Contributions'
942: l_total_record.col15 := nvl(l_total_record.col15,0) + l_subtotal_record.col15; -- 'Premium Discrepency'
943: l_total_record.col16 := nvl(l_total_record.col16,0) + l_subtotal_record.col16; -- 'Standard Rate Discrepancy'
944:
945: l_subtotal_record := null;
946: --
947: --

Line 950: l_subtotal_record.col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

946: --
947: --
948: end if;
949: --
950: l_subtotal_record.col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
951: l_subtotal_record.col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
952: l_subtotal_record.col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
953: l_subtotal_record.col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
954: l_subtotal_record.col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 951: l_subtotal_record.col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

947: --
948: end if;
949: --
950: l_subtotal_record.col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
951: l_subtotal_record.col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
952: l_subtotal_record.col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
953: l_subtotal_record.col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
954: l_subtotal_record.col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
955: l_subtotal_record.col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 952: l_subtotal_record.col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'

948: end if;
949: --
950: l_subtotal_record.col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
951: l_subtotal_record.col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
952: l_subtotal_record.col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
953: l_subtotal_record.col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
954: l_subtotal_record.col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
955: l_subtotal_record.col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
956: l_subtotal_record.col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'

Line 953: l_subtotal_record.col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'

949: --
950: l_subtotal_record.col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
951: l_subtotal_record.col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
952: l_subtotal_record.col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
953: l_subtotal_record.col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
954: l_subtotal_record.col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
955: l_subtotal_record.col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
956: l_subtotal_record.col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
957: l_subtotal_record.col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 959: l_subtotal_record.col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'

955: l_subtotal_record.col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
956: l_subtotal_record.col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
957: l_subtotal_record.col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'
958: l_subtotal_record.col15 := l_plan_recn.prem_dis; -- 'Premium Discrepency'
959: l_subtotal_record.col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
960:
961: l_disc_report.extend(1);
962: l_disc_rec_pointer := l_disc_rec_pointer + 1;
963:

Line 970: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

966: l_disc_report(l_disc_rec_pointer).col3 := l_plan_recn.pl_payroll_name; -- 'Payroll'
967: l_disc_report(l_disc_rec_pointer).col4 := l_plan_recn.pl_bnft_amount ; -- 'Coverage'
968: l_disc_report(l_disc_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
969: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
970: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
971: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
972: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
973: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
974: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 971: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

967: l_disc_report(l_disc_rec_pointer).col4 := l_plan_recn.pl_bnft_amount ; -- 'Coverage'
968: l_disc_report(l_disc_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
969: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
970: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
971: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
972: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
973: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
974: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
975: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 972: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'

968: l_disc_report(l_disc_rec_pointer).col5 := l_plan_recn.pl_prem_val ; -- 'Participant Monthly Premium'
969: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
970: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
971: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
972: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
973: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
974: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
975: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
976: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'

Line 973: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'

969: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
970: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
971: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
972: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
973: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
974: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
975: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
976: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
977: l_disc_report(l_disc_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 979: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'

975: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
976: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
977: l_disc_report(l_disc_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'
978: l_disc_report(l_disc_rec_pointer).col15 := l_plan_recn.prem_dis; -- 'Premium Discrepency'
979: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
980: else
981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'
983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'

Line 981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

977: l_disc_report(l_disc_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'
978: l_disc_report(l_disc_rec_pointer).col15 := l_plan_recn.prem_dis; -- 'Premium Discrepency'
979: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
980: else
981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'
983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'
984: l_subtotal_record.col10 := l_subtotal_record.col10 + l_plan_recn.pay_perd_total; -- 'Standard Rate Amounts Pay Period Total'
985: l_subtotal_record.col11 := l_subtotal_record.col11 + l_plan_recn.ee_ptax_elem_val; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'

978: l_disc_report(l_disc_rec_pointer).col15 := l_plan_recn.prem_dis; -- 'Premium Discrepency'
979: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
980: else
981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'
983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'
984: l_subtotal_record.col10 := l_subtotal_record.col10 + l_plan_recn.pay_perd_total; -- 'Standard Rate Amounts Pay Period Total'
985: l_subtotal_record.col11 := l_subtotal_record.col11 + l_plan_recn.ee_ptax_elem_val; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
986: l_subtotal_record.col12 := l_subtotal_record.col12 + l_plan_recn.ee_atax_elem_val; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'

979: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
980: else
981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'
983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'
984: l_subtotal_record.col10 := l_subtotal_record.col10 + l_plan_recn.pay_perd_total; -- 'Standard Rate Amounts Pay Period Total'
985: l_subtotal_record.col11 := l_subtotal_record.col11 + l_plan_recn.ee_ptax_elem_val; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
986: l_subtotal_record.col12 := l_subtotal_record.col12 + l_plan_recn.ee_atax_elem_val; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
987: l_subtotal_record.col13 := l_subtotal_record.col13 + l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'

Line 984: l_subtotal_record.col10 := l_subtotal_record.col10 + l_plan_recn.pay_perd_total; -- 'Standard Rate Amounts Pay Period Total'

980: else
981: l_subtotal_record.col7 := l_subtotal_record.col7 + l_plan_recn.ee_ptax_rt_val; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
982: l_subtotal_record.col8 := l_subtotal_record.col8 + l_plan_recn.ee_atax_rt_val; -- 'Standard Rate Amounts Employee Post-tax Contribution'
983: l_subtotal_record.col9 := l_subtotal_record.col9 + l_plan_recn.er_rt_val; -- 'Standard Rate Amounts Employer Contribution'
984: l_subtotal_record.col10 := l_subtotal_record.col10 + l_plan_recn.pay_perd_total; -- 'Standard Rate Amounts Pay Period Total'
985: l_subtotal_record.col11 := l_subtotal_record.col11 + l_plan_recn.ee_ptax_elem_val; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
986: l_subtotal_record.col12 := l_subtotal_record.col12 + l_plan_recn.ee_atax_elem_val; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
987: l_subtotal_record.col13 := l_subtotal_record.col13 + l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
988: l_subtotal_record.col14 := l_subtotal_record.col14 + l_plan_recn.actual_total; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 990: l_subtotal_record.col16 := l_subtotal_record.col16 + l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'

986: l_subtotal_record.col12 := l_subtotal_record.col12 + l_plan_recn.ee_atax_elem_val; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
987: l_subtotal_record.col13 := l_subtotal_record.col13 + l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
988: l_subtotal_record.col14 := l_subtotal_record.col14 + l_plan_recn.actual_total; -- 'Element Entry(per pay period) Actual Total Contributions'
989: l_subtotal_record.col15 := l_subtotal_record.col15 + l_plan_recn.prem_dis ; -- 'Premium Discrepency'
990: l_subtotal_record.col16 := l_subtotal_record.col16 + l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
991: --
992: l_disc_report.extend(1);
993: l_disc_rec_pointer := l_disc_rec_pointer + 1;
994: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'

Line 995: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

991: --
992: l_disc_report.extend(1);
993: l_disc_rec_pointer := l_disc_rec_pointer + 1;
994: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
995: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
996: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
997: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
998: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
999: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 996: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

992: l_disc_report.extend(1);
993: l_disc_rec_pointer := l_disc_rec_pointer + 1;
994: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
995: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
996: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
997: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
998: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
999: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1000: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 997: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'

993: l_disc_rec_pointer := l_disc_rec_pointer + 1;
994: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
995: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
996: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
997: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
998: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
999: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1000: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1001: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'

Line 998: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'

994: l_disc_report(l_disc_rec_pointer).col6 := l_plan_recn.pl_pay_prd ; -- 'Payroll Period'
995: l_disc_report(l_disc_rec_pointer).col7 := l_plan_recn.ee_ptax_rt_val ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
996: l_disc_report(l_disc_rec_pointer).col8 := l_plan_recn.ee_atax_rt_val ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
997: l_disc_report(l_disc_rec_pointer).col9 := l_plan_recn.er_rt_val ; -- 'Standard Rate Amounts Employer Contribution'
998: l_disc_report(l_disc_rec_pointer).col10 := l_plan_recn.pay_perd_total ; -- 'Standard Rate Amounts Pay Period Total'
999: l_disc_report(l_disc_rec_pointer).col11 := l_plan_recn.ee_ptax_elem_val;-- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1000: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1001: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
1002: l_disc_report(l_disc_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 1004: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'

1000: l_disc_report(l_disc_rec_pointer).col12 := l_plan_recn.ee_atax_elem_val;-- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1001: l_disc_report(l_disc_rec_pointer).col13 := l_plan_recn.er_elem_val; -- 'Element Entry(per pay period) Employer Contribtion'
1002: l_disc_report(l_disc_rec_pointer).col14 := l_plan_recn.actual_total ; -- 'Element Entry(per pay period) Actual Total Contributions'
1003: l_disc_report(l_disc_rec_pointer).col15 := l_plan_recn.prem_dis; -- 'Premium Discrepency'
1004: l_disc_report(l_disc_rec_pointer).col16 := l_plan_recn.std_rt_dis; -- 'Standard Rate Discrepancy'
1005: end if;
1006: end loop;
1007: --
1008: -- subtotal for the last record

Line 1016: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'

1012: l_disc_rec_pointer := l_disc_rec_pointer + 1;
1013:
1014: l_disc_report(l_disc_rec_pointer) := l_subtotal_record;
1015: -- Report Total
1016: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
1017: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
1018: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
1019: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
1020: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 1017: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'

1013:
1014: l_disc_report(l_disc_rec_pointer) := l_subtotal_record;
1015: -- Report Total
1016: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
1017: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
1018: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
1019: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
1020: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1021: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'

Line 1018: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'

1014: l_disc_report(l_disc_rec_pointer) := l_subtotal_record;
1015: -- Report Total
1016: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
1017: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
1018: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
1019: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
1020: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1021: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1022: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'

Line 1019: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'

1015: -- Report Total
1016: l_total_record.col7 := nvl(l_total_record.col7,0) + l_subtotal_record.col7 ; -- 'Standard Rate Amounts Employee Pre-Tax Contribution'
1017: l_total_record.col8 := nvl(l_total_record.col8,0) + l_subtotal_record.col8 ; -- 'Standard Rate Amounts Employee Post-Tax Contribution'
1018: l_total_record.col9 := nvl(l_total_record.col9,0) + l_subtotal_record.col9 ; -- 'Standard Rate Amounts Employer Contribution'
1019: l_total_record.col10 := nvl(l_total_record.col10,0) + l_subtotal_record.col10; -- 'Standard Rate Amounts Pay Period Total'
1020: l_total_record.col11 := nvl(l_total_record.col11,0) + l_subtotal_record.col11; -- 'Element Entry(per pay period) Employee Pre-Tax Contribution'
1021: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1022: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'
1023: l_total_record.col14 := nvl(l_total_record.col14,0) + l_subtotal_record.col14; -- 'Element Entry(per pay period) Actual Total Contributions'

Line 1025: l_total_record.col16 := nvl(l_total_record.col16,0) + l_subtotal_record.col16; -- 'Standard Rate Discrepancy'

1021: l_total_record.col12 := nvl(l_total_record.col12,0) + l_subtotal_record.col12; -- 'Element Entry(per pay period) Employee Post-Tax Contribution'
1022: l_total_record.col13 := nvl(l_total_record.col13,0) + l_subtotal_record.col13; -- 'Element Entry(per pay period) Employer Contribtion'
1023: l_total_record.col14 := nvl(l_total_record.col14,0) + l_subtotal_record.col14; -- 'Element Entry(per pay period) Actual Total Contributions'
1024: l_total_record.col15 := nvl(l_total_record.col15,0) + l_subtotal_record.col15; -- 'Premium Discrepency'
1025: l_total_record.col16 := nvl(l_total_record.col16,0) + l_subtotal_record.col16; -- 'Standard Rate Discrepancy'
1026:
1027: --
1028: l_disc_report.extend(1);
1029: l_disc_rec_pointer := l_disc_rec_pointer + 1;

Line 1045: l_disc_report(l_loop_count).col7 := to_char(to_number(l_disc_report(l_loop_count).col7) ,l_format_mask);-- Standard Rate Amounts Employee Pre-Tax Contribution'

1041: --
1042: for l_loop_count in (l_grp_header_pos + 1)..l_disc_report.last loop
1043: l_disc_report(l_loop_count).col4 := to_char(to_number(l_disc_report(l_loop_count).col4) ,l_format_mask);-- Coverage'
1044: l_disc_report(l_loop_count).col5 := to_char(to_number(l_disc_report(l_loop_count).col5) ,l_format_mask);-- Participant Monthly Premium'
1045: l_disc_report(l_loop_count).col7 := to_char(to_number(l_disc_report(l_loop_count).col7) ,l_format_mask);-- Standard Rate Amounts Employee Pre-Tax Contribution'
1046: l_disc_report(l_loop_count).col8 := to_char(to_number(l_disc_report(l_loop_count).col8) ,l_format_mask);-- Standard Rate Amounts Employee Post-Tax Contribution'
1047: l_disc_report(l_loop_count).col9 := to_char(to_number(l_disc_report(l_loop_count).col9) ,l_format_mask);-- Standard Rate Amounts Employer Contribution'
1048: l_disc_report(l_loop_count).col10 := to_char(to_number(l_disc_report(l_loop_count).col10),l_format_mask);-- Standard Rate Amounts Pay Period Total'
1049: l_disc_report(l_loop_count).col11 := to_char(to_number(l_disc_report(l_loop_count).col11),l_format_mask);-- Element Entry(per pay period) Employee Pre-Tax Contribution'

Line 1046: l_disc_report(l_loop_count).col8 := to_char(to_number(l_disc_report(l_loop_count).col8) ,l_format_mask);-- Standard Rate Amounts Employee Post-Tax Contribution'

1042: for l_loop_count in (l_grp_header_pos + 1)..l_disc_report.last loop
1043: l_disc_report(l_loop_count).col4 := to_char(to_number(l_disc_report(l_loop_count).col4) ,l_format_mask);-- Coverage'
1044: l_disc_report(l_loop_count).col5 := to_char(to_number(l_disc_report(l_loop_count).col5) ,l_format_mask);-- Participant Monthly Premium'
1045: l_disc_report(l_loop_count).col7 := to_char(to_number(l_disc_report(l_loop_count).col7) ,l_format_mask);-- Standard Rate Amounts Employee Pre-Tax Contribution'
1046: l_disc_report(l_loop_count).col8 := to_char(to_number(l_disc_report(l_loop_count).col8) ,l_format_mask);-- Standard Rate Amounts Employee Post-Tax Contribution'
1047: l_disc_report(l_loop_count).col9 := to_char(to_number(l_disc_report(l_loop_count).col9) ,l_format_mask);-- Standard Rate Amounts Employer Contribution'
1048: l_disc_report(l_loop_count).col10 := to_char(to_number(l_disc_report(l_loop_count).col10),l_format_mask);-- Standard Rate Amounts Pay Period Total'
1049: l_disc_report(l_loop_count).col11 := to_char(to_number(l_disc_report(l_loop_count).col11),l_format_mask);-- Element Entry(per pay period) Employee Pre-Tax Contribution'
1050: l_disc_report(l_loop_count).col12 := to_char(to_number(l_disc_report(l_loop_count).col12),l_format_mask);-- Element Entry(per pay period) Employee Post-Tax Contribution'

Line 1047: l_disc_report(l_loop_count).col9 := to_char(to_number(l_disc_report(l_loop_count).col9) ,l_format_mask);-- Standard Rate Amounts Employer Contribution'

1043: l_disc_report(l_loop_count).col4 := to_char(to_number(l_disc_report(l_loop_count).col4) ,l_format_mask);-- Coverage'
1044: l_disc_report(l_loop_count).col5 := to_char(to_number(l_disc_report(l_loop_count).col5) ,l_format_mask);-- Participant Monthly Premium'
1045: l_disc_report(l_loop_count).col7 := to_char(to_number(l_disc_report(l_loop_count).col7) ,l_format_mask);-- Standard Rate Amounts Employee Pre-Tax Contribution'
1046: l_disc_report(l_loop_count).col8 := to_char(to_number(l_disc_report(l_loop_count).col8) ,l_format_mask);-- Standard Rate Amounts Employee Post-Tax Contribution'
1047: l_disc_report(l_loop_count).col9 := to_char(to_number(l_disc_report(l_loop_count).col9) ,l_format_mask);-- Standard Rate Amounts Employer Contribution'
1048: l_disc_report(l_loop_count).col10 := to_char(to_number(l_disc_report(l_loop_count).col10),l_format_mask);-- Standard Rate Amounts Pay Period Total'
1049: l_disc_report(l_loop_count).col11 := to_char(to_number(l_disc_report(l_loop_count).col11),l_format_mask);-- Element Entry(per pay period) Employee Pre-Tax Contribution'
1050: l_disc_report(l_loop_count).col12 := to_char(to_number(l_disc_report(l_loop_count).col12),l_format_mask);-- Element Entry(per pay period) Employee Post-Tax Contribution'
1051: l_disc_report(l_loop_count).col13 := to_char(to_number(l_disc_report(l_loop_count).col13),l_format_mask);-- Element Entry(per pay period) Employer Contribtion'

Line 1048: l_disc_report(l_loop_count).col10 := to_char(to_number(l_disc_report(l_loop_count).col10),l_format_mask);-- Standard Rate Amounts Pay Period Total'

1044: l_disc_report(l_loop_count).col5 := to_char(to_number(l_disc_report(l_loop_count).col5) ,l_format_mask);-- Participant Monthly Premium'
1045: l_disc_report(l_loop_count).col7 := to_char(to_number(l_disc_report(l_loop_count).col7) ,l_format_mask);-- Standard Rate Amounts Employee Pre-Tax Contribution'
1046: l_disc_report(l_loop_count).col8 := to_char(to_number(l_disc_report(l_loop_count).col8) ,l_format_mask);-- Standard Rate Amounts Employee Post-Tax Contribution'
1047: l_disc_report(l_loop_count).col9 := to_char(to_number(l_disc_report(l_loop_count).col9) ,l_format_mask);-- Standard Rate Amounts Employer Contribution'
1048: l_disc_report(l_loop_count).col10 := to_char(to_number(l_disc_report(l_loop_count).col10),l_format_mask);-- Standard Rate Amounts Pay Period Total'
1049: l_disc_report(l_loop_count).col11 := to_char(to_number(l_disc_report(l_loop_count).col11),l_format_mask);-- Element Entry(per pay period) Employee Pre-Tax Contribution'
1050: l_disc_report(l_loop_count).col12 := to_char(to_number(l_disc_report(l_loop_count).col12),l_format_mask);-- Element Entry(per pay period) Employee Post-Tax Contribution'
1051: l_disc_report(l_loop_count).col13 := to_char(to_number(l_disc_report(l_loop_count).col13),l_format_mask);-- Element Entry(per pay period) Employer Contribtion'
1052: l_disc_report(l_loop_count).col14 := to_char(to_number(l_disc_report(l_loop_count).col14),l_format_mask);-- Element Entry(per pay period) Actual Total Contributions'

Line 1054: l_disc_report(l_loop_count).col16 := to_char(to_number(l_disc_report(l_loop_count).col16),l_format_mask);-- Standard Rate Discrepancy'

1050: l_disc_report(l_loop_count).col12 := to_char(to_number(l_disc_report(l_loop_count).col12),l_format_mask);-- Element Entry(per pay period) Employee Post-Tax Contribution'
1051: l_disc_report(l_loop_count).col13 := to_char(to_number(l_disc_report(l_loop_count).col13),l_format_mask);-- Element Entry(per pay period) Employer Contribtion'
1052: l_disc_report(l_loop_count).col14 := to_char(to_number(l_disc_report(l_loop_count).col14),l_format_mask);-- Element Entry(per pay period) Actual Total Contributions'
1053: l_disc_report(l_loop_count).col15 := to_char(to_number(l_disc_report(l_loop_count).col15),l_format_mask);-- Premium Discrepency'
1054: l_disc_report(l_loop_count).col16 := to_char(to_number(l_disc_report(l_loop_count).col16),l_format_mask);-- Standard Rate Discrepancy'
1055: end loop;
1056: --
1057: end if;
1058: --