DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_BALANCE_PKG

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

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

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

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

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

713: --l_defined_balance_id := PAY_JP_BALANCE_PKG.GET_DEFINED_BALANCE_ID(p_balance_type_id,p_assignment_action_id);
714: --
715: --IF l_defined_balance_id is not null THEN
716: -- FOR c_assignment_action_id IN csr_assignment_action_id(p_assignment_action_id, p_balance_type_id) LOOP
717: -- l_balance := l_balance + pay_balance_pkg.get_value(l_defined_balance_id, c_assignment_action_id.assignment_action_id);
718: -- END LOOP;
719: --ELSE
720: open csr_balance(p_assignment_action_id, p_balance_type_id);
721: fetch csr_balance into l_balance;

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

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