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_AU_PAYMENT_SUMMARY dependencies on PAY_AU_FOREIGN_WORKERS

Line 331: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;

327: g_fw_fbt_check varchar2(2);
328: g_fw_fbt_term_check varchar2(2);
329:
330: -- Defined_balance_IDs for Foregin Worker balances
331: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
332: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
333: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
334: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
335:

Line 332: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;

328: g_fw_fbt_term_check varchar2(2);
329:
330: -- Defined_balance_IDs for Foregin Worker balances
331: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
332: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
333: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
334: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
335:
336: -- Global variables for comparison

Line 333: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;

329:
330: -- Defined_balance_IDs for Foregin Worker balances
331: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
332: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
333: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
334: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
335:
336: -- Global variables for comparison
337: g_fw_fbt_balance number ;

Line 334: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;

330: -- Defined_balance_IDs for Foregin Worker balances
331: p_fw_fbt_bal_type_tab pay_au_foreign_workers.tab_bal_type;
332: p_fw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
333: p_fw_alw_balance_type_tab pay_au_foreign_workers.tab_bal_type;
334: p_fw_union_balance_type_tab pay_au_foreign_workers.tab_bal_type;
335:
336: -- Global variables for comparison
337: g_fw_fbt_balance number ;
338: g_net_balance number ;

Line 345: f_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;

341: p_fw_alw_tab_sorted tab_allownace_balance;
342:
343: type fw_gross_type_table is table of varchar2(1) index by binary_integer;
344: t_fw_gross_type fw_gross_type_table;
345: f_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
346: j_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
347:
348: /* end bug 9147430 */
349:

Line 346: j_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;

342:
343: type fw_gross_type_table is table of varchar2(1) index by binary_integer;
344: t_fw_gross_type fw_gross_type_table;
345: f_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
346: j_fw_date_tab_g pay_au_foreign_workers.tab_fw_dates;
347:
348: /* end bug 9147430 */
349:
350: /* bug 14703826 - balance plsql tables for new ETP balances */

Line 2272: f_fw_date_tab pay_au_foreign_workers.tab_fw_dates;

2268: l_fw_fbt_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
2269: l_fw_reporting_amt Number := 0;
2270: l_fw_f_type varchar2(1);
2271: l_fw_j_type varchar2(1);
2272: f_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
2273: j_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
2274:
2275: begin
2276: sum_various := 0;

Line 2273: j_fw_date_tab pay_au_foreign_workers.tab_fw_dates;

2269: l_fw_reporting_amt Number := 0;
2270: l_fw_f_type varchar2(1);
2271: l_fw_j_type varchar2(1);
2272: f_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
2273: j_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
2274:
2275: begin
2276: sum_various := 0;
2277: counter := 1;

Line 2358: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),

2354:
2355: if g_fw_fbt_term_check <> 'NN' then -- Case for terminated employee with FB before the financial year start
2356:
2357: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'YN' then
2358: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2359: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2360: end if;
2361: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'NY' then
2362: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),

Line 2359: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);

2355: if g_fw_fbt_term_check <> 'NN' then -- Case for terminated employee with FB before the financial year start
2356:
2357: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'YN' then
2358: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2359: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2360: end if;
2361: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'NY' then
2362: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2363: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);

Line 2362: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),

2358: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2359: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2360: end if;
2361: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'NY' then
2362: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2363: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);
2364: end if;
2365:
2366: if f_fw_date_tab.count > 0 then

Line 2363: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);

2359: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2360: end if;
2361: if g_fw_fbt_term_check = 'YY' or g_fw_fbt_term_check = 'NY' then
2362: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), (p_year_start - 1),
2363: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);
2364: end if;
2365:
2366: if f_fw_date_tab.count > 0 then
2367: t_fw_gross_type(1) := 'F';

Line 2380: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

2376:
2377:
2378: IF t_fw_gross_type(i_idx) = 'F' THEN
2379:
2380: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
2381: p_registered_employer,
2382: f_fw_date_tab,
2383: add_months(p_year_start,-3),
2384: (p_year_start - 1),

Line 2385: pay_au_foreign_workers.g_fw_f_type,

2381: p_registered_employer,
2382: f_fw_date_tab,
2383: add_months(p_year_start,-3),
2384: (p_year_start - 1),
2385: pay_au_foreign_workers.g_fw_f_type,
2386: p_fw_fbt_bal_type_tab,
2387: l_fw_fbt_output_tab) ;
2388:
2389: ELSIF t_fw_gross_type(i_idx) = 'J' THEN

Line 2390: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

2386: p_fw_fbt_bal_type_tab,
2387: l_fw_fbt_output_tab) ;
2388:
2389: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
2390: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
2391: p_registered_employer,
2392: j_fw_date_tab,
2393: add_months(p_year_start,-3),
2394: (p_year_start - 1),

Line 2395: pay_au_foreign_workers.g_fw_j_type,

2391: p_registered_employer,
2392: j_fw_date_tab,
2393: add_months(p_year_start,-3),
2394: (p_year_start - 1),
2395: pay_au_foreign_workers.g_fw_j_type,
2396: p_fw_fbt_bal_type_tab,
2397: l_fw_fbt_output_tab) ;
2398: END IF;
2399:

Line 2415: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),

2411:
2412: elsif g_fw_fbt_check <> 'NN' then -- Case for employees in normal FB year
2413:
2414: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'YN' then
2415: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2416: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2417: end if;
2418: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'NY' then
2419: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),

Line 2416: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);

2412: elsif g_fw_fbt_check <> 'NN' then -- Case for employees in normal FB year
2413:
2414: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'YN' then
2415: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2416: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2417: end if;
2418: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'NY' then
2419: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2420: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);

Line 2419: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),

2415: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2416: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2417: end if;
2418: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'NY' then
2419: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2420: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);
2421: end if;
2422:
2423: if f_fw_date_tab.count > 0 then

Line 2420: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);

2416: pay_au_foreign_workers.g_fw_f_type, f_fw_date_tab);
2417: end if;
2418: if g_fw_fbt_check = 'YY' or g_fw_fbt_check = 'NY' then
2419: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id, p_registered_employer, add_months(p_year_start,-3), add_months(p_year_end,-3),
2420: pay_au_foreign_workers.g_fw_j_type, j_fw_date_tab);
2421: end if;
2422:
2423: if f_fw_date_tab.count > 0 then
2424: t_fw_gross_type(1) := 'F';

Line 2437: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

2433:
2434:
2435: IF t_fw_gross_type(i_idx) = 'F' THEN
2436:
2437: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
2438: p_registered_employer,
2439: f_fw_date_tab,
2440: add_months(p_year_start,-3),
2441: add_months(p_year_end,-3),

Line 2442: pay_au_foreign_workers.g_fw_f_type,

2438: p_registered_employer,
2439: f_fw_date_tab,
2440: add_months(p_year_start,-3),
2441: add_months(p_year_end,-3),
2442: pay_au_foreign_workers.g_fw_f_type,
2443: p_fw_fbt_bal_type_tab,
2444: l_fw_fbt_output_tab) ;
2445:
2446: ELSIF t_fw_gross_type(i_idx) = 'J' THEN

Line 2447: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

2443: p_fw_fbt_bal_type_tab,
2444: l_fw_fbt_output_tab) ;
2445:
2446: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
2447: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
2448: p_registered_employer,
2449: j_fw_date_tab,
2450: add_months(p_year_start,-3),
2451: add_months(p_year_end,-3),

Line 2452: pay_au_foreign_workers.g_fw_j_type,

2448: p_registered_employer,
2449: j_fw_date_tab,
2450: add_months(p_year_start,-3),
2451: add_months(p_year_end,-3),
2452: pay_au_foreign_workers.g_fw_j_type,
2453: p_fw_fbt_bal_type_tab,
2454: l_fw_fbt_output_tab) ;
2455: END IF;
2456:

Line 3202: IF pay_au_foreign_workers.cached = FALSE

3198: THEN
3199: /* Foreign Leave Payments Exist. Now verify if these are for
3200: Standard Periods
3201: */
3202: IF pay_au_foreign_workers.cached = FALSE
3203: THEN
3204: pay_au_foreign_workers.populate_asg_status_id;
3205: END IF;
3206:

Line 3204: pay_au_foreign_workers.populate_asg_status_id;

3200: Standard Periods
3201: */
3202: IF pay_au_foreign_workers.cached = FALSE
3203: THEN
3204: pay_au_foreign_workers.populate_asg_status_id;
3205: END IF;
3206:
3207: IF (l_result_table(4).balance_value = 0)
3208: THEN

Line 3215: ,pay_au_foreign_workers.g_fw_asg_f_status_id

3211: (p_assignment_id
3212: ,p_tax_unit_id
3213: ,csr_rec.start_date
3214: ,csr_rec.end_date
3215: ,pay_au_foreign_workers.g_fw_asg_f_status_id
3216: ,pay_au_foreign_workers.g_fw_asg_j_status_id)
3217: LOOP
3218: l_start_date := GREATEST(csr_days_rec.effective_start_date,csr_rec.start_date);
3219: l_end_date := LEAST(csr_days_rec.effective_end_date,csr_rec.end_date);

Line 3216: ,pay_au_foreign_workers.g_fw_asg_j_status_id)

3212: ,p_tax_unit_id
3213: ,csr_rec.start_date
3214: ,csr_rec.end_date
3215: ,pay_au_foreign_workers.g_fw_asg_f_status_id
3216: ,pay_au_foreign_workers.g_fw_asg_j_status_id)
3217: LOOP
3218: l_start_date := GREATEST(csr_days_rec.effective_start_date,csr_rec.start_date);
3219: l_end_date := LEAST(csr_days_rec.effective_end_date,csr_rec.end_date);
3220: l_days := l_days + (l_end_date - l_start_date) + 1;

Line 3342: l_fw_date_tab pay_au_foreign_workers.tab_fw_dates;

3338: l_fw_net_balance number := 0;
3339: l_fw_tot_sub_balance number :=0;
3340: l_fw_tot_net_balance number := 0;
3341: l_payg_fw_type varchar2(10) := 'P';
3342: l_fw_date_tab pay_au_foreign_workers.tab_fw_dates;
3343: l_fw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3344: l_fw_alw_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3345: l_fw_union_output_tab pay_balance_pkg.t_detailed_bal_out_tab;
3346: l_fw_start_date date;

Line 3425: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id

3421: p_fw_alw_tab_sorted.delete;
3422: f_fw_date_tab_g.delete;
3423: j_fw_date_tab_g.delete;
3424:
3425: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id
3426: ,p_registered_employer
3427: ,p_year_start
3428: ,p_year_end
3429: ,pay_au_foreign_workers.g_fw_f_type);

Line 3429: ,pay_au_foreign_workers.g_fw_f_type);

3425: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id
3426: ,p_registered_employer
3427: ,p_year_start
3428: ,p_year_end
3429: ,pay_au_foreign_workers.g_fw_f_type);
3430:
3431: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id
3432: ,p_registered_employer
3433: ,p_year_start

Line 3431: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id

3427: ,p_year_start
3428: ,p_year_end
3429: ,pay_au_foreign_workers.g_fw_f_type);
3430:
3431: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id
3432: ,p_registered_employer
3433: ,p_year_start
3434: ,p_year_end
3435: ,pay_au_foreign_workers.g_fw_j_type);

Line 3435: ,pay_au_foreign_workers.g_fw_j_type);

3431: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(p_assignment_id
3432: ,p_registered_employer
3433: ,p_year_start
3434: ,p_year_end
3435: ,pay_au_foreign_workers.g_fw_j_type);
3436:
3437: if l_fw_f_type = 'Y' then
3438: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id
3439: ,p_registered_employer

Line 3438: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id

3434: ,p_year_end
3435: ,pay_au_foreign_workers.g_fw_j_type);
3436:
3437: if l_fw_f_type = 'Y' then
3438: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id
3439: ,p_registered_employer
3440: ,p_year_start
3441: ,p_year_end
3442: ,pay_au_foreign_workers.g_fw_f_type

Line 3442: ,pay_au_foreign_workers.g_fw_f_type

3438: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id
3439: ,p_registered_employer
3440: ,p_year_start
3441: ,p_year_end
3442: ,pay_au_foreign_workers.g_fw_f_type
3443: ,f_fw_date_tab_g);
3444: end if;
3445: if l_fw_j_type = 'Y' then
3446: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id

Line 3446: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id

3442: ,pay_au_foreign_workers.g_fw_f_type
3443: ,f_fw_date_tab_g);
3444: end if;
3445: if l_fw_j_type = 'Y' then
3446: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id
3447: ,p_registered_employer
3448: ,p_year_start
3449: ,p_year_end
3450: ,pay_au_foreign_workers.g_fw_j_type

Line 3450: ,pay_au_foreign_workers.g_fw_j_type

3446: pay_au_foreign_workers.get_foreign_worker_dates(p_assignment_id
3447: ,p_registered_employer
3448: ,p_year_start
3449: ,p_year_end
3450: ,pay_au_foreign_workers.g_fw_j_type
3451: ,j_fw_date_tab_g);
3452: end if;
3453:
3454: if f_fw_date_tab_g.count > 0 then

Line 3523: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3519:
3520: /* FW EOY blance archive value */
3521: l_fw_output_tab.delete;
3522: IF t_fw_gross_type(i_idx) = 'F' THEN
3523: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3524: p_registered_employer,
3525: f_fw_date_tab_g,
3526: p_year_start,
3527: p_year_end,

Line 3528: pay_au_foreign_workers.g_fw_f_type,

3524: p_registered_employer,
3525: f_fw_date_tab_g,
3526: p_year_start,
3527: p_year_end,
3528: pay_au_foreign_workers.g_fw_f_type,
3529: p_fw_balance_type_tab,
3530: l_fw_output_tab) ;
3531: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3532: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

Line 3532: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3528: pay_au_foreign_workers.g_fw_f_type,
3529: p_fw_balance_type_tab,
3530: l_fw_output_tab) ;
3531: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3532: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3533: p_registered_employer,
3534: j_fw_date_tab_g,
3535: p_year_start,
3536: p_year_end, /* Bug 10348688 */

Line 3537: pay_au_foreign_workers.g_fw_j_type,

3533: p_registered_employer,
3534: j_fw_date_tab_g,
3535: p_year_start,
3536: p_year_end, /* Bug 10348688 */
3537: pay_au_foreign_workers.g_fw_j_type,
3538: p_fw_balance_type_tab,
3539: l_fw_output_tab) ;
3540: END IF;
3541:

Line 3638: ,pay_au_foreign_workers.g_fw_f_type

3634: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id
3635: ,p_registered_employer
3636: ,p_year_start
3637: ,p_year_end
3638: ,pay_au_foreign_workers.g_fw_f_type
3639: ,l_retro_fw_gross
3640: ,l_retro_fw_tax);
3641: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3642: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id, p_registered_employer, p_year_start, p_year_end, pay_au_foreign_workers.g_fw_j_type,

Line 3642: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id, p_registered_employer, p_year_start, p_year_end, pay_au_foreign_workers.g_fw_j_type,

3638: ,pay_au_foreign_workers.g_fw_f_type
3639: ,l_retro_fw_gross
3640: ,l_retro_fw_tax);
3641: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3642: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id, p_registered_employer, p_year_start, p_year_end, pay_au_foreign_workers.g_fw_j_type,
3643: l_retro_fw_gross, l_retro_fw_tax);
3644: END IF;
3645:
3646:

Line 3738: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3734: l_total_value := 0; -- bug#10084818 initializing
3735:
3736: l_fw_union_output_tab.delete;
3737: IF t_fw_gross_type(i_idx) = 'F' THEN
3738: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3739: p_registered_employer,
3740: f_fw_date_tab_g,
3741: p_year_start,
3742: p_year_end,

Line 3743: pay_au_foreign_workers.g_fw_f_type,

3739: p_registered_employer,
3740: f_fw_date_tab_g,
3741: p_year_start,
3742: p_year_end,
3743: pay_au_foreign_workers.g_fw_f_type,
3744: p_fw_union_balance_type_tab,
3745: l_fw_union_output_tab) ;
3746: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3747: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

Line 3747: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3743: pay_au_foreign_workers.g_fw_f_type,
3744: p_fw_union_balance_type_tab,
3745: l_fw_union_output_tab) ;
3746: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3747: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3748: p_registered_employer,
3749: j_fw_date_tab_g,
3750: p_year_start,
3751: p_year_end,

Line 3752: pay_au_foreign_workers.g_fw_j_type,

3748: p_registered_employer,
3749: j_fw_date_tab_g,
3750: p_year_start,
3751: p_year_end,
3752: pay_au_foreign_workers.g_fw_j_type,
3753: p_fw_union_balance_type_tab,
3754: l_fw_union_output_tab);
3755: END IF;
3756:

Line 3925: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3921: l_alw_total := 0; -- bug#10084818 initializing
3922: l_fw_alw_output_tab.delete;
3923:
3924: IF t_fw_gross_type(i_idx) = 'F' THEN
3925: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3926: p_registered_employer,
3927: f_fw_date_tab_g,
3928: p_year_start,
3929: p_year_end,

Line 3930: pay_au_foreign_workers.g_fw_f_type,

3926: p_registered_employer,
3927: f_fw_date_tab_g,
3928: p_year_start,
3929: p_year_end,
3930: pay_au_foreign_workers.g_fw_f_type,
3931: p_fw_alw_balance_type_tab,
3932: l_fw_alw_output_tab) ;
3933: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3934: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

Line 3934: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,

3930: pay_au_foreign_workers.g_fw_f_type,
3931: p_fw_alw_balance_type_tab,
3932: l_fw_alw_output_tab) ;
3933: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3934: pay_au_foreign_workers.get_foreign_payment_amounts(p_assignment_id,
3935: p_registered_employer,
3936: j_fw_date_tab_g,
3937: p_year_start,
3938: p_year_end,

Line 3939: pay_au_foreign_workers.g_fw_j_type,

3935: p_registered_employer,
3936: j_fw_date_tab_g,
3937: p_year_start,
3938: p_year_end,
3939: pay_au_foreign_workers.g_fw_j_type,
3940: p_fw_alw_balance_type_tab,
3941: l_fw_alw_output_tab) ;
3942: END IF;
3943:

Line 8514: g_fw_check := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, l_year_start, l_year_end);

8510: g_fw_union_value :=0;
8511:
8512: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8513:
8514: g_fw_check := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, l_year_start, l_year_end);
8515:
8516: if g_debug then
8517: hr_utility.set_location('FW EMP check .. g_fw_check for assignment_id '||l_assignment_id||' is '||g_fw_check, 2);
8518: end if;

Line 8733: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),

8729:
8730: /* bug9147430 - Check FW status for terminated employee with FB before the financial year */
8731: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8732:
8733: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8734: pay_au_foreign_workers.g_fw_f_type);
8735: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8736: pay_au_foreign_workers.g_fw_j_type);
8737:

Line 8734: pay_au_foreign_workers.g_fw_f_type);

8730: /* bug9147430 - Check FW status for terminated employee with FB before the financial year */
8731: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8732:
8733: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8734: pay_au_foreign_workers.g_fw_f_type);
8735: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8736: pay_au_foreign_workers.g_fw_j_type);
8737:
8738: if l_fw_f_type = 'Y' then

Line 8735: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),

8731: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8732:
8733: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8734: pay_au_foreign_workers.g_fw_f_type);
8735: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8736: pay_au_foreign_workers.g_fw_j_type);
8737:
8738: if l_fw_f_type = 'Y' then
8739: if l_fw_j_type = 'Y' then

Line 8736: pay_au_foreign_workers.g_fw_j_type);

8732:
8733: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8734: pay_au_foreign_workers.g_fw_f_type);
8735: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_start - 1),
8736: pay_au_foreign_workers.g_fw_j_type);
8737:
8738: if l_fw_f_type = 'Y' then
8739: if l_fw_j_type = 'Y' then
8740: g_fw_fbt_term_check := 'YY';

Line 8922: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),

8918:
8919: /* bug9147430 - Check FW status for normal Fringe Benefit tax year */
8920: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8921:
8922: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8923: pay_au_foreign_workers.g_fw_f_type);
8924: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8925: pay_au_foreign_workers.g_fw_j_type);
8926:

Line 8923: pay_au_foreign_workers.g_fw_f_type);

8919: /* bug9147430 - Check FW status for normal Fringe Benefit tax year */
8920: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8921:
8922: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8923: pay_au_foreign_workers.g_fw_f_type);
8924: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8925: pay_au_foreign_workers.g_fw_j_type);
8926:
8927: if l_fw_f_type = 'Y' then

Line 8924: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),

8920: if (to_number(to_char(l_year_start,'YYYY')) >= 2010) then
8921:
8922: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8923: pay_au_foreign_workers.g_fw_f_type);
8924: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8925: pay_au_foreign_workers.g_fw_j_type);
8926:
8927: if l_fw_f_type = 'Y' then
8928: if l_fw_j_type = 'Y' then

Line 8925: pay_au_foreign_workers.g_fw_j_type);

8921:
8922: l_fw_f_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8923: pay_au_foreign_workers.g_fw_f_type);
8924: l_fw_j_type := pay_au_foreign_workers.check_foreign_worker(l_assignment_id, l_registered_employer, add_months(l_year_start,-3), (l_year_end - 3),
8925: pay_au_foreign_workers.g_fw_j_type);
8926:
8927: if l_fw_f_type = 'Y' then
8928: if l_fw_j_type = 'Y' then
8929: g_fw_fbt_check := 'YY';