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 367: from per_people_f ppf, per_assignments_f paf

363: -- before/after termination and re-hire.
364: /*
365: select min(ppf.effective_start_date), max(ppf.effective_end_date)
366: into l_p_start_date, l_p_end_date
367: from per_people_f ppf, per_assignments_f paf
368: where ppf.person_id = p_resource_id
369: and paf.person_id = ppf.person_id
370: and paf.assignment_id = p_assignment_id
371: and paf.effective_start_date between ppf.effective_start_date

Line 378: per_assignments_f paf,

374:
375: /* select min(ppf.effective_start_date), max(ppf.effective_end_date)
376: into l_p_start_date, l_p_end_date
377: from per_people_f ppf,
378: per_assignments_f paf,
379: per_person_types ppt,
380: per_person_type_usages_f ptu
381: where ppf.person_id = p_resource_id
382: and paf.person_id = ppf.person_id

Line 413: per_assignments_f asm

409: AND perMin.effective_start_date <= p_end_date
410: AND perMin.effective_end_date >= p_start_date)
411: AND EXISTS ( SELECT 'x'
412: FROM per_assignment_status_types ast,
413: per_assignments_f asm
414: WHERE asm.person_id = per.person_id
415: AND asm.primary_flag = 'Y'
416: AND
417: (

Line 457: per_assignments_f asm

453: )
454: AND EXISTS (
455: SELECT 'x'
456: FROM per_assignment_status_types ast,
457: per_assignments_f asm
458: WHERE asm.person_id = per.person_id
459: AND asm.primary_flag = 'Y'
460: -- Bug 6998662 -- Added the assignment check here.
461: AND asm.assignment_id = p_assignment_id