DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PAY_BALANCE_PKG

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

1133:
1134: /*fnd_file.put_line(fnd_file.log,'Entering Procedure ARCHIVE_EMPLOYEE_DETAILS 6');*/
1135: /* Total Earnings YTD */
1136: /*l_defined_balance_id := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');
1137: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1138:
1139: l_formatted_value := to_char(l_balance_value, g_format_mask);*/
1140:
1141: /* Total Deductions YTD */

Line 1143: l_balance_value_ded := pay_balance_pkg.get_value(l_defined_balance_id_ded, p_assignment_action_id);

1139: l_formatted_value := to_char(l_balance_value, g_format_mask);*/
1140:
1141: /* Total Deductions YTD */
1142: /*l_defined_balance_id_ded := PAY_AE_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');
1143: l_balance_value_ded := pay_balance_pkg.get_value(l_defined_balance_id_ded, p_assignment_action_id);
1144:
1145: l_formatted_value_ded := to_char(l_balance_value_ded, g_format_mask);*/
1146:
1147: /* INSERT PERSON DETAILS */

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

2251: OPEN csr_tax_unit(p_assignment_action_id);
2252: FETCH csr_tax_unit INTO l_tu_id;
2253: CLOSE csr_tax_unit;
2254:
2255: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2256: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2257:
2258: IF g_user_balance_table.count > 0 THEN
2259:

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

2252: FETCH csr_tax_unit INTO l_tu_id;
2253: CLOSE csr_tax_unit;
2254:
2255: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
2256: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
2257:
2258: IF g_user_balance_table.count > 0 THEN
2259:
2260: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

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

2258: IF g_user_balance_table.count > 0 THEN
2259:
2260: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
2261:
2262: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2263:
2264: l_uom := hr_general.decode_lookup('UNITS',g_user_balance_table(l_index).uom);
2265:
2266: