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_IE_TAX_VAL dependencies on FND_NUMBER

Line 320: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa

316:
317: -- For Bug 5724436
318: -- Cursor to get the max assignment action id, to fetch the P45 details.
319: cursor get_p45_details (p_assignment_id number) is
320: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa
321: from pay_assignment_actions paa,
322: pay_payroll_actions ppa
323: where ppa.payroll_action_id = paa.payroll_action_id
324: and paa.assignment_id = p_assignment_id

Line 2520: l_tot_pay_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,12-7));

2516:
2517: l_wk_mth_indicator := get_token(l_present_line2,11-7);
2518: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_mth_indicator '||l_wk_mth_indicator);
2519:
2520: l_tot_pay_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,12-7));
2521: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_tot_pay_to_date '||l_tot_pay_to_date);
2522:
2523: l_tot_tax_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,13-7));
2524: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_tot_tax_to_date '||l_tot_tax_to_date);

Line 2523: l_tot_tax_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,13-7));

2519:
2520: l_tot_pay_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,12-7));
2521: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_tot_pay_to_date '||l_tot_pay_to_date);
2522:
2523: l_tot_tax_to_date := fnd_number.canonical_to_number(get_token(l_present_line2,13-7));
2524: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_tot_tax_to_date '||l_tot_tax_to_date);
2525:
2526: l_exemption_indicator := get_token(l_present_line2,14-7);
2527: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_exemption_indicator '||l_exemption_indicator);

Line 2529: l_CD_YRLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line2,15-7));

2525:
2526: l_exemption_indicator := get_token(l_present_line2,14-7);
2527: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_exemption_indicator '||l_exemption_indicator);
2528:
2529: l_CD_YRLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line2,15-7));
2530: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_CRED '||l_CD_YRLY_TAX_CRED);
2531:
2532: l_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,16-7)); -->length 8
2533: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_tax_credit '||l_mth_tax_credit);

Line 2532: l_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,16-7)); -->length 8

2528:
2529: l_CD_YRLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line2,15-7));
2530: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_CRED '||l_CD_YRLY_TAX_CRED);
2531:
2532: l_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,16-7)); -->length 8
2533: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_tax_credit '||l_mth_tax_credit);
2534:
2535: l_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,17-7)); -->length 7
2536: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_tax_credit '||l_wk_tax_credit);

Line 2535: l_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,17-7)); -->length 7

2531:
2532: l_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,16-7)); -->length 8
2533: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_tax_credit '||l_mth_tax_credit);
2534:
2535: l_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,17-7)); -->length 7
2536: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_tax_credit '||l_wk_tax_credit);
2537:
2538: l_std_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,18-7));
2539: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_std_rate_of_tax '||l_std_rate_of_tax);

Line 2538: l_std_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,18-7));

2534:
2535: l_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line2,17-7)); -->length 7
2536: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_tax_credit '||l_wk_tax_credit);
2537:
2538: l_std_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,18-7));
2539: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_std_rate_of_tax '||l_std_rate_of_tax);
2540:
2541: l_CD_YRLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,19-7));
2542: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_1 '||l_CD_YRLY_TAX_RATE_1);

Line 2541: l_CD_YRLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,19-7));

2537:
2538: l_std_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,18-7));
2539: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_std_rate_of_tax '||l_std_rate_of_tax);
2540:
2541: l_CD_YRLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,19-7));
2542: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_1 '||l_CD_YRLY_TAX_RATE_1);
2543:
2544: l_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,20-7)); -->length 8
2545: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_rate_cutoff '||l_mth_rate_cutoff);

Line 2544: l_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,20-7)); -->length 8

2540:
2541: l_CD_YRLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,19-7));
2542: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_1 '||l_CD_YRLY_TAX_RATE_1);
2543:
2544: l_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,20-7)); -->length 8
2545: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_rate_cutoff '||l_mth_rate_cutoff);
2546:
2547: l_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,21-7)); -->length 7
2548: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_rate_cutoff '||l_wk_rate_cutoff);

Line 2547: l_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,21-7)); -->length 7

2543:
2544: l_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,20-7)); -->length 8
2545: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_mth_rate_cutoff '||l_mth_rate_cutoff);
2546:
2547: l_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,21-7)); -->length 7
2548: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_rate_cutoff '||l_wk_rate_cutoff);
2549:
2550: l_higher_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,22-7));
2551: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_higher_rate_of_tax '||l_higher_rate_of_tax);

Line 2550: l_higher_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,22-7));

2546:
2547: l_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line2,21-7)); -->length 7
2548: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_wk_rate_cutoff '||l_wk_rate_cutoff);
2549:
2550: l_higher_rate_of_tax := fnd_number.canonical_to_number(get_token(l_present_line2,22-7));
2551: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_higher_rate_of_tax '||l_higher_rate_of_tax);
2552:
2553: l_processed_flag := NULL;
2554: l_processed_date := NULL;

Line 2557: l_CD_YRLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,23-7));

2553: l_processed_flag := NULL;
2554: l_processed_date := NULL;
2555: --
2556:
2557: l_CD_YRLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,23-7));
2558: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_2 '||l_CD_YRLY_TAX_RATE_2);
2559: l_CD_MTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,24-7));
2560: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_2 '||l_CD_MTHLY_TAX_RATE_2);
2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));

Line 2559: l_CD_MTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,24-7));

2555: --
2556:
2557: l_CD_YRLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,23-7));
2558: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_2 '||l_CD_YRLY_TAX_RATE_2);
2559: l_CD_MTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,24-7));
2560: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_2 '||l_CD_MTHLY_TAX_RATE_2);
2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));
2562: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_2 '||l_CD_WKLY_TAX_RATE_2);
2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));

Line 2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));

2557: l_CD_YRLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,23-7));
2558: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_2 '||l_CD_YRLY_TAX_RATE_2);
2559: l_CD_MTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,24-7));
2560: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_2 '||l_CD_MTHLY_TAX_RATE_2);
2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));
2562: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_2 '||l_CD_WKLY_TAX_RATE_2);
2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));
2564: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_3 '||l_CD_TAX_RATE_3);
2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));

Line 2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));

2559: l_CD_MTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,24-7));
2560: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_2 '||l_CD_MTHLY_TAX_RATE_2);
2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));
2562: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_2 '||l_CD_WKLY_TAX_RATE_2);
2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));
2564: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_3 '||l_CD_TAX_RATE_3);
2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));
2566: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_3 '||l_CD_YRLY_TAX_RATE_3);
2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));

Line 2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));

2561: l_CD_WKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,25-7));
2562: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_2 '||l_CD_WKLY_TAX_RATE_2);
2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));
2564: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_3 '||l_CD_TAX_RATE_3);
2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));
2566: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_3 '||l_CD_YRLY_TAX_RATE_3);
2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));
2568: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_3 '||l_CD_MTHLY_TAX_RATE_3);
2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));

Line 2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));

2563: l_CD_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,26-7));
2564: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_3 '||l_CD_TAX_RATE_3);
2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));
2566: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_3 '||l_CD_YRLY_TAX_RATE_3);
2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));
2568: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_3 '||l_CD_MTHLY_TAX_RATE_3);
2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));
2570: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_3 '||l_CD_WKLY_TAX_RATE_3);
2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));

Line 2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));

2565: l_CD_YRLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,27-7));
2566: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_3 '||l_CD_YRLY_TAX_RATE_3);
2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));
2568: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_3 '||l_CD_MTHLY_TAX_RATE_3);
2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));
2570: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_3 '||l_CD_WKLY_TAX_RATE_3);
2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));
2572: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_4 '||l_CD_TAX_RATE_4);
2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));

Line 2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));

2567: l_CD_MTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,28-7));
2568: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_3 '||l_CD_MTHLY_TAX_RATE_3);
2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));
2570: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_3 '||l_CD_WKLY_TAX_RATE_3);
2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));
2572: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_4 '||l_CD_TAX_RATE_4);
2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));
2574: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_4 '||l_CD_YRLY_TAX_RATE_4);
2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));

Line 2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));

2569: l_CD_WKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,29-7));
2570: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_3 '||l_CD_WKLY_TAX_RATE_3);
2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));
2572: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_4 '||l_CD_TAX_RATE_4);
2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));
2574: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_4 '||l_CD_YRLY_TAX_RATE_4);
2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));
2576: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_4 '||l_CD_MTHLY_TAX_RATE_4);
2577: l_CD_WKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,33-7));

Line 2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));

2571: l_CD_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,30-7));
2572: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_4 '||l_CD_TAX_RATE_4);
2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));
2574: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_4 '||l_CD_YRLY_TAX_RATE_4);
2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));
2576: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_4 '||l_CD_MTHLY_TAX_RATE_4);
2577: l_CD_WKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,33-7));
2578: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_4 '||l_CD_WKLY_TAX_RATE_4);
2579: l_CD_TAX_RATE_5 := fnd_number.canonical_to_number(get_token(l_present_line2,34-7));

Line 2577: l_CD_WKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,33-7));

2573: l_CD_YRLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,31-7));
2574: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_YRLY_TAX_RATE_4 '||l_CD_YRLY_TAX_RATE_4);
2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));
2576: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_4 '||l_CD_MTHLY_TAX_RATE_4);
2577: l_CD_WKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,33-7));
2578: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_4 '||l_CD_WKLY_TAX_RATE_4);
2579: l_CD_TAX_RATE_5 := fnd_number.canonical_to_number(get_token(l_present_line2,34-7));
2580: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_5 '||l_CD_TAX_RATE_5 );
2581: l_IN_EXEMPT_USC := get_token(l_present_line2,35-7);

Line 2579: l_CD_TAX_RATE_5 := fnd_number.canonical_to_number(get_token(l_present_line2,34-7));

2575: l_CD_MTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,32-7));
2576: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_MTHLY_TAX_RATE_4 '||l_CD_MTHLY_TAX_RATE_4);
2577: l_CD_WKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,33-7));
2578: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_WKLY_TAX_RATE_4 '||l_CD_WKLY_TAX_RATE_4);
2579: l_CD_TAX_RATE_5 := fnd_number.canonical_to_number(get_token(l_present_line2,34-7));
2580: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_5 '||l_CD_TAX_RATE_5 );
2581: l_IN_EXEMPT_USC := get_token(l_present_line2,35-7);
2582: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_IN_EXEMPT_USC '||l_IN_EXEMPT_USC );
2583: l_CD_TOTAL_USC_PAY_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,36-7));

Line 2583: l_CD_TOTAL_USC_PAY_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,36-7));

2579: l_CD_TAX_RATE_5 := fnd_number.canonical_to_number(get_token(l_present_line2,34-7));
2580: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TAX_RATE_5 '||l_CD_TAX_RATE_5 );
2581: l_IN_EXEMPT_USC := get_token(l_present_line2,35-7);
2582: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_IN_EXEMPT_USC '||l_IN_EXEMPT_USC );
2583: l_CD_TOTAL_USC_PAY_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,36-7));
2584: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_PAY_TODATE '||l_CD_TOTAL_USC_PAY_TODATE);
2585: l_CD_TOTAL_USC_TAX_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,37-7));
2586: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_TAX_TODATE '||l_CD_TOTAL_USC_TAX_TODATE);
2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));

Line 2585: l_CD_TOTAL_USC_TAX_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,37-7));

2581: l_IN_EXEMPT_USC := get_token(l_present_line2,35-7);
2582: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_IN_EXEMPT_USC '||l_IN_EXEMPT_USC );
2583: l_CD_TOTAL_USC_PAY_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,36-7));
2584: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_PAY_TODATE '||l_CD_TOTAL_USC_PAY_TODATE);
2585: l_CD_TOTAL_USC_TAX_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,37-7));
2586: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_TAX_TODATE '||l_CD_TOTAL_USC_TAX_TODATE);
2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));
2588: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_1 '||l_CD_USC_RATE_1);
2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));

Line 2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));

2583: l_CD_TOTAL_USC_PAY_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,36-7));
2584: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_PAY_TODATE '||l_CD_TOTAL_USC_PAY_TODATE);
2585: l_CD_TOTAL_USC_TAX_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,37-7));
2586: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_TAX_TODATE '||l_CD_TOTAL_USC_TAX_TODATE);
2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));
2588: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_1 '||l_CD_USC_RATE_1);
2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));
2590: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_1 '||l_AM_USC_YRLY_CUTOFF_1);
2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));

Line 2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));

2585: l_CD_TOTAL_USC_TAX_TODATE := fnd_number.canonical_to_number(get_token(l_present_line2,37-7));
2586: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_TOTAL_USC_TAX_TODATE '||l_CD_TOTAL_USC_TAX_TODATE);
2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));
2588: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_1 '||l_CD_USC_RATE_1);
2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));
2590: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_1 '||l_AM_USC_YRLY_CUTOFF_1);
2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));
2592: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_1 '||l_AM_USC_MTHLY_CUTOFF_1);
2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));

Line 2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));

2587: l_CD_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line2,38-7));
2588: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_1 '||l_CD_USC_RATE_1);
2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));
2590: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_1 '||l_AM_USC_YRLY_CUTOFF_1);
2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));
2592: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_1 '||l_AM_USC_MTHLY_CUTOFF_1);
2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));
2594: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_1 '||l_AM_USC_WKLY_CUTOFF_1);
2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));

Line 2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));

2589: l_AM_USC_YRLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,39-7));
2590: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_1 '||l_AM_USC_YRLY_CUTOFF_1);
2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));
2592: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_1 '||l_AM_USC_MTHLY_CUTOFF_1);
2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));
2594: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_1 '||l_AM_USC_WKLY_CUTOFF_1);
2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));
2596: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_2 '||l_CD_USC_RATE_2);
2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));

Line 2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));

2591: l_AM_USC_MTHLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,40-7));
2592: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_1 '||l_AM_USC_MTHLY_CUTOFF_1);
2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));
2594: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_1 '||l_AM_USC_WKLY_CUTOFF_1);
2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));
2596: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_2 '||l_CD_USC_RATE_2);
2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));
2598: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_2 '||l_AM_USC_YRLY_CUTOFF_2);
2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));

Line 2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));

2593: l_AM_USC_WKLY_CUTOFF_1 := fnd_number.canonical_to_number(get_token(l_present_line2,41-7));
2594: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_1 '||l_AM_USC_WKLY_CUTOFF_1);
2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));
2596: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_2 '||l_CD_USC_RATE_2);
2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));
2598: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_2 '||l_AM_USC_YRLY_CUTOFF_2);
2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));
2600: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_2 '||l_AM_USC_MTHLY_CUTOFF_2);
2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));

Line 2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));

2595: l_CD_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line2,42-7));
2596: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_2 '||l_CD_USC_RATE_2);
2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));
2598: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_2 '||l_AM_USC_YRLY_CUTOFF_2);
2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));
2600: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_2 '||l_AM_USC_MTHLY_CUTOFF_2);
2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));
2602: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_2 '||l_AM_USC_WKLY_CUTOFF_2);
2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));

Line 2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));

2597: l_AM_USC_YRLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,43-7));
2598: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_2 '||l_AM_USC_YRLY_CUTOFF_2);
2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));
2600: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_2 '||l_AM_USC_MTHLY_CUTOFF_2);
2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));
2602: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_2 '||l_AM_USC_WKLY_CUTOFF_2);
2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));
2604: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_3 '||l_CD_USC_RATE_3);
2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));

Line 2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));

2599: l_AM_USC_MTHLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,44-7));
2600: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_2 '||l_AM_USC_MTHLY_CUTOFF_2);
2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));
2602: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_2 '||l_AM_USC_WKLY_CUTOFF_2);
2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));
2604: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_3 '||l_CD_USC_RATE_3);
2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));
2606: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_3 '||l_AM_USC_YRLY_CUTOFF_3);
2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));

Line 2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));

2601: l_AM_USC_WKLY_CUTOFF_2 := fnd_number.canonical_to_number(get_token(l_present_line2,45-7));
2602: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_2 '||l_AM_USC_WKLY_CUTOFF_2);
2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));
2604: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_3 '||l_CD_USC_RATE_3);
2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));
2606: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_3 '||l_AM_USC_YRLY_CUTOFF_3);
2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));
2608: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_3 '||l_AM_USC_MTHLY_CUTOFF_3);
2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));

Line 2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));

2603: l_CD_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line2,46-7));
2604: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_3 '||l_CD_USC_RATE_3);
2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));
2606: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_3 '||l_AM_USC_YRLY_CUTOFF_3);
2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));
2608: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_3 '||l_AM_USC_MTHLY_CUTOFF_3);
2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));
2610: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_3 '||l_AM_USC_WKLY_CUTOFF_3);
2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));

Line 2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));

2605: l_AM_USC_YRLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,47-7));
2606: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_3 '||l_AM_USC_YRLY_CUTOFF_3);
2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));
2608: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_3 '||l_AM_USC_MTHLY_CUTOFF_3);
2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));
2610: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_3 '||l_AM_USC_WKLY_CUTOFF_3);
2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));
2612: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_4 '||l_CD_USC_RATE_4);
2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));

Line 2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));

2607: l_AM_USC_MTHLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,48-7));
2608: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_3 '||l_AM_USC_MTHLY_CUTOFF_3);
2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));
2610: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_3 '||l_AM_USC_WKLY_CUTOFF_3);
2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));
2612: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_4 '||l_CD_USC_RATE_4);
2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));
2614: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_4 '||l_AM_USC_YRLY_CUTOFF_4);
2615: l_AM_USC_MTHLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,52-7));

Line 2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));

2609: l_AM_USC_WKLY_CUTOFF_3 := fnd_number.canonical_to_number(get_token(l_present_line2,49-7));
2610: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_3 '||l_AM_USC_WKLY_CUTOFF_3);
2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));
2612: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_4 '||l_CD_USC_RATE_4);
2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));
2614: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_4 '||l_AM_USC_YRLY_CUTOFF_4);
2615: l_AM_USC_MTHLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,52-7));
2616: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_4 '||l_AM_USC_MTHLY_CUTOFF_4);
2617: l_AM_USC_WKLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,53-7));

Line 2615: l_AM_USC_MTHLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,52-7));

2611: l_CD_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line2,50-7));
2612: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_4 '||l_CD_USC_RATE_4);
2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));
2614: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_4 '||l_AM_USC_YRLY_CUTOFF_4);
2615: l_AM_USC_MTHLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,52-7));
2616: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_4 '||l_AM_USC_MTHLY_CUTOFF_4);
2617: l_AM_USC_WKLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,53-7));
2618: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_4 '||l_AM_USC_WKLY_CUTOFF_4);
2619:

Line 2617: l_AM_USC_WKLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,53-7));

2613: l_AM_USC_YRLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,51-7));
2614: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_YRLY_CUTOFF_4 '||l_AM_USC_YRLY_CUTOFF_4);
2615: l_AM_USC_MTHLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,52-7));
2616: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_MTHLY_CUTOFF_4 '||l_AM_USC_MTHLY_CUTOFF_4);
2617: l_AM_USC_WKLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,53-7));
2618: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_4 '||l_AM_USC_WKLY_CUTOFF_4);
2619:
2620: IF ASCII(substr(get_token(l_present_line2,54-7),1,2)) <> '13' THEN
2621: l_CD_USC_RATE_5 := fnd_number.canonical_to_number(substr(get_token(l_present_line2,54-7),1,2));

Line 2621: l_CD_USC_RATE_5 := fnd_number.canonical_to_number(substr(get_token(l_present_line2,54-7),1,2));

2617: l_AM_USC_WKLY_CUTOFF_4 := fnd_number.canonical_to_number(get_token(l_present_line2,53-7));
2618: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_AM_USC_WKLY_CUTOFF_4 '||l_AM_USC_WKLY_CUTOFF_4);
2619:
2620: IF ASCII(substr(get_token(l_present_line2,54-7),1,2)) <> '13' THEN
2621: l_CD_USC_RATE_5 := fnd_number.canonical_to_number(substr(get_token(l_present_line2,54-7),1,2));
2622: END IF;
2623: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_CD_USC_RATE_5-3 '||l_CD_USC_RATE_5);
2624: --
2625:

Line 2782: l_total_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,6));

2778: --Inserting into the Footer table
2779: l_employer_number := l_employer_number;
2780: l_record_no := get_token(l_present_line,21);
2781: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_record_no '||l_record_no);
2782: l_total_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,6));
2783: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_rate_cutoff '||l_total_mth_rate_cutoff);
2784: l_total_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,7));
2785: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_rate_cutoff '||l_total_wk_rate_cutoff);
2786: l_total_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,3));

Line 2784: l_total_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,7));

2780: l_record_no := get_token(l_present_line,21);
2781: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_record_no '||l_record_no);
2782: l_total_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,6));
2783: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_rate_cutoff '||l_total_mth_rate_cutoff);
2784: l_total_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,7));
2785: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_rate_cutoff '||l_total_wk_rate_cutoff);
2786: l_total_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,3));
2787: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_tax_credit '||l_total_mth_tax_credit);
2788: l_total_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,4));

Line 2786: l_total_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,3));

2782: l_total_mth_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,6));
2783: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_rate_cutoff '||l_total_mth_rate_cutoff);
2784: l_total_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,7));
2785: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_rate_cutoff '||l_total_wk_rate_cutoff);
2786: l_total_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,3));
2787: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_tax_credit '||l_total_mth_tax_credit);
2788: l_total_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,4));
2789: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_tax_credit '||l_total_wk_tax_credit);
2790:

Line 2788: l_total_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,4));

2784: l_total_wk_rate_cutoff := fnd_number.canonical_to_number(get_token(l_present_line,7));
2785: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_rate_cutoff '||l_total_wk_rate_cutoff);
2786: l_total_mth_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,3));
2787: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_mth_tax_credit '||l_total_mth_tax_credit);
2788: l_total_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,4));
2789: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_tax_credit '||l_total_wk_tax_credit);
2790:
2791: --
2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));

Line 2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));

2788: l_total_wk_tax_credit := fnd_number.canonical_to_number(get_token(l_present_line,4));
2789: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_tax_credit '||l_total_wk_tax_credit);
2790:
2791: --
2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));
2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));

Line 2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));

2789: --fnd_file.PUT_LINE(FND_FILE.LOG, 'l_total_wk_tax_credit '||l_total_wk_tax_credit);
2790:
2791: --
2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));
2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));

Line 2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));

2790:
2791: --
2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));
2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));

Line 2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));

2791: --
2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));
2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));

Line 2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));

2792: l_TC_TOT_YEARLY_TAX_CRED := fnd_number.canonical_to_number(get_token(l_present_line,2));
2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));

Line 2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));

2793: l_TOT_YEARLY_TAX_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,5));
2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));

Line 2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));

2794: l_TOT_YEARLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,8));
2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));

Line 2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));

2795: l_TOT_MONTHLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,9));
2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));

Line 2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));

2796: l_TOT_WEEKLY_TAX_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,10));
2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));

Line 2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));

2797: l_TOT_YEARLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,11));
2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));

Line 2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));

2798: l_TOT_MONTHLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,12));
2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));
2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));

Line 2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));

2799: l_TOT_WEEKLY_TAX_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,13));
2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));
2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));
2807: --

Line 2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));

2800: l_TOT_YEARLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,14));
2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));
2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));
2807: --
2808: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++TRAILER+++++++++');

Line 2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));

2801: l_TOT_MONTHLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,15));
2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));
2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));
2807: --
2808: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++TRAILER+++++++++');
2809:

Line 2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));

2802: l_TOT_WEEKLY_TAX_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,16));
2803: l_TOT_YEARLY_USC_RATE_1 := fnd_number.canonical_to_number(get_token(l_present_line,17));
2804: l_TOT_YEARLY_USC_RATE_2 := fnd_number.canonical_to_number(get_token(l_present_line,18));
2805: l_TOT_YEARLY_USC_RATE_3 := fnd_number.canonical_to_number(get_token(l_present_line,19));
2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));
2807: --
2808: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++TRAILER+++++++++');
2809:
2810: INSERT INTO PAY_IE_TAX_TRAILER_INTERFACE

Line 3473: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa

3469:
3470: -- For Bug 5724436
3471: -- Cursor to get the max assignment action id, to fetch the P45 details.
3472: cursor get_p45_details (p_assignment_id number) is
3473: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa
3474: from pay_assignment_actions paa,
3475: pay_payroll_actions ppa
3476: where ppa.payroll_action_id = paa.payroll_action_id
3477: and paa.assignment_id = p_assignment_id