DBA Data[Home] [Help]

APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_US_BALANCE_VIEW_PKG

Line 61: been changed from pay_us_balance_view_pkg

57: 27-MAR-2002 meshah 115.10 2280318 the call to get_tax_balances has been
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

Line 1028: pay_us_balance_view_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

1024: fetch csr_def_balance into l_def_balance_id;
1025: --
1026: if csr_def_balance%FOUND then
1027: -- Get balance
1028: pay_us_balance_view_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
1029: l_value := nvl(pay_us_balance_view_pkg.get_value
1030: (
1031: p_defined_balance_id => l_def_balance_id
1032: ,p_assignment_action_id => p_asg_action_id

Line 1029: l_value := nvl(pay_us_balance_view_pkg.get_value

1025: --
1026: if csr_def_balance%FOUND then
1027: -- Get balance
1028: pay_us_balance_view_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
1029: l_value := nvl(pay_us_balance_view_pkg.get_value
1030: (
1031: p_defined_balance_id => l_def_balance_id
1032: ,p_assignment_action_id => p_asg_action_id
1033: ),0);