APPS.PAY_AU_TERMINATIONS dependencies on DUAL

Line 2408: from dual;

2404: ELSE -- paid in a year after the termination
2405:
2406: select months_between(l_year_end_paid, l_year_end_atd)/12
2407: into l_count_year
2408: from dual;
2409:
2410: for i in 0 .. (l_count_year-1) loop
2411:
2412: open c_max_asg_action_id (add_months(l_year_start_atd,l_add), add_months(l_year_end_atd,l_add));

Line 2838: from dual;

2834: ELSE -- l_year_end_atd <> l_year_end_paid
2835:
2836: select months_between(l_year_end_paid, l_year_end_atd)/12
2837: into l_count_year
2838: from dual;
2839:
2840: for i in 0 .. (l_count_year-1) loop -- until the current financial year
2841:
2842: open c_max_asg_action_id (add_months(l_year_start_atd,l_add), add_months(l_year_end_atd,l_add));

Line 3531: from dual;

3527: ELSE -- l_year_end_atd <> l_year_end_paid
3528:
3529: select months_between(l_year_end_paid, l_year_end_atd)/12
3530: into l_count_year
3531: from dual;
3532:
3533: for i in 0 .. (l_count_year-1) loop
3534:
3535: open c_max_asg_action_id (add_months(l_year_start_atd,l_add), add_months(l_year_end_atd,l_add));

Line 4220: from dual;

4216: l_add :=0;
4217:
4218: select months_between(l_year_end_paid, l_year_end_atd)/12
4219: into l_count_year
4220: from dual;
4221:
4222: for i in 0 .. (l_count_year-1) loop -- until the current financial year
4223:
4224: l_excluded_prev := 0;