APPS.PQP_SERVICE_HISTORY_CALC_PKG dependencies on DUAL

Line 24: FROM dual;

20: hr_utility.set_location('Entering: '||l_proc, 10);
21: --
22: SELECT l_end_date - l_start_date
23: INTO l_days
24: FROM dual;
25: --
26: l_days := l_days + 1;
27: p_days := l_days;
28: --

Line 110: FROM dual;

106: hr_utility.set_location('Entering: '||l_proc, 10);
107: --
108: SELECT ADD_MONTHS(p_start_date,(p_period_years * 12))
109: INTO l_end_date
110: FROM dual;
111:
112: hr_utility.set_location(l_proc, 20);
113: SELECT l_end_date - p_start_date
114: INTO l_days

Line 115: FROM dual;

111:
112: hr_utility.set_location(l_proc, 20);
113: SELECT l_end_date - p_start_date
114: INTO l_days
115: FROM dual;
116:
117: p_days := l_days;
118:
119: hr_utility.set_location('Leaving: '||l_proc, 30);

Line 672: FROM dual;

668: hr_utility.set_location('Entering: '||l_proc, 10);
669: --
670: SELECT (l_end_date - l_start_date)
671: INTO l_tot_days
672: FROM dual;
673: --
674: hr_utility.set_location(l_proc, 30);
675: --
676: -- The following conversion of days to years

Line 688: -- FROM dual;

684: --
685:
686: -- SELECT MOD(l_tot_days,365)
687: -- INTO l_days
688: -- FROM dual;
689: --
690: -- l_days := l_days + 1 ;
691: -- --
692: -- IF l_days = 365 THEN

Line 700: FROM dual;

696:
697: -- Get the number of years based on date using MONTHS_BETWEEN function
698: SELECT TRUNC(MONTHS_BETWEEN(l_end_date, l_start_date)/12)
699: INTO l_years
700: FROM dual;
701:
702: -- Get the new start date based on the l_years figure from the start date
703:
704: hr_utility.set_location(l_proc, 40);

Line 707: FROM dual;

703:
704: hr_utility.set_location(l_proc, 40);
705: SELECT ADD_MONTHS(l_start_date, l_years * 12)
706: INTO l_new_start_date
707: FROM dual;
708:
709: -- Get the number of days based on this new start date
710:
711: hr_utility.set_location(l_proc, 50);

Line 714: FROM dual;

710:
711: hr_utility.set_location(l_proc, 50);
712: SELECT l_end_date - l_new_start_date
713: INTO l_days
714: FROM dual;
715:
716:
717: --
718: p_years := l_years;