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_ASSIGNMENT_STATUS_TYPES

Line 412: FROM per_assignment_status_types ast,

408: where perMin.person_id = per.person_id
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

Line 456: FROM per_assignment_status_types ast,

452: AND permin.effective_end_date >= p_start_date)
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.