[Home] [Help]
500: AND PACT.date_earned
501: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
502: BEGIN
503: --l_balance := 0;
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);
594: AND V1.effective_date
595: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
596: BEGIN
597: --l_balance := 0;
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);
709: AND PACT.date_earned
710: BETWEEN FEED.effective_start_date AND FEED.effective_end_date;
711: BEGIN
712: --l_balance := 0;
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);
741: l_balance NUMBER;
742: --
743: BEGIN
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