826: OPEN csr_payroll_id(l_asg_id,l_date_earned);
827: FETCH csr_payroll_id INTO l_payroll_id;
828: CLOSE csr_payroll_id;
829:
830: l_total_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_asg_end);
831: l_current_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_date_earned);
832: p_rem_pay_period := GREATEST((l_total_pay_period - l_current_pay_period),0);
833:
834:
827: FETCH csr_payroll_id INTO l_payroll_id;
828: CLOSE csr_payroll_id;
829:
830: l_total_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_asg_end);
831: l_current_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_date_earned);
832: p_rem_pay_period := GREATEST((l_total_pay_period - l_current_pay_period),0);
833:
834:
835: