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_OPL_REC_CAND_PIPLN dependencies on PER_PERIODS_OF_SERVICE

Line 2210: ,per_periods_of_service pos

2206: ,NVL(emp.position_id, -1)
2207: ,emp.business_group_id
2208: FROM
2209: per_all_assignments_f emp
2210: ,per_periods_of_service pos
2211: WHERE emp.person_id = p_info_rec.psn_id
2212: AND emp.assignment_type = 'E'
2213: AND p_info_rec.appl_end_date + 1 BETWEEN emp.effective_start_date
2214: AND emp.effective_end_date

Line 2237: ,per_periods_of_service pos

2233: ,NVL(emp.position_id, -1)
2234: ,emp.business_group_id
2235: FROM
2236: per_all_assignments_f emp
2237: ,per_periods_of_service pos
2238: WHERE emp.assignment_id = p_info_rec.asg_id
2239: AND emp.effective_start_date = pos.date_start
2240: AND emp.period_of_service_id = pos.period_of_service_id
2241: AND emp.effective_start_date >= g_dbi_start_date;