APPS.PAY_NL_TAX_PKG dependencies on STANDARD

Line 198: l_standard_pension_age NUMBER;

194: l_period_start_date DATE;
195: l_period_end_date DATE;
196: l_dob DATE;
197: l_age_last_day_month NUMBER;
198: l_standard_pension_age NUMBER;
199: l_current_year NUMBER;
200: --
201: v_last_name varchar2(100);
202: v_asg_number varchar2(50);

Line 245: FETCH get_pension_age_limit INTO l_standard_pension_age;

241: CLOSE get_period_dates;
242: --
243: --
244: OPEN get_pension_age_limit(l_period_end_date);
245: FETCH get_pension_age_limit INTO l_standard_pension_age;
246: CLOSE get_pension_age_limit;
247: --
248: OPEN get_dob;
249: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;

Line 260: IF l_age_last_day_month >= l_standard_pension_age THEN

256:
257: IF l_dob >= l_period_start_date AND l_dob <= l_period_end_date THEN
258: RETURN(TRUNC(MONTHS_BETWEEN(l_period_end_date,l_dob)));
259: ELSE
260: IF l_age_last_day_month >= l_standard_pension_age THEN
261: RETURN l_age_last_day_month;
262: ELSE
263: RETURN(TRUNC(MONTHS_BETWEEN(p_date_earned,l_dob)));
264: END IF;