DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_AU_PAYE_FF

Line 844: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);

840: -- Calculate the average termination pay
841: --
842: lv_average_term_pay_period := trunc(p_gross_termination_amount/p_pay_freq); /* 16319860 - ignoring the cents */
843:
844: lv_average_pay := pay_au_paye_ff.convert_to_week(p_pay_freq,p_average_pay);
845: IF g_debug THEN
846:
847: hr_utility.trace('lv_average_term_pay_period = '||to_char(lv_average_term_pay_period));
848: hr_utility.trace('average term pay = '||to_char(lv_average_pay));

Line 853: l_average_pay_tax := (p_a_variable1 * pay_au_paye_ff.convert_to_week(p_pay_freq,(p_average_pay + lv_average_term_pay_period))) - p_b_variable1;

849: END IF;
850: --
851: -- Calculate tax on the average pay + average term pay
852: --
853: l_average_pay_tax := (p_a_variable1 * pay_au_paye_ff.convert_to_week(p_pay_freq,(p_average_pay + lv_average_term_pay_period))) - p_b_variable1;
854: if p_tax_scale <> 4
855: then
856: l_average_pay_tax := round(l_average_pay_tax, 0);
857: else

Line 885: l_lump_tax := (pay_au_paye_ff.convert_to_period_amt(p_pay_freq,l_average_pay_tax,p_tax_scale) - pay_au_paye_ff.convert_to_period_amt(p_pay_freq,l_average_term_pay_tax,p_tax_scale)) * p_pay_freq;

881: END IF;
882: --
883: -- Total tax payable equals the difference between the tax amounts multiplied by 52
884: --
885: l_lump_tax := (pay_au_paye_ff.convert_to_period_amt(p_pay_freq,l_average_pay_tax,p_tax_scale) - pay_au_paye_ff.convert_to_period_amt(p_pay_freq,l_average_term_pay_tax,p_tax_scale)) * p_pay_freq;
886:
887: --
888:
889: --

Line 2346: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then

2342: IF not l_case THEN
2343: l_max := l_max_lump_d - p_etp_all_pay_ytd;
2344: ELSE
2345:
2346: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2347: l_max := l_max_lump_d - p_etp_all_pay_ytd;
2348: else
2349:
2350: IF g_debug THEN

Line 2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);

2347: l_max := l_max_lump_d - p_etp_all_pay_ytd;
2348: else
2349:
2350: IF g_debug THEN
2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2352: END IF;
2353:
2354: IF (pay_au_paye_ff.g_lumpsum_d + p_etp_all_pay_ytd) < l_max_lump_d THEN
2355: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+p_etp_all_pay_ytd);

Line 2354: IF (pay_au_paye_ff.g_lumpsum_d + p_etp_all_pay_ytd) < l_max_lump_d THEN

2350: IF g_debug THEN
2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2352: END IF;
2353:
2354: IF (pay_au_paye_ff.g_lumpsum_d + p_etp_all_pay_ytd) < l_max_lump_d THEN
2355: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+p_etp_all_pay_ytd);
2356: ELSE
2357: l_max := 0;
2358: END IF;

Line 2355: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+p_etp_all_pay_ytd);

2351: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2352: END IF;
2353:
2354: IF (pay_au_paye_ff.g_lumpsum_d + p_etp_all_pay_ytd) < l_max_lump_d THEN
2355: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+p_etp_all_pay_ytd);
2356: ELSE
2357: l_max := 0;
2358: END IF;
2359:

Line 2362: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);

2358: END IF;
2359:
2360: end if;
2361:
2362: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2363:
2364: IF g_debug THEN
2365: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2366: END IF;

Line 2365: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);

2361:
2362: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2363:
2364: IF g_debug THEN
2365: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 30);
2366: END IF;
2367:
2368: END IF;
2369:

Line 2380: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then

2376: IF not l_case THEN
2377: l_max := l_max_lump_d ;
2378: ELSE
2379:
2380: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2381: l_max := l_max_lump_d;
2382: else
2383: IF g_debug THEN
2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);

Line 2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);

2380: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2381: l_max := l_max_lump_d;
2382: else
2383: IF g_debug THEN
2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2385: END IF;
2386:
2387: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2388: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

Line 2387: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN

2383: IF g_debug THEN
2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2385: END IF;
2386:
2387: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2388: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;
2389: ELSE
2390: l_max := 0;
2391: END IF;

Line 2388: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

2384: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2385: END IF;
2386:
2387: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2388: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;
2389: ELSE
2390: l_max := 0;
2391: END IF;
2392:

Line 2395: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);

2391: END IF;
2392:
2393: end if;
2394:
2395: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2396:
2397: IF g_debug THEN
2398: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2399: END IF;

Line 2398: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);

2394:
2395: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2396:
2397: IF g_debug THEN
2398: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 40);
2399: END IF;
2400:
2401: END IF;
2402: END IF;

Line 2444: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then

2440: l_max := l_max_lump_d - l_tot_prev_etp;
2441:
2442: ELSE
2443:
2444: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2445: l_max := l_max_lump_d - l_tot_prev_etp;
2446: else
2447:
2448: IF g_debug THEN

Line 2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);

2445: l_max := l_max_lump_d - l_tot_prev_etp;
2446: else
2447:
2448: IF g_debug THEN
2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2450: END IF;
2451:
2452: IF (pay_au_paye_ff.g_lumpsum_d + l_tot_prev_etp) < l_max_lump_d THEN
2453: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+l_tot_prev_etp);

Line 2452: IF (pay_au_paye_ff.g_lumpsum_d + l_tot_prev_etp) < l_max_lump_d THEN

2448: IF g_debug THEN
2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2450: END IF;
2451:
2452: IF (pay_au_paye_ff.g_lumpsum_d + l_tot_prev_etp) < l_max_lump_d THEN
2453: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+l_tot_prev_etp);
2454: ELSE
2455: l_max := 0;
2456: END IF;

Line 2453: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+l_tot_prev_etp);

2449: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2450: END IF;
2451:
2452: IF (pay_au_paye_ff.g_lumpsum_d + l_tot_prev_etp) < l_max_lump_d THEN
2453: l_max := l_max_lump_d-(pay_au_paye_ff.g_lumpsum_d+l_tot_prev_etp);
2454: ELSE
2455: l_max := 0;
2456: END IF;
2457:

Line 2460: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);

2456: END IF;
2457:
2458: end if;
2459:
2460: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2461:
2462: IF g_debug THEN
2463: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2464: END IF;

Line 2463: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);

2459:
2460: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2461:
2462: IF g_debug THEN
2463: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 60);
2464: END IF;
2465:
2466: END IF;
2467:

Line 2480: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then

2476: IF not l_case THEN
2477: l_max := l_max_lump_d;
2478: ELSE
2479:
2480: if nvl(pay_au_paye_ff.g_lumpsum_d,0) = 0 then
2481: l_max := l_max_lump_d;
2482: else
2483:
2484: IF g_debug THEN

Line 2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);

2481: l_max := l_max_lump_d;
2482: else
2483:
2484: IF g_debug THEN
2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2486: END IF;
2487:
2488: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2489: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

Line 2488: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN

2484: IF g_debug THEN
2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2486: END IF;
2487:
2488: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2489: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;
2490: ELSE
2491: l_max := 0;
2492: END IF;

Line 2489: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;

2485: hr_utility.set_location('retrieving g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2486: END IF;
2487:
2488: IF pay_au_paye_ff.g_lumpsum_d < l_max_lump_d THEN
2489: l_max := l_max_lump_d - pay_au_paye_ff.g_lumpsum_d;
2490: ELSE
2491: l_max := 0;
2492: END IF;
2493: end if;

Line 2495: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);

2491: l_max := 0;
2492: END IF;
2493: end if;
2494:
2495: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2496:
2497: IF g_debug THEN
2498: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2499: END IF;

Line 2498: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);

2494:
2495: pay_au_paye_ff.g_lumpsum_d := nvl(pay_au_paye_ff.g_lumpsum_d,0) + least(l_max, p_all_etp_payments);
2496:
2497: IF g_debug THEN
2498: hr_utility.set_location('setting g_lumpsum_d '||pay_au_paye_ff.g_lumpsum_d, 70);
2499: END IF;
2500:
2501: END IF;
2502: