eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: