APPS.PNP_UTIL_FUNC dependencies on PER_PERIODS_OF_SERVICE

Line 5156: FROM per_periods_of_service

5152: BEGIN
5153:
5154: SELECT MAX(date_start)
5155: INTO l_hire_date
5156: FROM per_periods_of_service
5157: WHERE PERSON_ID = p_PersonId ;
5158:
5159: RETURN (l_hire_date);
5160:

Line 5339: FROM per_periods_of_service

5335: BEGIN
5336:
5337: SELECT MAX(NVL(actual_termination_date,TO_DATE('12/31/4712','mm/dd/yyyy')))
5338: INTO l_termination_date
5339: FROM per_periods_of_service
5340: WHERE person_id = p_PersonId ;
5341:
5342: IF l_termination_date = TO_DATE('12/31/4712','mm/dd/yyyy') THEN
5343: l_termination_date := NULL;