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_GB_TP_TYPE2_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 204: from per_assignments_f pef

200: ,c_effective_start_date date
201: ,c_effective_end_date date
202: ) is
203: select distinct(pef2.assignment_id) assignment_id
204: from per_assignments_f pef
205: ,per_assignments_f pef2
206: where pef.assignment_id = c_assignment_id
207: and pef2.person_id = pef.person_id
208: and pef2.assignment_id <> pef.assignment_id

Line 205: ,per_assignments_f pef2

201: ,c_effective_end_date date
202: ) is
203: select distinct(pef2.assignment_id) assignment_id
204: from per_assignments_f pef
205: ,per_assignments_f pef2
206: where pef.assignment_id = c_assignment_id
207: and pef2.person_id = pef.person_id
208: and pef2.assignment_id <> pef.assignment_id
209: and (pef.effective_start_date between c_effective_start_date