DBA Data[Home] [Help]

APPS.PER_PEOPLE_V14_PKG dependencies on PER_PERIODS_OF_SERVICE

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

295: --
296: IF g_debug THEN
297: hr_utility.set_location('Entering: '|| g_package || l_proc, 10);
298: END IF;
299: INSERT INTO PER_PERIODS_OF_SERVICE(
300: PERIOD_OF_SERVICE_ID
301: ,BUSINESS_GROUP_ID
302: ,PERSON_ID
303: ,DATE_START