APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_US_BALANCE_VIEW_PKG

Line 1021: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');

1017: hr_utility.set_location('pay_tax_bals_pkg',40);
1018: --
1019: l_assignment_id := p_assignment_id;
1020:
1021: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');
1022:
1023: If l_group_rb_report <> 'NA' then
1024:
1025: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');

Line 1025: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');

1021: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');
1022:
1023: If l_group_rb_report <> 'NA' then
1024:
1025: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');
1026:
1027: l_group_rb_sdate :=
1028: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1029: l_group_rb_edate :=

Line 1028: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);

1024:
1025: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');
1026:
1027: l_group_rb_sdate :=
1028: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1029: l_group_rb_edate :=
1030: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_EDATE'),l_end_of_time);
1031:
1032:

Line 1030: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_EDATE'),l_end_of_time);

1026:
1027: l_group_rb_sdate :=
1028: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1029: l_group_rb_edate :=
1030: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_EDATE'),l_end_of_time);
1031:
1032:
1033:
1034: if l_grp_aaid = 'NA' then

Line 1044: pay_us_balance_view_pkg.set_session_var('GRP_AAID',to_char(l_session_aaid));

1040: open c_get_min_aaid(l_group_rb_sdate,l_group_rb_edate,l_temp_bg_id);
1041: fetch c_get_min_aaid into l_session_aaid;
1042: close c_get_min_aaid;
1043:
1044: pay_us_balance_view_pkg.set_session_var('GRP_AAID',to_char(l_session_aaid));
1045:
1046: l_grp_aaid := to_char(l_session_aaid);
1047:
1048: end if;

Line 1906: NVL(pay_us_balance_view_pkg.get_session_var('REPORT_TYPE'),'NOT_DEFINED') = 'W2' THEN

1902: -- Adding the following code for the NEW TRR which goes of the
1903: -- Balance Reporting Arch.
1904:
1905: ELSIF (l_tax_balance_category = 'REDUCED_SUBJ_WHABLE') AND
1906: NVL(pay_us_balance_view_pkg.get_session_var('REPORT_TYPE'),'NOT_DEFINED') = 'W2' THEN
1907:
1908: l_return_value := us_tax_balance_rep(p_asg_lock,
1909: 'SUBJ_WHABLE',
1910: l_tax_type,