[Home] [Help]
2639: -- to_char(l_leg_end_date,'MM/DD/YYYY'));
2640: -- commit;
2641: -- end if;
2642:
2643: pay_us_balance_view_pkg.set_view_mode('ASG');
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2640: -- commit;
2641: -- end if;
2642:
2643: pay_us_balance_view_pkg.set_view_mode('ASG');
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2641: -- end if;
2642:
2643: pay_us_balance_view_pkg.set_view_mode('ASG');
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2642:
2643: pay_us_balance_view_pkg.set_view_mode('ASG');
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2643: pay_us_balance_view_pkg.set_view_mode('ASG');
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2651:
2644: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2651:
2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2645: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2651:
2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2646: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2647: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2648: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2649: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2650: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2651:
2652: l_ded_view_name := 'PAY_US_GTN_DEDUCT_V';
2653: l_earn_view_name := 'PAY_US_GTN_EARNINGS_V';
2654: l_fed_view_name := 'PAY_US_FED_TAXES_V';
2919: -- end if;
2920:
2921: l_asg_flag := nvl(p_asg_flag,'N');
2922: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2923: pay_us_balance_view_pkg.set_view_mode('ASG');
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2920:
2921: l_asg_flag := nvl(p_asg_flag,'N');
2922: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2923: pay_us_balance_view_pkg.set_view_mode('ASG');
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2921: l_asg_flag := nvl(p_asg_flag,'N');
2922: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2923: pay_us_balance_view_pkg.set_view_mode('ASG');
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2922: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2923: pay_us_balance_view_pkg.set_view_mode('ASG');
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2930: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2923: pay_us_balance_view_pkg.set_view_mode('ASG');
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2930: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2931:
2924: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2930: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2931:
2932:
2925: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2930: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2931:
2932:
2933:
2926: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');
2927: pay_us_balance_view_pkg.set_session_var('MONTH', 'FALSE');
2928: pay_us_balance_view_pkg.set_session_var('QTD', 'FALSE');
2929: pay_us_balance_view_pkg.set_session_var('CURRENT','FALSE');
2930: pay_us_balance_view_pkg.set_session_var('YTD', 'FALSE');
2931:
2932:
2933:
2934: