APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_BALANCE_PKG

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

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

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

193: ) RETURN NUMBER IS
194: l_jurisdiction_code VARCHAR2(20);
195: BEGIN
196: hr_utility.set_location(gv_package || '.get_balance_value', 10);
197: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
198: IF p_state_abbrev <> 'FED' THEN
199: SELECT jurisdiction_code
200: INTO l_jurisdiction_code
201: FROM pay_state_rules

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

200: INTO l_jurisdiction_code
201: FROM pay_state_rules
202: WHERE state_code = p_state_abbrev;
203: hr_utility.set_location(gv_package || '.get_balance_value', 20);
204: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
205: END IF;
206: hr_utility.trace('Balance Name : '||p_balance_name);
207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);

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

207: hr_utility.trace('Context');
208: hr_utility.trace(' Tax Unit Id : '|| p_tax_unit_id);
209: hr_utility.trace(' Jurisdiction: '|| l_jurisdiction_code);
210: hr_utility.set_location('pay_us_mmref_reporting.get_balance_value', 30);
211: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
212: p_assignment_id,
213: p_effective_date);
214: END get_balance_value;
215: