947: OPEN csr_payroll_id(l_asg_id,l_date_earned);
948: FETCH csr_payroll_id INTO l_payroll_id;
949: CLOSE csr_payroll_id;
950:
951: l_total_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_asg_end);
952: l_current_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_date_earned);
953: p_rem_pay_period := GREATEST((l_total_pay_period - l_current_pay_period),0);
954:
955:
948: FETCH csr_payroll_id INTO l_payroll_id;
949: CLOSE csr_payroll_id;
950:
951: l_total_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_asg_end);
952: l_current_pay_period := pay_in_tax_utils.get_period_number(l_payroll_id,l_date_earned);
953: p_rem_pay_period := GREATEST((l_total_pay_period - l_current_pay_period),0);
954:
955:
956:
1847: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1848: FROM per_all_assignments_f b
1849: WHERE paa.assignment_id=b.assignment_id );
1850:
1851: l_year_start := pay_in_tax_utils.get_financial_year_start(l_date_earned );
1852: l_year_end := pay_in_tax_utils.get_financial_year_end(l_date_earned );
1853:
1854: LRPP := p_rem_pay_period;
1855:
1848: FROM per_all_assignments_f b
1849: WHERE paa.assignment_id=b.assignment_id );
1850:
1851: l_year_start := pay_in_tax_utils.get_financial_year_start(l_date_earned );
1852: l_year_end := pay_in_tax_utils.get_financial_year_end(l_date_earned );
1853:
1854: LRPP := p_rem_pay_period;
1855:
1856: IF (l_asg_end_date < l_year_end AND l_asg_end_date < l_year_start)THEN