DBA Data[Home] [Help]

APPS.IBU_DYN_USER_GROUPS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 401: FROM per_periods_of_service

397: -- bug 3032219
398: -- to get the first start date of the employee
399: CURSOR c_emp_start_date(c_person_id IN NUMBER) IS
400: SELECT date_start
401: FROM per_periods_of_service
402: WHERE person_id = c_person_id
403: ORDER BY date_start asc;
404:
405: -- to get the person detail of an employee

Line 680: FROM per_periods_of_service

676: -- bug 3032219
677: -- to get the first start date of the employee
678: CURSOR c_emp_start_date(c_person_id IN NUMBER) IS
679: SELECT date_start
680: FROM per_periods_of_service
681: WHERE person_id = c_person_id
682: ORDER BY date_start asc;
683:
684: -- to get the person detail of an employee

Line 1262: FROM per_periods_of_service

1258: -- bug 3032219
1259: -- to get the first start date of the employee
1260: CURSOR c_emp_start_date(c_person_id IN NUMBER) IS
1261: SELECT date_start
1262: FROM per_periods_of_service
1263: WHERE person_id = c_person_id
1264: ORDER BY date_start asc;
1265:
1266: -- to get the person detail of an employee