DBA Data[Home] [Help]

APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on PAY_BALANCE_PKG

Line 655: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id);

651:
652: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 20);
653:
654: /* Set up the context of tax unit id */
655: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id);
656:
657: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 30);
658:
659:

Line 680: l_value := nvl(pay_balance_pkg.get_value

676:
677: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
678: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('GROSS_EARNINGS_PER_GRE_YTD')));
679: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 50);
680: l_value := nvl(pay_balance_pkg.get_value
681: (p_defined_balance_id => bal_db_item('GROSS_EARNINGS_PER_GRE_YTD'),
682: p_assignment_action_id => l_bal_aaid),0);
683:
684: if l_value = 0 then

Line 688: l_value := nvl(pay_balance_pkg.get_value

684: if l_value = 0 then
685: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
686: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD')));
687: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 60);
688: l_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => bal_db_item('W2_NONTAX_SICK_PER_GRE_YTD'),
690: p_assignment_action_id => l_bal_aaid),0);
691:
692: if l_value = 0 then

Line 696: l_value := nvl(pay_balance_pkg.get_value

692: if l_value = 0 then
693: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
694: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD')));
695: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 70);
696: l_value := nvl(pay_balance_pkg.get_value
697: (p_defined_balance_id => bal_db_item('W2_EXPENSE_REIMB_PER_GRE_YTD'),
698: p_assignment_action_id => l_bal_aaid),0);
699:
700: if l_value = 0 then

Line 704: l_value := nvl(pay_balance_pkg.get_value

700: if l_value = 0 then
701: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
702: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD')));
703: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 80);
704: l_value := nvl(pay_balance_pkg.get_value
705: (p_defined_balance_id => bal_db_item('W2_QUAL_MOVE_PER_GRE_YTD'),
706: p_assignment_action_id => l_bal_aaid),0);
707: if l_value = 0 then
708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

Line 711: l_value := nvl(pay_balance_pkg.get_value

707: if l_value = 0 then
708: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
709: hr_utility.trace('defined_balance_id = '||to_char(bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD')));
710: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 90);
711: l_value := nvl(pay_balance_pkg.get_value
712: (p_defined_balance_id => bal_db_item('W2_NO_GROSS_EARNINGS_PER_GRE_YTD'),
713: p_assignment_action_id => l_bal_aaid),0);
714: end if;
715: end if;