16:
17: IF cp_state_status = 'Y' OR cp_fed_status = 'Y' THEN
18: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_end_date));
19: pay_balance_pkg.set_context('BALANCE_DATE', fnd_date.date_to_canonical(p_end_date));
20: pay_us_balance_view_pkg.set_session_var('GROUP_RB_REPORT', 'TRUE');
21: pay_us_balance_view_pkg.set_session_var('REPORT_TYPE', 'W2');
22: -- Commented by Raj Starts
23: --pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date);
24: -- Commented by Raj Ends
17: IF cp_state_status = 'Y' OR cp_fed_status = 'Y' THEN
18: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(p_end_date));
19: pay_balance_pkg.set_context('BALANCE_DATE', fnd_date.date_to_canonical(p_end_date));
20: pay_us_balance_view_pkg.set_session_var('GROUP_RB_REPORT', 'TRUE');
21: pay_us_balance_view_pkg.set_session_var('REPORT_TYPE', 'W2');
22: -- Commented by Raj Starts
23: --pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date);
24: -- Commented by Raj Ends
25: pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date_m);
19: pay_balance_pkg.set_context('BALANCE_DATE', fnd_date.date_to_canonical(p_end_date));
20: pay_us_balance_view_pkg.set_session_var('GROUP_RB_REPORT', 'TRUE');
21: pay_us_balance_view_pkg.set_session_var('REPORT_TYPE', 'W2');
22: -- Commented by Raj Starts
23: --pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date);
24: -- Commented by Raj Ends
25: pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date_m);
26: pay_us_balance_view_pkg.set_session_var('GROUP_RB_EDATE', p_end_date);
27: END IF;
21: pay_us_balance_view_pkg.set_session_var('REPORT_TYPE', 'W2');
22: -- Commented by Raj Starts
23: --pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date);
24: -- Commented by Raj Ends
25: pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date_m);
26: pay_us_balance_view_pkg.set_session_var('GROUP_RB_EDATE', p_end_date);
27: END IF;
28:
29: DECLARE trace VARCHAR2(30) := '';
22: -- Commented by Raj Starts
23: --pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date);
24: -- Commented by Raj Ends
25: pay_us_balance_view_pkg.set_session_var('GROUP_RB_SDATE', p_start_date_m);
26: pay_us_balance_view_pkg.set_session_var('GROUP_RB_EDATE', p_end_date);
27: END IF;
28:
29: DECLARE trace VARCHAR2(30) := '';
30: BEGIN