[Home] [Help]
503: AND PACT.date_earned
504: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
505: BEGIN
506: --l_balance := 0;
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);
597: AND V1.effective_date
598: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
599: BEGIN
600: --l_balance := 0;
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);
714: AND PACT.date_earned
715: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
716: BEGIN
717: --l_balance := 0;
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);
746: l_balance NUMBER;
747: --
748: BEGIN
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