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 282: FROM per_assignment_status_types ast,

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

Line 326: FROM per_assignment_status_types ast,

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