DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_BALANCE_PKG

Line 511: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);

507: --l_defined_balance_id := PAY_JP_BALANCE_PKG.GET_DEFINED_BALANCE_ID(p_balance_type_id,p_assignment_id,p_to_date);
508:
509: --IF l_defined_balance_id is not null THEN
510: -- FOR c_assignment_action_id IN csr_assignment_action_id LOOP
511: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);
512: -- END LOOP;
513: --ELSE
514: open csr_balance;
515: fetch csr_balance into l_balance;

Line 605: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);

601: --l_defined_balance_id := PAY_JP_BALANCE_PKG.GET_DEFINED_BALANCE_ID(p_balance_type_id,p_assignment_id,p_to_date);
602: --
603: --IF l_defined_balance_id is not null THEN
604: -- FOR c_assignment_action_id IN csr_assignment_action_id LOOP
605: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);
606: -- END LOOP;
607: --ELSE
608: open csr_balance;
609: fetch csr_balance into l_balance;

Line 722: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);

718: --l_defined_balance_id := PAY_JP_BALANCE_PKG.GET_DEFINED_BALANCE_ID(p_balance_type_id,p_assignment_action_id);
719: --
720: --IF l_defined_balance_id is not null THEN
721: -- FOR c_assignment_action_id IN csr_assignment_action_id(p_assignment_action_id, p_balance_type_id) LOOP
722: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);
723: -- END LOOP;
724: --ELSE
725: open csr_balance(p_assignment_action_id, p_balance_type_id);
726: fetch csr_balance into l_balance;

Line 753: l_balance := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);

749: --
750: l_defined_balance_id := PAY_JP_BALANCE_PKG.GET_DEFINED_BALANCE_ID(p_balance_type_id,p_assignment_action_id);
751:
752: IF l_defined_balance_id is not null THEN
753: l_balance := pay_balance_pkg.get_value(l_defined_balance_id, p_assignment_action_id);
754: -- Removed csr_balance cursor as _ASG_RETRO_RUN balance dimension
755: -- would not be available in R12, so the code related to it has been
756: -- obsoleted. Commented the below code as per Bug# 5033803.
757: /*