APPS.PER_PEOPLE_V14_PKG dependencies on DUAL

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

269: ,X_Business_Group_Id NUMBER
270: ,X_Date_Start DATE
271: ,X_Period_of_Service_Id IN OUT NOCOPY NUMBER)
272: IS
273: CURSOR C1 IS SELECT per_periods_of_service_s.NEXTVAL FROM sys.dual;
274: --
275: -- START WWBUG 1390173 fix
276: --
277: l_old ben_pps_ler.g_pps_ler_rec;

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

465: ) IS
466: l_period_of_service_id NUMBER;
467: CURSOR C IS SELECT ROWID FROM PER_ALL_PEOPLE_F
468: WHERE person_id = X_Person_Id;
469: CURSOR C2 IS SELECT per_people_s.NEXTVAL FROM sys.dual;
470: --
471: CURSOR c_person IS
472: SELECT *
473: FROM per_all_people_f