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.PQP_SERVICE_HISTORY_CALC_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 56: FROM per_periods_of_service pps

52: -- Calculate the current service period for a given assignment
53: --
54: CURSOR c_curr_serv IS
55: SELECT pps.date_start
56: FROM per_periods_of_service pps
57: ,per_all_assignments_f asg
58: WHERE pps.period_of_service_id = asg.period_of_service_id
59: AND trunc(p_calculation_date) BETWEEN trunc(asg.effective_start_date)
60: AND trunc(asg.effective_end_date)

Line 141: FROM per_periods_of_service pps

137: -- with the current service period
138: --
139: CURSOR c_overlap_serv2 IS
140: SELECT NULL
141: FROM per_periods_of_service pps
142: ,per_all_assignments_f asg
143: WHERE pps.period_of_service_id = asg.period_of_service_id
144: AND trunc(pps.date_start) between trunc(p_start_date)
145: and trunc(p_end_date)