APPS.PAY_US_MAGW2_REPORTING dependencies on PAY_BALANCE_PKG

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

121: -- retrieved
122: -- p_effective_date effective_date
123: --Note
124: -- This procedure set is a wrapper for setting the GRE/Jurisdiction context
125: -- needed by the pay_balance_pkg.get_value to get the actual balance
126: -------------------------------------------------------------------------
127: FUNCTION get_balance_value (
128: p_balance_name VARCHAR2,
129: p_tax_unit_id NUMBER,

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

134: l_jurisdiction_code VARCHAR2(20);
135: BEGIN
136: hr_utility.set_location
137: ('pay_us_magw2_reporting.get_balance_value', 10);
138: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
139: IF p_state_abbrev <> 'FED' THEN
140: SELECT jurisdiction_code
141: INTO l_jurisdiction_code
142: FROM pay_state_rules

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

142: FROM pay_state_rules
143: WHERE state_code = p_state_abbrev;
144: hr_utility.set_location
145: ('pay_us_magw2_reporting.get_balance_value', 15);
146: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
147: END IF;
148: hr_utility.trace(p_balance_name);
149: hr_utility.trace('Context');
150: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

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

150: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
151: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
152: hr_utility.set_location
153: ('pay_us_magw2_reporting.get_balance_value', 20);
154: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
155: p_assignment_id, p_effective_date);
156: END get_balance_value;
157: --------------------------------------------------------------------------
158: --Name