DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL dependencies on PAY_BALANCE_PKG

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

186: -- retrieved
187: -- p_effective_date effective_date
188: --Note
189: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
190: -- needed by the pay_balance_pkg.get_value to get the actual balance
191: -------------------------------------------------------------------------
192: FUNCTION get_balance_value (
193: p_balance_name VARCHAR2,
194: p_tax_unit_id NUMBER,

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

199: l_jurisdiction_code VARCHAR2(20);
200: BEGIN
201: hr_utility.set_location
202: ('pay_us_mmref_reporting.get_balance_value', 10);
203: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
204: IF p_state_abbrev <> 'FED' THEN
205: SELECT jurisdiction_code
206: INTO l_jurisdiction_code
207: FROM pay_state_rules

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

207: FROM pay_state_rules
208: WHERE state_code = p_state_abbrev;
209: hr_utility.set_location
210: ('pay_us_mmref_reporting.get_balance_value', 15);
211: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
212: END IF;
213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location
218: ('pay_us_mmref_reporting.get_balance_value', 20);
219: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
220: p_assignment_id, p_effective_date);
221: END get_balance_value;
222: --------------------------------------------------------------------------
223: --Name