APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_US_BALANCE_VIEW_PKG

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

1086: hr_utility.set_location('pay_tax_bals_pkg',40);
1087: --
1088: l_assignment_id := p_assignment_id;
1089:
1090: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');
1091:
1092: If l_group_rb_report <> 'NA' then
1093:
1094: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');

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

1090: l_group_rb_report := NVL(pay_us_balance_view_pkg.get_session_var('GROUP_RB_REPORT'),'NA');
1091:
1092: If l_group_rb_report <> 'NA' then
1093:
1094: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');
1095:
1096: l_group_rb_sdate :=
1097: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1098: l_group_rb_edate :=

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

1093:
1094: l_grp_aaid := nvl(pay_us_balance_view_pkg.get_session_var('GRP_AAID'),'NA');
1095:
1096: l_group_rb_sdate :=
1097: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1098: l_group_rb_edate :=
1099: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_EDATE'),l_end_of_time);
1100:
1101:

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

1095:
1096: l_group_rb_sdate :=
1097: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_SDATE'),sysdate);
1098: l_group_rb_edate :=
1099: nvl(pay_us_balance_view_pkg.get_session_var('GROUP_RB_EDATE'),l_end_of_time);
1100:
1101:
1102:
1103: if l_grp_aaid = 'NA' then

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

1109: open c_get_min_aaid(l_group_rb_sdate,l_group_rb_edate,l_temp_bg_id);
1110: fetch c_get_min_aaid into l_session_aaid;
1111: close c_get_min_aaid;
1112:
1113: pay_us_balance_view_pkg.set_session_var('GRP_AAID',to_char(l_session_aaid));
1114:
1115: l_grp_aaid := to_char(l_session_aaid);
1116:
1117: end if;

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

2201: -- Adding the following code for the NEW TRR which goes of the
2202: -- Balance Reporting Arch.
2203:
2204: ELSIF (l_tax_balance_category = 'REDUCED_SUBJ_WHABLE') AND
2205: NVL(pay_us_balance_view_pkg.get_session_var('REPORT_TYPE'),'NOT_DEFINED') = 'W2' THEN
2206:
2207: l_return_value := us_tax_balance_rep(p_asg_lock,
2208: 'SUBJ_WHABLE',
2209: l_tax_type,