APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_BALANCE_PKG

Line 179: -- needed by the pay_balance_pkg.get_value to get the actual balance

175: -- p_effective_date effective_date
176: --
177: -- Note
178: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
179: -- needed by the pay_balance_pkg.get_value to get the actual balance
180: -------------------------------------------------------------------------
181: FUNCTION get_balance_value (p_balance_name VARCHAR2,
182: p_tax_unit_id NUMBER,
183: p_state_abbrev VARCHAR2,

Line 190: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

186: ) RETURN NUMBER IS
187: l_jurisdiction_code VARCHAR2(20);
188: BEGIN
189: hr_utility.set_location(gv_package || '.get_balance_value', 10);
190: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
191: IF p_state_abbrev <> 'FED' THEN
192: SELECT jurisdiction_code
193: INTO l_jurisdiction_code
194: FROM pay_state_rules

Line 197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);

193: INTO l_jurisdiction_code
194: FROM pay_state_rules
195: WHERE state_code = p_state_abbrev;
196: hr_utility.set_location(gv_package || '.get_balance_value', 20);
197: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
198: END IF;
199: hr_utility.trace('Balance Name : '||p_balance_name);
200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);

Line 204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

200: hr_utility.trace('Context');
201: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
202: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
203: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
204: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
205: p_assignment_id,
206: p_effective_date);
207: END get_balance_value;
208: