APPS.PER_PEOPLE_V14_PKG dependencies on DUAL

Line 246: CURSOR C1 IS SELECT per_periods_of_service_s.NEXTVAL FROM sys.dual;

242: ,X_Business_Group_Id NUMBER
243: ,X_Date_Start DATE
244: ,X_Period_of_Service_Id IN OUT NOCOPY NUMBER)
245: IS
246: CURSOR C1 IS SELECT per_periods_of_service_s.NEXTVAL FROM sys.dual;
247: --
248: -- START WWBUG 1390173 fix
249: --
250: l_old ben_pps_ler.g_pps_ler_rec;

Line 425: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;

421: ) IS
422: l_period_of_service_id NUMBER;
423: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F
424: WHERE person_id = X_Person_Id;
425: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
426: --
427: CURSOR c_person IS
428: SELECT *
429: FROM per_all_people_f