APPS.PAY_US_DEF_COMP_457 dependencies on PAY_BALANCE_PKG

Line 424: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id );

420:
421: hr_utility.set_location('Entering:'||l_proc, 5);
422:
423: g_get_bal_flag := 'CORRECT';
424: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id );
425: pay_balance_pkg.set_context('date_earned', p_effective_date);
426:
427: IF (p_balance_name <> 'Def Comp 457'
428: AND p_balance_name <> 'Calc 457 Limit') THEN

Line 425: pay_balance_pkg.set_context('date_earned', p_effective_date);

421: hr_utility.set_location('Entering:'||l_proc, 5);
422:
423: g_get_bal_flag := 'CORRECT';
424: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id );
425: pay_balance_pkg.set_context('date_earned', p_effective_date);
426:
427: IF (p_balance_name <> 'Def Comp 457'
428: AND p_balance_name <> 'Calc 457 Limit') THEN
429: SELECT /*+ USE_NL (pbd) */

Line 456: l_balance := NVL(pay_balance_pkg.get_value(l_defined_balance_id,

452:
453: hr_utility.set_location('Balance = ' || p_balance_name || ' ' ||
454: TO_CHAR(l_defined_balance_id) || ' ' || TO_CHAR(p_assignment_id), 15);
455:
456: l_balance := NVL(pay_balance_pkg.get_value(l_defined_balance_id,
457: p_assignment_id ,
458: p_effective_date ), 0);
459: hr_utility.set_location('Leaving:'||l_proc, 1000);
460:

Line 929: -- pay_balance_pkg.get_value returns unhandled exception

925: END IF;
926:
927: -- The above IF statement takes care if the employee was terminated. Otherwise
928: -- if the emp is terminated and 31-DEC-YYYY is passed, then
929: -- pay_balance_pkg.get_value returns unhandled exception
930:
931: IF ((g_old_rec.person_id = l_person_id ) AND
932: (g_old_rec.tax_unit_id = l_tax_unit_id ) AND
933: (UPPER(g_old_rec.element_information1) =