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_PERIODS_OF_SERVICE

Line 133: FROM per_periods_of_service pps

129: /* Cursor selecting the end date of the period of employment immediately */
130: /* following the application */
131: CURSOR end_emp_cur IS
132: SELECT pps.actual_termination_date, pps.leaving_reason
133: FROM per_periods_of_service pps
134: WHERE person_id = p_person_id
135: AND (p_date_start BETWEEN date_start
136: AND actual_termination_date
137: OR p_date_start > date_start

Line 452: ,per_periods_of_service prev_pps -- Previously ended period of service

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
455: AND asg.person_id = emp_asg.person_id (+)
456: AND emp_asg.primary_flag (+) = 'Y'

Line 469: FROM per_periods_of_service dummy

465: AND prev_pps.date_start (+) < asg.effective_start_date
466: /* If a previous period of service exists, restrict to the most recent */
467: AND NOT EXISTS
468: (SELECT 1
469: FROM per_periods_of_service dummy
470: WHERE dummy.person_id = apl.person_id
471: AND dummy.date_start > prev_pps.date_start)
472: /* Filter out all but first assignment */
473: AND asg.effective_start_date = (SELECT MIN(asg1.effective_start_date)