eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_BALANCE_PKG

Line 62: to pay_balance_pkg for Tax Group balances

58: changed. Instead of calling it in the
59: sql statement we are calling it in a
60: loop. Also the get_value function has
61: been changed from pay_us_balance_view_pkg
62: to pay_balance_pkg for Tax Group balances
63: and setting the TAX GROUP context instead
64: of the TAX UNIT ID.
65: 30-APR-2002 meshah 115.11 2345031 cursor sel_aaid has been changed in load_data
66: we are now selecting effective_end_date for

Line 244: pay_balance_pkg.set_context('TAX_GROUP', p_tax_group);

240: --lv_tax_group := null;
241: ln_defined_bal_id := p_balance_id;
242: if p_tax_type in ('FUTA', 'SS ER', 'SS EE') and p_tax_group <> 'xXx' then
243:
244: pay_balance_pkg.set_context('TAX_GROUP', p_tax_group);
245:
246: ln_balance_value := pay_balance_pkg.get_value(
247: p_assignment_id => p_assignment_id
248: ,p_defined_balance_id => ln_defined_bal_id

Line 246: ln_balance_value := pay_balance_pkg.get_value(

242: if p_tax_type in ('FUTA', 'SS ER', 'SS EE') and p_tax_group <> 'xXx' then
243:
244: pay_balance_pkg.set_context('TAX_GROUP', p_tax_group);
245:
246: ln_balance_value := pay_balance_pkg.get_value(
247: p_assignment_id => p_assignment_id
248: ,p_defined_balance_id => ln_defined_bal_id
249: ,p_virtual_date => p_effective_date
250: );

Line 255: ln_balance_value := pay_balance_pkg.get_value(

251:
252: elsif p_tax_type in ('FUTA', 'SS ER', 'SS EE') and p_tax_group = 'xXx'then
253: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
254:
255: ln_balance_value := pay_balance_pkg.get_value(
256: p_defined_balance_id => ln_defined_bal_id
257: ,p_assignment_action_id => p_assignment_action_id
258: ,p_tax_unit_id => p_tax_unit_id
259: ,p_jurisdiction_code => p_jurisdiction_code

Line 267: ln_balance_value := pay_balance_pkg.get_value(

263: );
264:
265: elsif p_tax_type in ('401K') then
266: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
267: ln_balance_value := pay_balance_pkg.get_value(
268: p_defined_balance_id => ln_defined_bal_id
269: ,p_assignment_action_id => p_assignment_action_id
270: ,p_tax_unit_id => p_tax_unit_id
271: ,p_jurisdiction_code => p_jurisdiction_code

Line 284: ln_catchup_balance_value := pay_balance_pkg.get_value(

280: close c_def_bal_id;
281:
282: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
283:
284: ln_catchup_balance_value := pay_balance_pkg.get_value(
285: p_defined_balance_id => ln_catchup_defined_bal_id
286: ,p_assignment_action_id => p_assignment_action_id
287: ,p_tax_unit_id => p_tax_unit_id
288: ,p_jurisdiction_code => p_jurisdiction_code

Line 301: ln_balance_value := pay_balance_pkg.get_value(

297: ---- Added for bug 4521358
298:
299: elsif p_tax_type in ('401K ROTH') then
300: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
301: ln_balance_value := pay_balance_pkg.get_value(
302: p_defined_balance_id => ln_defined_bal_id
303: ,p_assignment_action_id => p_assignment_action_id
304: ,p_tax_unit_id => p_tax_unit_id
305: ,p_jurisdiction_code => p_jurisdiction_code

Line 314: ln_balance_value := pay_balance_pkg.get_value(

310: ------
311:
312: elsif p_tax_type in ('403B') then
313: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
314: ln_balance_value := pay_balance_pkg.get_value(
315: p_defined_balance_id => ln_defined_bal_id
316: ,p_assignment_action_id => p_assignment_action_id
317: ,p_tax_unit_id => p_tax_unit_id
318: ,p_jurisdiction_code => p_jurisdiction_code

Line 331: ln_catchup_balance_value := pay_balance_pkg.get_value(

327: close c_def_bal_id;
328:
329: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
330:
331: ln_catchup_balance_value := pay_balance_pkg.get_value(
332: p_defined_balance_id => ln_catchup_defined_bal_id
333: ,p_assignment_action_id => p_assignment_action_id
334: ,p_tax_unit_id => p_tax_unit_id
335: ,p_jurisdiction_code => p_jurisdiction_code

Line 348: ln_balance_value := pay_balance_pkg.get_value(

344: ---- Added for bug 4521358
345:
346: elsif p_tax_type in ('403B ROTH') then
347: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
348: ln_balance_value := pay_balance_pkg.get_value(
349: p_defined_balance_id => ln_defined_bal_id
350: ,p_assignment_action_id => p_assignment_action_id
351: ,p_tax_unit_id => p_tax_unit_id
352: ,p_jurisdiction_code => p_jurisdiction_code

Line 362: ln_balance_value := pay_balance_pkg.get_value(

358: -----------
359:
360: elsif p_tax_type in ('457') then
361: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
362: ln_balance_value := pay_balance_pkg.get_value(
363: p_defined_balance_id => ln_defined_bal_id
364: ,p_assignment_action_id => p_assignment_action_id
365: ,p_tax_unit_id => p_tax_unit_id
366: ,p_jurisdiction_code => p_jurisdiction_code

Line 379: ln_catchup_balance_value := pay_balance_pkg.get_value(

375: close c_def_bal_id;
376:
377: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_catchup_defined_bal_id));
378:
379: ln_catchup_balance_value := pay_balance_pkg.get_value(
380: p_defined_balance_id => ln_catchup_defined_bal_id
381: ,p_assignment_action_id => p_assignment_action_id
382: ,p_tax_unit_id => p_tax_unit_id
383: ,p_jurisdiction_code => p_jurisdiction_code

Line 394: ln_balance_value := pay_balance_pkg.get_value(

390: nvl(ln_catchup_balance_value,0);
391:
392: elsif p_tax_type in ('SDI ER', 'SDI EE', 'SUI ER', 'SUI EE') then
393: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
394: ln_balance_value := pay_balance_pkg.get_value(
395: p_defined_balance_id => ln_defined_bal_id
396: ,p_assignment_action_id => p_assignment_action_id
397: ,p_tax_unit_id => p_tax_unit_id
398: ,p_jurisdiction_code => p_jurisdiction_code

Line 408: ln_balance_value := pay_balance_pkg.get_value(

404: elsif p_tax_type in ( '401K CATCHUP', '403B CATCHUP', '457 CATCHUP','DCP') then -- #2664340
405:
406: hr_utility.trace('in to get_taxable_balance defined_balance_id : ' || to_char(ln_defined_bal_id));
407:
408: ln_balance_value := pay_balance_pkg.get_value(
409: p_defined_balance_id => ln_defined_bal_id
410: ,p_assignment_action_id => p_assignment_action_id
411: ,p_tax_unit_id => p_tax_unit_id
412: ,p_jurisdiction_code => p_jurisdiction_code