APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_PERIODS_OF_SERVICE
Line 699: FROM per_periods_of_service
695: */
696: -- rewritten the above cursor to consider the service start date as a basis for the General LOS
697: CURSOR csr_service_start_date IS
698: SELECT date_start 699: FROM per_periods_of_service 700: WHERE person_id = p_person_id
701: AND business_group_id = p_bg_id
702: AND p_determination_date BETWEEN date_start AND NVL(actual_termination_date,g_end_of_time);
703: