APPS.PAY_SA_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 1150: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

1146: FETCH get_upper_base INTO l_upper_base;
1147: CLOSE get_upper_base;
1148:
1149: l_defined_balance_id := PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');
1150: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1151:
1152: --Check for lower and upper limits of the reference salary
1153:
1154:

Line 2161: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);

2157: OPEN csr_tax_unit(p_assignment_action_id);
2158: FETCH csr_tax_unit INTO l_tu_id;
2159: CLOSE csr_tax_unit;
2160:
2161: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2162: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2163:
2164: IF g_user_balance_table.count > 0 THEN
2165:

Line 2162: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));

2158: FETCH csr_tax_unit INTO l_tu_id;
2159: CLOSE csr_tax_unit;
2160:
2161: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2162: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2163:
2164: IF g_user_balance_table.count > 0 THEN
2165:
2166: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

Line 2168: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);

2164: IF g_user_balance_table.count > 0 THEN
2165:
2166: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2167:
2168: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2169:
2170:
2171: IF l_balance_value > 0 THEN
2172: