APPS.PAY_US_MMREF_REPORTING1 dependencies on PAY_BALANCE_PKG

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

142: -- retrieved
143: -- p_effective_date effective_date
144: --Note
145: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
146: -- needed by the pay_balance_pkg.get_value to get the actual balance
147: -------------------------------------------------------------------------
148: FUNCTION get_balance_value (
149: p_balance_name VARCHAR2,
150: p_tax_unit_id NUMBER,

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

155: l_jurisdiction_code VARCHAR2(20);
156: BEGIN
157: hr_utility.set_location
158: ('pay_us_mmref_reporting.get_balance_value', 10);
159: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
160: IF p_state_abbrev <> 'FED' THEN
161: SELECT jurisdiction_code
162: INTO l_jurisdiction_code
163: FROM pay_state_rules

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

163: FROM pay_state_rules
164: WHERE state_code = p_state_abbrev;
165: hr_utility.set_location
166: ('pay_us_mmref_reporting.get_balance_value', 15);
167: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
168: END IF;
169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location
174: ('pay_us_mmref_reporting.get_balance_value', 20);
175: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
176: p_assignment_id, p_effective_date);
177: END get_balance_value;
178: --------------------------------------------------------------------------
179: --Name