APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_BALANCE_PKG

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

196: -- retrieved
197: -- p_effective_date effective_date
198: --Note
199: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
200: -- needed by the pay_balance_pkg.get_value to get the actual balance
201: -------------------------------------------------------------------------
202: FUNCTION get_balance_value (
203: p_balance_name VARCHAR2,
204: p_tax_unit_id NUMBER,

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

209: l_jurisdiction_code VARCHAR2(20);
210: BEGIN
211: hr_utility.set_location
212: ('pay_us_mmref_local_xml.get_balance_value', 10);
213: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
214: IF p_state_abbrev <> 'FED' THEN
215: SELECT jurisdiction_code
216: INTO l_jurisdiction_code
217: FROM pay_state_rules

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

217: FROM pay_state_rules
218: WHERE state_code = p_state_abbrev;
219: hr_utility.set_location
220: ('pay_us_mmref_local_xml.get_balance_value', 15);
221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);
229: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
230: p_assignment_id,
231: p_effective_date);
232: END get_balance_value;
233: