APPS.PQH_EMPLOYMENT_CATEGORY dependencies on PER_PERIODS_OF_SERVICE

Line 196: FROM per_periods_of_service

192: FUNCTION get_service_start_date(p_period_of_service_id IN NUMBER) RETURN DATE IS
193: l_start_date DATE;
194: CURSOR csr_pos_date_start IS
195: SELECT date_start
196: FROM per_periods_of_service
197: WHERE period_of_service_id = p_period_of_service_id;
198: BEGIN
199: OPEN csr_pos_date_start;
200: FETCH csr_pos_date_start INTO l_start_date;