APPS.PAY_US_MMREF_REPORTING dependencies on PAY_BALANCE_PKG

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

259: -- retrieved
260: -- p_effective_date effective_date
261: --Note
262: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
263: -- needed by the pay_balance_pkg.get_value to get the actual balance
264: -------------------------------------------------------------------------
265: FUNCTION get_balance_value (
266: p_balance_name VARCHAR2,
267: p_tax_unit_id NUMBER,

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

272: l_jurisdiction_code VARCHAR2(20);
273: BEGIN
274: hr_utility.set_location
275: ('pay_us_mmref_reporting.get_balance_value', 10);
276: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
277: IF p_state_abbrev <> 'FED' THEN
278: SELECT jurisdiction_code
279: INTO l_jurisdiction_code
280: FROM pay_state_rules

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

280: FROM pay_state_rules
281: WHERE state_code = p_state_abbrev;
282: hr_utility.set_location
283: ('pay_us_mmref_reporting.get_balance_value', 15);
284: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
285: END IF;
286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location
291: ('pay_us_mmref_reporting.get_balance_value', 20);
292: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
293: p_assignment_id, p_effective_date);
294: END get_balance_value;
295: --------------------------------------------------------------------------
296: --Name