APPS.PNP_UTIL_FUNC dependencies on PER_PERIODS_OF_SERVICE

Line 4998: FROM per_periods_of_service

4994: BEGIN
4995:
4996: SELECT MAX(date_start)
4997: INTO l_hire_date
4998: FROM per_periods_of_service
4999: WHERE PERSON_ID = p_PersonId ;
5000:
5001: RETURN (l_hire_date);
5002:

Line 5181: FROM per_periods_of_service

5177: BEGIN
5178:
5179: SELECT MAX(NVL(actual_termination_date,TO_DATE('12/31/4712','mm/dd/yyyy')))
5180: INTO l_termination_date
5181: FROM per_periods_of_service
5182: WHERE person_id = p_PersonId ;
5183:
5184: IF l_termination_date = TO_DATE('12/31/4712','mm/dd/yyyy') THEN
5185: l_termination_date := NULL;