2444: -- to_char(l_leg_end_date,'MM/DD/YYYY'));
2445: -- commit;
2446: -- end if;
2447:
2448: pay_us_balance_view_pkg.set_view_mode('ASG');
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2445: -- commit;
2446: -- end if;
2447:
2448: pay_us_balance_view_pkg.set_view_mode('ASG');
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2446: -- end if;
2447:
2448: pay_us_balance_view_pkg.set_view_mode('ASG');
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2447:
2448: pay_us_balance_view_pkg.set_view_mode('ASG');
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2448: pay_us_balance_view_pkg.set_view_mode('ASG');
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2449: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2450: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2458: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2451: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2452: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2453: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2454: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2455: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2456:
2457: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2458: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2459: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2694: -- end if;
2695:
2696: l_asg_flag := nvl(p_asg_flag,'N');
2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2695:
2696: l_asg_flag := nvl(p_asg_flag,'N');
2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2696: l_asg_flag := nvl(p_asg_flag,'N');
2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2705: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2705: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2706:
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2705: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2706:
2707:
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2705: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2706:
2707:
2708:
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2702: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2703: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2704: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2705: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2706:
2707:
2708:
2709: