DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PAY_BALANCE_PKG

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

1159: FETCH get_upper_base INTO l_upper_base;
1160: CLOSE get_upper_base;
1161:
1162: l_defined_balance_id := PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');
1163: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1164:
1165: --Check for lower and upper limits of the reference salary
1166:
1167:

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

2265: OPEN csr_tax_unit(p_assignment_action_id);
2266: FETCH csr_tax_unit INTO l_tu_id;
2267: CLOSE csr_tax_unit;
2268:
2269: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2270: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2271:
2272: IF g_user_balance_table.count > 0 THEN
2273:

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

2266: FETCH csr_tax_unit INTO l_tu_id;
2267: CLOSE csr_tax_unit;
2268:
2269: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2270: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2271:
2272: IF g_user_balance_table.count > 0 THEN
2273:
2274: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

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

2272: IF g_user_balance_table.count > 0 THEN
2273:
2274: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2275:
2276: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2277:
2278:
2279: IF l_balance_value > 0 THEN
2280: