APPS.PAY_US_MMREF_REPORTING dependencies on PAY_BALANCE_PKG

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

244: -- retrieved
245: -- p_effective_date effective_date
246: --Note
247: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
248: -- needed by the pay_balance_pkg.get_value to get the actual balance
249: -------------------------------------------------------------------------
250: FUNCTION get_balance_value (
251: p_balance_name VARCHAR2,
252: p_tax_unit_id NUMBER,

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

257: l_jurisdiction_code VARCHAR2(20);
258: BEGIN
259: hr_utility.set_location
260: ('pay_us_mmref_reporting.get_balance_value', 10);
261: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
262: IF p_state_abbrev <> 'FED' THEN
263: SELECT jurisdiction_code
264: INTO l_jurisdiction_code
265: FROM pay_state_rules

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

265: FROM pay_state_rules
266: WHERE state_code = p_state_abbrev;
267: hr_utility.set_location
268: ('pay_us_mmref_reporting.get_balance_value', 15);
269: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
270: END IF;
271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location
276: ('pay_us_mmref_reporting.get_balance_value', 20);
277: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
278: p_assignment_id, p_effective_date);
279: END get_balance_value;
280: --------------------------------------------------------------------------
281: --Name