APPS.PAY_NEGBAL_PKG dependencies on PAY_BALANCE_PKG

Line 88: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),

84:
85: hr_utility.trace('l_resides_true =' || l_resides_true);
86:
87: IF (l_resides_true = '1' AND
88: pay_balance_pkg.get_value(bal_db_item('GROSS_EARNINGS_PER_GRE_QTD'),
89: p_assignment_id, least(p_period_end, p_effective_end_date)) > 0) THEN
90:
91: hr_utility.trace('Returning TRUE from check_residence_state');
92:

Line 119: l_ret_value := (pay_balance_pkg.get_value(

115: p_effective_end_date);
116: l_ret_value := TRUE;
117: IF (p_state = 'CA') THEN
118: IF (p_1099R_ind = 'Y') THEN
119: l_ret_value := (pay_balance_pkg.get_value(
120: bal_db_item('SIT_WITHHELD_PER_JD_GRE_QTD') ,
121: p_assignment_id,
122: least(p_period_end, p_effective_end_date)) > 0 );
123: l_resides_in_state := l_ret_value;

Line 345: pay_balance_pkg.set_context('TAX_UNIT_ID',greid);

341: null;
342: else
343: hr_utility.set_location('pay_negbal_pkg.procngb',3);
344: -- set up contexts required to test the balance.
345: pay_balance_pkg.set_context('TAX_UNIT_ID',greid);
346: pay_balance_pkg.set_context('JURISDICTION_CODE',jd_code);
347:
348: select count(*)
349: into l_sui_exempt

Line 346: pay_balance_pkg.set_context('JURISDICTION_CODE',jd_code);

342: else
343: hr_utility.set_location('pay_negbal_pkg.procngb',3);
344: -- set up contexts required to test the balance.
345: pay_balance_pkg.set_context('TAX_UNIT_ID',greid);
346: pay_balance_pkg.set_context('JURISDICTION_CODE',jd_code);
347:
348: select count(*)
349: into l_sui_exempt
350: from pay_us_emp_state_tax_rules_f ptax,

Line 372: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id,

368: if l_sui_exempt = 0 then
369: hr_utility.set_location('pay_negbal_pkg.procngb',5);
370: if nvl(transmitter_code,'N') <> 'Y' then
371: hr_utility.set_location('pay_negbal_pkg.procngb',6);
372: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id,
373: p_assignment_action_id => lockedactid);
374: else
375: l_value := 0;
376: end if;