APPS.PQP_ABSVAL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 172: ,per_periods_of_service service

168: CURSOR csr_get_emp_hire_date
169: IS
170: SELECT service.date_start
171: FROM per_all_assignments_f assign
172: ,per_periods_of_service service
173: WHERE p_balance_effective_date BETWEEN assign.effective_start_date
174: AND assign.effective_end_date
175: AND assign.assignment_id = p_assignment_id
176: AND service.period_of_service_id (+) = assign.period_of_service_id;