APPS.PER_PEOPLE_V14_PKG dependencies on PER_PERIODS_OF_SERVICE

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 262: INSERT INTO PER_PERIODS_OF_SERVICE(

258: OPEN C1;
259: FETCH C1 INTO X_Period_of_Service_Id;
260: CLOSE C1;
261: --
262: INSERT INTO PER_PERIODS_OF_SERVICE(
263: PERIOD_OF_SERVICE_ID
264: ,BUSINESS_GROUP_ID
265: ,PERSON_ID
266: ,DATE_START