APPS.PAY_ES_SS_CALCULATION dependencies on PAY_BALANCE_PKG

Line 746: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);

742: IF p_context = 'TAX_UNIT_ID' THEN
743: OPEN get_legal_employer_id(to_number(p_context_val));
744: FETCH get_legal_employer_id INTO l_legal_employer_id;
745: CLOSE get_legal_employer_id;
746: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
747: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
748: END IF;
749: --
750: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);

Line 761: l_amt := pay_balance_pkg.get_value (l_def_bal_id, i.assignment_action_id);

757: l_amt := 0;
758: IF l_date <> i.start_date THEN
759: l_ctr := l_ctr + 1;
760: END IF;
761: l_amt := pay_balance_pkg.get_value (l_def_bal_id, i.assignment_action_id);
762: IF l_amt <> 0 THEN
763: l_cnt := l_cnt + 1;
764: END IF;
765: l_amount := l_amount + l_amt;

Line 1704: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);

1700: IF p_context = 'TAX_UNIT_ID' THEN
1701: OPEN get_legal_employer_id(to_number(p_context_val));
1702: FETCH get_legal_employer_id INTO l_legal_employer_id;
1703: CLOSE get_legal_employer_id;
1704: pay_balance_pkg.set_context('TAX_UNIT_ID', l_legal_employer_id);
1705: hr_utility.trace('~~~~ Setting TAX_UNIT_ID Context '||l_legal_employer_id);
1706: END IF;
1707: --
1708: hr_utility.trace('~~~~ Start loop p_period_start_date '||p_period_start_date);

Line 1723: l_days := pay_balance_pkg.get_value(l_days_def_bal_id, i.assignment_action_id);

1719: END IF;
1720: hr_utility.trace('~~~~ Inside loop p_period_start_date '||p_period_start_date);
1721: hr_utility.trace('~~~~ p_assignment_action_id '||p_assignment_action_id);
1722: IF l_days = 0 THEN
1723: l_days := pay_balance_pkg.get_value(l_days_def_bal_id, i.assignment_action_id);
1724: END IF;
1725: IF l_days <> 0 THEN
1726: p_ss_days := p_ss_days + l_days;
1727: l_amt := pay_balance_pkg.get_value(l_def_bal_id, i.assignment_action_id);

Line 1727: l_amt := pay_balance_pkg.get_value(l_def_bal_id, i.assignment_action_id);

1723: l_days := pay_balance_pkg.get_value(l_days_def_bal_id, i.assignment_action_id);
1724: END IF;
1725: IF l_days <> 0 THEN
1726: p_ss_days := p_ss_days + l_days;
1727: l_amt := pay_balance_pkg.get_value(l_def_bal_id, i.assignment_action_id);
1728: l_amount := l_amount + l_amt;
1729: IF l_amt <> 0 THEN
1730: l_cnt := l_cnt + 1;
1731: END IF;