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.HXC_TPD_END dependencies on PER_ASSIGNMENTS_F

Line 237: from per_people_f ppf, per_assignments_f paf

233: -- before/after termination and re-hire.
234: /*
235: select min(ppf.effective_start_date), max(ppf.effective_end_date)
236: into l_p_start_date, l_p_end_date
237: from per_people_f ppf, per_assignments_f paf
238: where ppf.person_id = p_resource_id
239: and paf.person_id = ppf.person_id
240: and paf.assignment_id = p_assignment_id
241: and paf.effective_start_date between ppf.effective_start_date

Line 248: per_assignments_f paf,

244:
245: /* select min(ppf.effective_start_date), max(ppf.effective_end_date)
246: into l_p_start_date, l_p_end_date
247: from per_people_f ppf,
248: per_assignments_f paf,
249: per_person_types ppt,
250: per_person_type_usages_f ptu
251: where ppf.person_id = p_resource_id
252: and paf.person_id = ppf.person_id

Line 283: per_assignments_f asm

279: AND perMin.effective_start_date <= p_end_date
280: AND perMin.effective_end_date >= p_start_date)
281: AND EXISTS ( SELECT 'x'
282: FROM per_assignment_status_types ast,
283: per_assignments_f asm
284: WHERE asm.person_id = per.person_id
285: AND asm.primary_flag = 'Y'
286: AND
287: (

Line 327: per_assignments_f asm

323: )
324: AND EXISTS (
325: SELECT 'x'
326: FROM per_assignment_status_types ast,
327: per_assignments_f asm
328: WHERE asm.person_id = per.person_id
329: AND asm.primary_flag = 'Y'
330: AND ( asm.effective_start_date <=
331: per.effective_end_date