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_ALL_ASSIGNMENTS_F

Line 57: ,per_all_assignments_f asg

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)
61: AND asg.assignment_id = p_assignment_id

Line 142: ,per_all_assignments_f asg

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)
146: AND trunc(p_calculation_date) between trunc(asg.effective_start_date)