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.HRI_EDW_FCT_RECRUITMENT dependencies on PER_APPLICATIONS

Line 450: ,per_applications apl -- Application for assignment

446: NVL(apl.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))
447: last_update_date
448: ,asg.creation_date creation_date
449: FROM per_all_assignments_f asg -- Initial assignment record
450: ,per_applications apl -- Application for assignment
451: ,per_all_assignments_f emp_asg -- Pre-existing employee assignment
452: ,per_periods_of_service prev_pps -- Previously ended period of service
453: WHERE asg.assignment_type IN ('E','A')
454: AND apl.application_id (+) = asg.application_id