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.PQH_FR_SPEED dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 230: FROM per_assignment_status_types

226: AND asg.primary_flag = 'Y'
227: AND ppl.person_id = asg.person_id
228: AND ppl.per_information15 = '01' --Fonctionaires only
229: AND asg.assignment_status_type_id IN (SELECT assignment_status_type_id
230: FROM per_assignment_status_types
231: WHERE per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
232: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
233: AND p_effective_date BETWEEN ppl.effective_start_date AND ppl.effective_end_date;
234: --

Line 248: FROM per_assignment_status_types

244: AND asg.primary_flag = 'Y'
245: AND ppl.person_id = asg.person_id
246: AND ppl.per_information15 = '01' --Fonctionaires only
247: AND asg.assignment_status_type_id IN (SELECT assignment_status_type_id
248: FROM per_assignment_status_types
249: WHERE per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
250: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
251: AND p_effective_date BETWEEN ppl.effective_start_date AND ppl.effective_end_date)
252: AND information3 = p_speed