DBA Data[Home] [Help]

APPS.PAY_KW_ARCHIVE dependencies on PAY_BALANCE_PKG

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

1116: l_org_country:=PAY_KW_ARCHIVE.get_country_name(rec_org_address.country);
1117:
1118: /* Total Earnings YTD */
1119: l_defined_balance_id := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_EARNINGS_ASG_YTD');
1120: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
1121:
1122: l_formatted_value := to_char(l_balance_value, g_format_mask);
1123:
1124: /* Total Deductions YTD */

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

1122: l_formatted_value := to_char(l_balance_value, g_format_mask);
1123:
1124: /* Total Deductions YTD */
1125: l_defined_balance_id_ded := PAY_KW_ARCHIVE.GET_DEFINED_BALANCE_ID('TOTAL_DEDUCTIONS_ASG_YTD');
1126: l_balance_value_ded := pay_balance_pkg.get_value(l_defined_balance_id_ded, p_assignment_action_id);
1127:
1128: l_formatted_value_ded := to_char(l_balance_value_ded, g_format_mask);
1129:
1130: /* INSERT PERSON DETAILS */

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

1989: OPEN csr_tax_unit(p_assignment_action_id);
1990: FETCH csr_tax_unit INTO l_tu_id;
1991: CLOSE csr_tax_unit;
1992:
1993: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
1994: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1995:
1996: IF g_user_balance_table.count > 0 THEN
1997:

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

1990: FETCH csr_tax_unit INTO l_tu_id;
1991: CLOSE csr_tax_unit;
1992:
1993: PAY_BALANCE_PKG.SET_CONTEXT('TAX_UNIT_ID',l_tu_id);
1994: PAY_BALANCE_PKG.SET_CONTEXT('DATE_EARNED',fnd_date.date_to_canonical(p_date_earned));
1995:
1996: IF g_user_balance_table.count > 0 THEN
1997:
1998: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP

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

1996: IF g_user_balance_table.count > 0 THEN
1997:
1998: FOR l_index IN g_user_balance_table.first.. g_user_balance_table.last LOOP
1999:
2000: l_balance_value := pay_balance_pkg.get_value(g_user_balance_table(l_index).defined_balance_id,p_assignment_action_id);
2001:
2002: l_uom := hr_general.decode_lookup('UNITS',g_user_balance_table(l_index).uom);
2003:
2004: